Regex Parse Help

[jenner85]

Hi - 

How do I parse out 

Q3_2021_Leads

to make it 

Q3 2021

Thanks!

[phottovy]

Hi @jenner85 

I was able to use the RegEx tool with the replace option to accomplish this. Here is my expression:

(Q\d)_(\d{4})

Q\d = find the letter Q followed by a single digit

\d{4} = find 4 digits

By putting those two in parentheses, I can keep those original values by using $1 and $2 in the "Replacement Text" section.

[JagdeeshN]

Hi @jenner85 ,

Is regex a requirement to do this?

Have you looked into using the text to columns tool?

Please find attached a sample workflow to do that.

Hope this helps.

Best,

Jagdeesh