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

Custom Tools

Parse

Common Use Cases

Optimization

Accepted answers

afv2688

Hello @vamsey ,

You might also try using regex:

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

Regards

get time.yxmd

mceleavey

Hi @vamsey ,

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

Workflow attached.

I hope this helps,

date parsing from string.yxmd

All comments

philipmannering

Hi @vamsey

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

afv2688

Hello @vamsey ,

You might also try using regex:

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

Regards

get time.yxmd

mceleavey

Hi @vamsey ,

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

Workflow attached.

I hope this helps,

date parsing from string.yxmd

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)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703