Start a new topic

Remove timestamp AND reformat date?

Is this possible? Date/Time is coming down like this:

2017-05-26 11:35:19-04:00

So I'd have to remove the timestamp first, correct? Then reformat the date to MM/DD/YYYY. But I can't even get the timestamp removal to work. Any ideas? I'm trying to learn but am not wrapping my head around this. :(

First line: Value to match on (?
Second Line Value to match on (^\d{4})-(\d{2})-(\d{2}$) Replacement value $2/$3/$1

I want to be as good at RegEx as you are when I grow up! Thank you!
Login or Signup to post a comment