Need help with regex, to search consistant for string value

Help Studio
1

Hello guys, i need help creating a regex to extract this sentence -

“husnummertekst”:“10”,“id_lokalId”:“0a3f508a-91f7-32b8-e044-0003ba298018”

where the “10” is dynamic and altso the “0a3f508a-91f7-32b8-e044-0003ba298018” is dynamic:

here i the whole json string i need to search within, i have bold texted the tekst i need to create a regex for, can anyone guide me to the right course i have been trying for a while now, cant seem to get it right, appreciate.

[{“datafordelerOpdateringstid”:“2021-01-05T11:45:42.434059+01:00”,“adressebetegnelse”:“Gammel Skårupvej 14A, 5700 Svendborg”,“dørbetegnelse”:“”,“etagebetegnelse”:“”,“forretningshændelse”:“2”,“forretningsområde”:“54.15.10.08”,“forretningsproces”:“0”,“id_lokalId”:“0a3f50b5-758f-32b8-e044-0003ba298018”,“id_namespace”:“http://data.gov.dk/dar/adresse",“registreringFra”:“2018-05-03T18:58:34.000000+02:00”,“registreringsaktør”:“DAR”,“status”:“3”,“virkningFra”:“2000-02-05T09:29:40.000000+01:00”,“virkningsaktør”:“Konvertering2017”,“husnummer”:{“datafordelerOpdateringstid”:“2021-01-05T18:19:21.065261+01:00”,“adgangsadressebetegnelse”:"Gammel Skårupvej 14A, 5700 Svendborg”,“adgangTilBygning”:“8974cc61-b64b-4011-bc47-8ace4c8fcb6b”,“afstemningsområde”:{“id”:“705356”,“afstemningsområdenummer”:“03”,“navn”:“Østre”},“forretningshændelse”:“3”,“forretningsområde”:“54.15.10.07”,“forretningsproces”:“0”,“geoDanmarkBygning”:“1037054628”,“husnummerretning”:“POINT(0.92803142265048 0.372501917543152)”,“husnummertekst”:“14A”,“id_lokalId”:“0a3f508a-5ae9-32b8-e044-0003ba298018”,“id_namespace”:“http://data.gov.dk/dar/husnummer",“jordstykke”:“2545061”,“kommuneinddeling”:{“id”:“389162”,“kommunekode”:“0479”,“navn”:“Svendborg”},“registreringFra”:“2018-07-04T18:00:00.000000+02:00”,“registreringsaktør”:“DAR”,“sogneinddeling”:{“id”:“60024”,“sognekode”:“9139”,“navn”:“Fredens”},“status”:“3”,“vejmidte”:“0479-2186”,“virkningFra”:“2018-07-04T18:00:00.000000+02:00”,“virkningsaktør”:“DARTransition”,“adgangspunkt”:{“datafordelerOpdateringstid”:“2021-01-05T13:31:28.913090+01:00”,“oprindelse_kilde”:“Adressemyn”,“oprindelse_nøjagtighedsklasse”:“A”,“oprindelse_registrering”:“2005-02-22T00:00:00.000000+01:00”,“oprindelse_tekniskStandard”:“TK”,“position”:"POINT(604792.11 6103605.25)”},“vejpunkt”:{“datafordelerOpdateringstid”:“2021-01-05T13:41:54.217821+01:00”,“oprindelse_kilde”:“Ekstern”,“oprindelse_nøjagtighedsklasse”:“B”,“oprindelse_registrering”:“2018-05-03T14:08:02.125000+02:00”,“oprindelse_tekniskStandard”:“V0”,“position”:“POINT(604804.768501347 6103612.89974182)”},“navngivenVej”:{“datafordelerOpdateringstid”:“2021-01-05T19:53:45.976568+01:00”,“administreresAfKommune”:“0479”,“forretningshændelse”:“20”,“forretningsområde”:“10.00.00.00”,“forretningsproces”:“0”,“id_lokalId”:“a9f09d0e-12b0-4fbb-857a-61895bad90c3”,“id_namespace”:“http://data.gov.dk/dar/navngivenvej",“registreringFra”:“2019-09-12T16:59:04.599416+02:00”,“registreringsaktør”:“DAR”,“status”:“3”,“udtaltVejnavn”:"Gammel Skårupvej”,“vejadresseringsnavn”:“Gammel Skårupvej”,“vejnavn”:“Gammel Skårupvej”,“vejnavnebeliggenhed_oprindelse_kilde”:“Ekstern”,“vejnavnebeliggenhed_oprindelse_nøjagtighedsklasse”:“B”,“vejnavnebeliggenhed_oprindelse_registrering”:“2019-09-12T17:01:43.697547+02:00”,“vejnavnebeliggenhed_oprindelse_tekniskStandard”:“NO”,“vejnavnebeliggenhed_vejnavnelinje”:“MULTILINESTRING((605480.08 6104550.79,605482.89 6104544.95,605487.1 6104536.21,605490.98 6104526.5,605500.2 6104503.05,605508.02 6104483.75,605520.98 6104451.03,605528.37 6104433.38,605536.49 6104414.5,605537.91 6104410.63,605538.52 6104407.58,605538.48 6104405.53,605538.43 6104403.43,605536.6 6104397.47,605531.89 6104387.89,605517.79 6104359.56,605508.65 6104342.57,605499.67 6104328.42,605491.17 6104317.41,605476.86 6104302.46,605458.97 6104284.48,605432.93 6104257.97,605413.8 6104238.07,605391.62 6104215.89,605370.57 6104194.77,605354.86 6104179.23,605342.36 6104166.54,605326.87 6104150.43,605307.11 6104129.83,605302.79 6104125.21,605298.08 6104126.74,605293.82 6104127.25,605288.25 6104125.75,605278.39 6104121.53,605266.8 6104116.27,605257.21 6104112.35,605249.12 6104109.84,605240.32 6104107.74,605231.19 6104106.2),(605302.79 6104125.21,605292.05 6104113.72,605282.06 6104103.12),(605314.47 6104081.98,605307.05 6104090.78,605303.93 6104092.28,605294.84 6104096.74,605288.53 6104099.83,605282.06 6104103.12,605276.77 6104097.68,605268.38 6104089.43,605262.65 6104084.36,605252.47 6104077.25,605245.34 6104072.59,605237.87 6104068.22,605228.93 6104063.12,605215.42 6104055.55,605200.1 6104046.92,605182.55 6104036.92,605172.65 6104031.31,605169.57 6104028.96,605167.22 6104026.01,605165.17 6104020.38,605162.79 6104009.41,605158.63 6104009.49,605145.28 6104008.24,605137.16 6104007.33,605127.67 6104004.68,605112.14 6103998,605096.55 6103989.48,605080.12 6103980.24,605069.28 6103974.34,605059.28 6103968.88,605044.42 6103960.62,605035.43 6103955.64,605022.72 6103948.77,605011.5 6103943.03,604997.28 6103936.32,604985.61 6103931.32,604964.54 6103922.64,604952.43 6103918.51,604934.45 6103911.31,604924.61 6103907.66,604916.9 6103905.01,604904.65 6103900.81,604891.47 6103896.93,604881.15 6103893.63,604879.97 6103893.18,604873.53 6103890.71,604861.8 6103884.61,604842.36 6103876.26,604832.26 6103871.58,604828.44 6103869.91,604819.46 6103865.04),(604883.54 6103833.67,604862.31 6103835.62,604856.43 6103845.45,604841.71 6103852.12,604836.56 6103854.5,604827.83 6103858.54,604824.75 6103860.93,604819.46 6103865.04,604814.09 6103862.13,604804.97 6103856.2,604792.21 6103846.22,604791.33 6103845.41,604774.77 6103830.28,604769.96 6103825.88,604761.71 6103818.33,604752.87 6103809.91,604751.21 6103808.26,604750.22 6103807.2,604749.78 6103806.49,604749.39 6103805.6,604749.1 6103804.44,604748.73 6103802.73,604748.2 6103798.33,604747.9 6103796.32,604744.51 6103773.82,604743.34 6103765.4,604741.44 6103751.75,604740.34 6103742.08,604740.06 6103739.64,604740.13 6103726.55,604740.43 6103718.51,604741.54 6103712.43,604744.13 6103702,604746.11 6103692.43,604747.47 6103683.23,604747.67 6103671.14,604747.25 6103663.28,604746.39 6103657.51),(604759.84 6103703.61,604761.53 6103700.77,604770.54 6103685.64,604781.1 6103670.53,604789.37 6103660.99,604796.97 6103652.84,604803.86 6103645.63),(604805.56 6103611.59,604804.72 6103612.98,604800.39 6103620.12,604794.67 6103627.83,604790.53 6103632.39,604789.6 6103631.46,604773.3 6103615.99,604768.2 6103611.14),(604869.38 6103604.87,604851.85 6103613.01,604837.51 6103621.01,604819.9 6103632.36,604806.35 6103643.03,604803.86 6103645.63,604790.53 6103632.39,604788.19 6103634.97,604783.61 6103639.2,604772.87 6103645.91,604771.28 6103646.66,604757.27 6103653.31,604752.49 6103655.16,604746.39 6103657.51,604745.79 6103653.43,604743.73 6103645.11,604741.19 6103637.2,604737.43 6103628.36,604731.86 6103617.24,604722.52 6103599.37,604708.4 6103572.4,604701.69 6103561.67,604696.26 6103552.92,604687.96 6103540.78))”,“virkningFra”:“2019-09-12T17:01:43.697547+02:00”,“virkningsaktør”:“AjourføreGeoDKTilknytning”,“navngivenVejKommunedelList”:[{“id_lokalId”:“5cac3c78-4eae-11e8-93fd-066cff24d637”,“navngivenVejKommunedel”:{“datafordelerOpdateringstid”:“2021-01-05T19:56:57.151311+01:00”,“forretningshændelse”:“20”,“forretningsområde”:“10.00.00.00”,“forretningsproces”:“0”,“id_lokalId”:“5cac3c78-4eae-11e8-93fd-066cff24d637”,“id_namespace”:“http://data.gov.dk/dar/navngivenvejkommunedel",“kommune”:“0479”,“navngivenVej”:“a9f09d0e-12b0-4fbb-857a-61895bad90c3”,“registreringFra”:“2019-09-12T16:59:04.599416+02:00”,“registreringsaktør”:“DAR”,“status”:“3”,“vejkode”:“2186”,“virkningFra”:“2019-09-12T17:01:43.697547+02:00”,“virkningsaktør”:"AjourføreGeoDKTilknytning”}}]strong text

2

grafik
grafik764×227 7.25 KB

(?<=“husnummertekst”:").*?(?=")

similar we can do it with id_lokalid.

As it is JSON Data a retrieval based on JSON Processing is maybe more to prefer

3

Hi @Kristoffer_Barstad

Try this regex pattern

“husnummertekst”:“\w+”,“id_lokalId”:“[\w\-]+”
4

Thanks, its working now!

5

This can be useful for you.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.