Parse Cell - Multiple Occurences

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.

Parse Cell - Multiple Occurences.xlsx

Datasets

Regex

Parse

Common Use Cases

Accepted answers

@mystasz One way of doing this with the Regex tokenize

Regex_Tokenizw_220223.yxmd

Regex_Tokenizw_220223_1.yxmd

@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

TokenizeExample220223.yxmd

All comments

@mystasz One way of doing this with the Regex tokenize

Regex_Tokenizw_220223.yxmd

Regex_Tokenizw_220223_1.yxmd

@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

TokenizeExample220223.yxmd

Thank you @binu_acs . 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?

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703