Gatejalla 1, 0355 Oslo
Gatejalla 1, 5645, 0215 Oslo
Gatejalla 1, asdasd, 0545 Oslo
I need an Regex expression where it parse the last four numbers AFTER THE LAST COMMA in a string.
Give this a shot:
Regex_Replace([Field],".*?,(\d{4}).8",'$1')
That's the droid that you're looking for.
Cheers,
Mark
It didnt work for me. Can you see the attached image and please upload the solution?
Here is the sample workflow for your case. Hope this is helpful.
WorkflowResults