Start a new topic

Another RegEx one please! Omatic Cloud Mailchimp dates for UK format

Hi,


I can't find exact solution for this so apologies if it already exists. I can't control the incoming data (Mailchimp Cloud Connector) but from the error logs an example date format is:


3/25/2020 7:26:20 AM


If I strip the timestamp then I get the invalid fuzzy date error, support have told me you can only apply one line of a dictionary so I need a one liner that'll strip the timestamp and also reformat to UK date format DD/MM/YYYY


Please help me RegEx gurus! :)


Cheers,


Michael


Hi Michael


This is what we use:





image


Now this incorporates time as well as no time stamp, and I haven't looked at it for a while, so I think it is best to try a few of the rows above, and play around as you need.


Gemma


Thanks Gemma but my date format is different and that's not working. I don't know regular expressions but I've played around and can't get anything to work (running tests just returns the input value). I think I need to remove the timestamp and reformat the date but also I suspect the fact that the day is only 1 char if less than 9 will also need to be handled, not sure. 


Thanks again for your input though!

This is what I use:

image

Values to match on:

First line: (?<=[0-9]{4}).*

Second line: (?<=2010).*

Third line: (?<=2011).*


Hope this works for you.


Barbara


Login or Signup to post a comment