Regex

I'm trying to use Regex in Alteryx Designer and I want to convert dates in an excel file to ISO 8601 format in Alteryx Designer. I want to begin by parsing the field into like a column 1, column 2, column 3 of the dates in mm/dd/yyyy format. Any info on how I might do this would be helpful.

Regex

Accepted answers

Jonathan-Sherman

Hi @kosikoya,

You could achieve this using regex inside a formula tool:

REGEX_Replace([Date String], '(\d+).*?(\d+).*?(\d+)', '$3-$1-$2')

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20191203 - CreatingDates.yxmd

All comments

BrandonB

Have you taken a look at the Date Time tool? It can take strings and convert them to dates or do the reverse and take dates into string formats as needed.

https://help.alteryx.com/current/designer/tools/parse/datetime-tool

kosikoya

I tried to use that but for example my excel file contains dates in the format of (11.,.-14'--/1954) with different punctuation's in between. I'm trying to get it to read the different punctuation's in between and format it to ISO 8601 in the form like mm/dd/yyyy.

Jonathan-Sherman

Hi @kosikoya,

You could achieve this using regex inside a formula tool:

REGEX_Replace([Date String], '(\d+).*?(\d+).*?(\d+)', '$3-$1-$2')

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20191203 - CreatingDates.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703