Parse Cell - Multiple Occurences

[mystasz]

Hi Community,

In the attached input, the Changes column contains free text where a T100 number exists followed by 5 numbers (e.g T100-XXXXX). I've managed to parse the first occurrence out by using Regex Parse with the following expression: (T100-\d*). 

For event ID 222, there's 3 T100 numbers but I only get the first one (T100-84904). Any idea how I can do this? 

I created a separate tab for expected output. Thanks in advance. 

[binuacs · Accepted solution]

@mystasz One way of doing this with the Regex tokenize 

[BS_THE_ANALYST · Accepted solution]

@mystasz here's one way you can do it. It's dynamic aswell. It will make new columns for every occurrence of:
'T100\s*-\s*\d{5}' in the string

[mystasz]

Thank you @binuacs . This doesn't work completely since Event ID 222 has three T100 numbers. The one that was not caught was the one that has a space in it (T100 - 84885) while the others worked because they do not have spaces (T100-84904). Any suggestions?

[binuacs]

@mystasz The workflows I uploaded should work, can you download and try again?