Parsing with RegEx

[ksamuel]

Hi all, 

I'd appreciate if someone could lend a hand. It seems straight forward but I just cant seem to crack it. Col1 is what I have and Col2/ Col3 are what I require.

I want to parse out the characters in Col2 and Col3 from Col1. As you can see the outputs can vary in length. The output in Col 2 is always preceded by "A" ; however, the output in Col3 can be preceded by different characters.

[MilindG · Accepted solution]

Check out the attached file.

[ChrisTX]

For Col2, can you use the Text to Column tool, take the second column, then use the Substring or ReplaceChar function to remove the A?

For Col3, try the RegEx tool in Parse mode with this expression:      .*?(\d*)\)$

Chris

[binuacs]

@ksamuel One way of doing this with the Regex_Replace function

[Emmanuel_G]

Hi @ksamuel ,

Find attached the way to do this with regex function in formula tool.

Cheers !