Start a new topic

RegEx help - change date format

HI

 

I was hoping someone could help me with a RegEx for changing date format from DD/MM/YYYY to YYYYMMDD (No slashes).

 

We import this date to a field that only accepts numbers so I have to do this for quite a few files, and would like a RegEx that would do it for me

Thanks In Advance!

Erin

1 Comment

Took a bit of testing, but I finally figured it out

Replacement Value = $3$2$1 - regex
Values to match on = ^(\d{1,2})/(\d{1,2})/(\d{4})

I wasn't clicking the RegEx button so it wasn't working...
Login or Signup to post a comment