Extract text which starts from specific characters in string

[RamyaGunasekaran]

Hello All,

I have a filed value like

\\xx.com\Z00001\google

\\xx.com\Z00002\google

I want output as 

Z00001

Z00002

Help please!

[DawnDuong]

Hi @RamyaGunasekaran 

If the structure is always fixed, and you are less family with Regex, probably safer for you to use the standard Text to Column tool with \ as delimiter.

Dawn

[RamyaGunasekaran]

I want it in regex. Pls help on it @DawnDuong 

[OllieClarke · Accepted solution]

Hey @RamyaGunasekaran 

If you want to get everything which starts with a Z and then is made of numbers then the following should get what you want:

(Z\d+)

With the RegEx tool in Parse mode

If you also want to specify that they should fall between '\' then update the RegEx to

\\(Z\d+)\\

Hope that helps,

Ollie

[apathetichell]

REGEX_Replace([Field1],"\\\\.*\\(.*)\\\w+","$1")

This should look for the last entry which has a word and a preceding "\" it then should grab the data between that backslash and penultimate slash.