regular expression help

[10005970]

Hi

I have a data field that contains location/document header/line number. the format is as follows:

217/101212/1

217/10012/10

212/1002003/100

I am trying to extract just the order header (the bit in the middle of the //) I am using the regex tool in parse to create an extra field "Order Header" but I cannot seem to get the expression correct.

Your help would be appreciated.

[binuacs · Accepted solution]

@10005970 

REGEX_Replace([Data], '(.+)\/(.+)\/(.+)', '$2')

[atcodedog05 · Accepted solution]

Hi @10005970 

My take on this

REGEX_Replace([Input], ".*/(\d+)/.*", "$1")

Hope this helps : )

[10005970]

Spot on, thank you 

[atcodedog05]

Happy to help : ) @10005970 

Cheers and have a nice day!