It works if there is a space after the date and before the T. However in the file tehre is no space. Suggestion? 2017-08-25 10:25:10-07:00
J
John Shephard
said
over 4 years ago
On the first line of the dictionary you'll want value to match on to be (? On the second line you'll want value to match on to be (^\d{4})-(\d{2})-(\d{2}$) with a replacement value of $2/$3/$1
Check the RegEx box on both lines.
Thanks,
John
T
Tom Nguyen
said
over 4 years ago
Yes, John, the forma of 8/25/2017. Therese, that doesn't seem to be working with our test date of this. 2017-08-25 10:25:10-07:00
T
Therese Morris
said
over 4 years ago
Replacement value should be blank with Use Regular Expressions checked. Value to match on = (?
J
John Shephard
said
over 4 years ago
Hi Tom,
Is the end result you are looking for is a format of 8/25/2017?
Tom Nguyen
We are trying to build a dictionary to reformat the date below and remove the time stamp. Any suggestions?
2017-08-25 10:25:10-07:00