Hi all,
Wonder if anyone can help, I have a text string 001_USA_CALIFORNIA_LA_FIRST_ST and I want to be able to extract CALIFORNIA_LA, but also have the ability to apply this to other state/city combinations.
Any help would be appreciated.
Thanks
Solved! Go to Solution.
Regex_replace([field],”.*?_.*?_(.*?_.*?)_.*”,’$1’)
that might work.
Cheers,
Mark
Thanks Mark! That works perfectly. Can you explain the theory behind it? I haven't used Regex much.
Thanks Mark. Appreciate the explanation.