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.
Solved! Go to Solution.
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')
Cheers,
Mark
No, not really.
1) It shall parse ONLY four numbers which stands alone
2) It shall parse ONLY those four numbers AFTER THE LAST COMMA in the string
Possible to share the sample data in text format ?