Regex Help for parsing data in long string

chvizda — Thu, 13 Jun 2024 22:19:42 GMT

Hi all

I have a dataset with several xml fields which look lijke this:

The structure is different but I need to parse everytime the data within the " " behind the hrefName= marked in fat above.

Is there an easy way to extract these data into a new field ?

Many thanks for your support

Steffen

Re: Regex Help for parsing data in long string

philipmannering — Thu, 26 Sep 2019 17:11:22 GMT

Yes. You can parse using the Regex tool and use this pattern,

hrefName="(.*?)"

Like so,

chvizda — Fri, 27 Sep 2019 06:19:08 GMT

Thx ! That's exactly what I need.