Need to extract specific text from a column

Question

I have a column that contains a specific set of text that I need to be retained and the rest removed or moved to another column. Unfortunately, I am not able to use normal text-to-column due to the variation of the test arrangement.

Like the example below, I need the word Issue and the id associated with it to be separated. I am struggling to figure out a way to do this with the variation of the text arranged.

BeforeAfterRandom Text, ISSUE 23452,ISSUE 23452Random Text, Random Text, ISSUE 45645,ISSUE 45645ISSUE 9785, Random Text, Random TextISSUE 9785

Any help would be greatly appreciated.

Thanks!

Data.PNG

binay2448 · Answer

This may also help .....

Need to extract specific text from a column.yxmd

Qiu · Answer

@Hoss2434 
I tired a different approach.

New Workflow1.yxmd

ncrlelia · Answer

Hi @Hoss2434,

You can use a Regex tool with the pattern 'ISSUE \d+' to parse out the word Issue and respective ID.

note: \d = digit and + = one or more

Please see below for details on the suggested solution.

Hope this helps.

Cheers,

Lelia