i want to trying to separate dates into three columns alteryx

[meziane36u]

Hello ! 

I  want to trying to separate dates into three columns alteryx, where does this formula (\d+).(\d+).(\d+) ?

[atcodedog05 · Accepted solution]

Hi @meziane36u 

You can use Regex Tool and Parse to split to columns.

Hope this helps 🙂

[leon2020]

Looks like you are using a REGEX formula or tool.  And I guess the three columns you want to separate a date into is the day, month and year.  I assume the date is already formatted and recognised as a date.

In that case, I would not use REGEX.  I would use the formula tool and use the following built-in functions:

DateTimeDay([FieldName])

DateTimeMonth([FieldName])

DateTimeYear([FieldName])

If the date you have is not yet formatted or recognised as a date, you can add a step to parse/format as a date first, then do the above.  I should note, you could use REGEX and that would work also - more than one solution here, matter of preference.

[meziane36u]

Thank you very much it works  😀

[atcodedog05]

Happy to help 🙂 @meziane36u 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂