Parsing with RegEx

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.

Regex

Accepted answers

Check out the attached file.

Regex_Sample.yxmd

All comments

Check out the attached file.

Regex_Sample.yxmd

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

@ksamuel One way of doing this with the Regex_Replace function

Regex_0829.yxmd

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

Cheers !

Parsing Regex.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 390

michael_weaver 335