extracting date from a string

[vamsey]

Hi Alteryx Community,

I have columns as shown below.

loan activites 12/11/2021 12.00.00

loan activites_NA 12/11/2021 11.33.99

I have to extract date from the string. Can anyone help 

[PhilipMannering]

Hi @vamsey 

You can use the Text-to-Columns Tool, and split on a space.

[afv2688 · Accepted solution]

Hello @vamsey ,

You might also try using regex:

DateTimeParse(
REGEX_Replace([Field1], '.*\s(\d+/\d+/\d+).*', '$1'), '%d/%m/%y')

Regards

[mceleavey · Accepted solution]

Hi @vamsey ,

in addition to what @PhilipMannering said, you could regex to parse out the mask:

Workflow attached.

I hope this helps,

M.

[vamsey]

below columns are not able to output the dates using the formulae. Can you please help

Report free of Soan BQ Outstanding Activities_11-08-2021 17-30-45.0000000.xlsx
Report free of Soan BQ Outstanding Activities_11-09-2021 17-30-36.0000000.xlsx
Report free of Soan BQ Outstanding Activities_11-10-2021 17-30-41.0000000.xlsx

Report free of Soan BQOutstanding Activities_NA 11-08-2021 17-30-45.0000000.xlsx
Report view of Loan IQdfd Outstanding Activities_NA 11-09-2021 17-30-36.0000000.xlsx
Report view of Loan IQed Outstanding Activities_NA 11-10-2021 17-30-41.0000000.xlsx

[HomesickSurfer]

Hi @vamsey 

Try GetWord([Field], 2)

[mceleavey]

Hi @vamsey ,

change the regex in my Regex tool to the following:

(\d\d[/]\d\d[/]\d{4}|\d\d[-]\d\d[-]\d{4})

You'll need to change the name back to Date or whatever.

M.