Regex: Last four numbers after last comma

[carlcmat]

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.

[MarqueeCrew]

Regex_Replace([Field],".*?,(\d{4}).8",'$1')

That's the droid that you're looking for.

Cheers,

Mark

[carlcmat]

It didnt work for me. Can you see the attached image and please upload the solution? :)

[MarqueeCrew]

That's a different pattern!

Regex_Replace([Original field],".*,.*(\d{4}).8",'$1')

becomes:

Regex_Replace([Original Field],".*?,.*(\d{4}).*",'$1')

 Cheers,

Mark

[carlcmat]

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

[ponraj]

Here is the sample workflow for your case.  Hope this is helpful. 

WorkflowResults

[danrh · Accepted solution]

Give this a shot:

[ponraj]

Possible to share the sample data in text format ?