Extracting date text from string using Alteryx

[Sujitra_Rajan]

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

[ShankerV]

Hi @Sujitra_Rajan 

One way of doing this.

Many thanks

Shanker V

[Felipe_Ribeir0]

Hi @Sujitra_Rajan 

One way of doing this: 

[ShankerV]

Hi @Sujitra_Rajan 

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

Many thanks

Shanker V

[BS_THE_ANALYST · Accepted solution]

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:

[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!