Extracting date text from string using Alteryx

Hi all,

I'm newbie to Alteryx, am stuck and reaching out for help if anyone could help guide which tools to use and share workflow that will help extract the date from description in a column.

Eg. CAOM 3043 Cash recd 20190601 Rein

CAOM 3043 FX Adj 20190601 Rein

CAOM 3043 Recd stmt 20190601 Rein

CAOM 3043 Accrual 20190601 Rein

Have attached sample here for easy reference. Looking forward to your response and thanks in advance for your time and effort in looking into this. Much appreciated

Thanks,

Sujitra

Data_raw.xlsx

Workflow

Date Time

Accepted answers

BS_THE_ANALYST

Couple of ways to approach this:
Method 1: I'd definitely use the trim function to clean up spaces before and after the strings:

Method 1.2: You can use the Right function, and then use Text to Columns. (this isn't the best option in my opinion, but it's one to explore)

Using Right function:

Using Text to Columns: Make sure you enter a space in the Delimeters section in the configuation

Method 2: RegEx (way more dynamic). Using the RegEx tool. If the date always sits in the second to last word position, it will find it.

Method 3: Given that there are no other 8 digit numbers in the string, RegEx:

stringParsing.yxmd

All comments

ShankerV

Hi @Sujitra_Rajan

One way of doing this.

Many thanks

Shanker V

Extracting date text from string using Alteryx.yxmd

Felipe_Ribeir0

Hi @Sujitra_Rajan

One way of doing this:

extract_date.yxmd

ShankerV

Hi @Sujitra_Rajan

One more way to do it with the help of Formula tool.

Many thanks

Shanker V

Extracting date text from string using Alteryx.yxmd

BS_THE_ANALYST

Couple of ways to approach this:
Method 1: I'd definitely use the trim function to clean up spaces before and after the strings:

Method 1.2: You can use the Right function, and then use Text to Columns. (this isn't the best option in my opinion, but it's one to explore)

Using Right function:

Using Text to Columns: Make sure you enter a space in the Delimeters section in the configuation

Method 2: RegEx (way more dynamic). Using the RegEx tool. If the date always sits in the second to last word position, it will find it.

Method 3: Given that there are no other 8 digit numbers in the string, RegEx:

stringParsing.yxmd

cjaneczko

This was the method I was going to propose. Regex tool parsed on the 8 digits.

Sujitra_Rajan

Thank you! The regex parse tool worked!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703