Need to extract specific text from a column

[Hoss2434]

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. 

Before	After
Random Text, ISSUE 23452,	ISSUE 23452
Random Text, Random Text, ISSUE 45645,	ISSUE 45645
ISSUE 9785, Random Text, Random Text	ISSUE 9785

Any help would be greatly appreciated.

Thanks!

[ncrlelia]

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

[Qiu]

@Hoss2434 
I tired a different approach.

[binay2448]

This may also help .....