Separates Columns

[sgaryali]

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?

[vsoni · Accepted solution]

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

[messi007]

@sgaryali,

You can use LEFT and Right functions to do that :

Attached the workflow,

Hope this helps!

Regards

[atcodedog05 · Accepted solution]

Hi @sgaryali 

My take on this using Regex tool parse mode.

Workflow:

Hope this helps : )