Separates Columns

Question

I want to separate dates in the two different columns like :-

Date1                               Date 2

01-JUL-21                       31-JUL-21

I thing I can think of is trim fn but problem here is it will work fine for this particular month but when I get next month data suppose for August I don't think this will for it.

What can be the best way for this to workout?

Test Data New.xlsx

vsoni · Accepted Answer

Easiest way would be to use ReGex and tokenise:

More info on RegEx can be found here: https://help.alteryx.com/20213/designer/regex-tool

atcodedog05 · Accepted Answer

Hi @sgaryali

My take on this using Regex tool parse mode.

Workflow:

Hope this helps : )