1 Reply Latest reply on Nov 9, 2018 3:41 PM by Patrick A Van Der Hyde

Parsing multiple Short dates from VarChar string

Chinmay Kothari Oct 3, 2018 8:39 AM

Hello Community,

I am trying to parse multiple short dates from a string.
I have come up with a basic REGEX to extract the short dates, but my calc only extracts the first date. I need to extract all the different dates from each string.

Attached: Sample workbook.

All the help is greatly appreciated.

Thank you,

Chinmay

Date Parse Sample.twbx 136.5 KB

1. Re: Parsing multiple Short dates from VarChar string

Patrick A Van Der Hyde Nov 9, 2018 3:41 PM (in response to Chinmay Kothari)

Hello Cinmay,

You have a data issue to get that data into many rows from one. Have you investigated using Tableau Prep to fix this data before bringing into Tableau? The data clean up will be better addressed before bringing it into Tableau. What is your data source?

Patrick
Like Show 0 Likes(0)

Actions

Tableau Community Forums

Parsing multiple Short dates from VarChar string

1. Re: Parsing multiple Short dates from VarChar string

Actions

More Like This