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?
That's a different pattern!
Regex_Replace([Original field],".*,.*(\d{4}).8",'$1')
becomes:
Regex_Replace([Original Field],".*?,.*(\d{4}).*",'$1')
Here is the sample workflow for your case. Hope this is helpful.
WorkflowResults
