We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Inconsistent date strings

Bunbunrachel
6 - Meteoroid
Spoiler
 

Hi, 

I am trying to parse the following strings into dates but some do not have “Year” available. I tried passing them using regex_match and regex_replace function but formulae do not currently pick them up.

 

Raw date:

5:45PMAEST-13-Dec

5:30AMAEST-27/12

2023-01-2310:29:00

3:00AMCDT17thMay

2:00AMAEST18thMay(thesisthetime)

 

Appreciate any help on this!

2 REPLIES 2
Bunbunrachel
6 - Meteoroid

My 2nd qn is: My current REGEX formulaes does not  seem to pick up the first data value even though condition is included. Any idea why?

 

Raw data:

10:37amAEST30/05/2023 - not picked up

10:45amCDT-30/05/2023 - pick up

 

Appreciate any help on the above qn!

20230623_180816.jpg

binuacs
21 - Polaris

@Bunbunrachel one way of doing this

 

Labels
Top Solution Authors