Hi -
How do I parse out
Q3_2021_Leads
to make it
Q3 2021
Thanks!
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.
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