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!
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!
@Bunbunrachel one way of doing this