Start a new topic

Regular expressions to format in date format

I'm pulling in a date field into my excel import file that is currently populating with a "custom" format that looks like the below:

 

25/Nov/1983


I need to manually format to the "date" format in order for my import to recognize and format as a date field in RE.  Is there a regular expression to do this?


You can do this with a Dictionary using Regular Expressions

Copy and Paste the table below into a dictionary (instructions)

1 Jan TRUE FALSE
2 Feb TRUE FALSE
3 Mar TRUE FALSE
4 Apr TRUE FALSE
5 May TRUE FALSE
6 Jun TRUE FALSE
7 Jul TRUE FALSE
8 Aug TRUE FALSE
9 Sep TRUE FALSE
10 Oct TRUE FALSE
11 Nov TRUE FALSE
12 Dec TRUE FALSE
$2/$1/$3 ^(\d+)/(\d+)/(\d+)$ TRUE FALSE

Here you can see it working

image


That worked! Thank you so much!!!

Hi - I realize this is an older post, but I used the data in here posted by Wayne and still can't the Month/Date to flip.

image


Here's my dictionary:

1 Jan TRUE FALSE
2 Feb TRUE FALSE
3 Mar TRUE FALSE
4 Apr TRUE FALSE
5 May TRUE FALSE
6 Jun TRUE FALSE
7 Jul TRUE FALSE
8 Aug TRUE FALSE
9 Sep TRUE FALSE
10 Oct TRUE FALSE
11 Nov TRUE FALSE
12 Dec TRUE FALSE
$2/$1/$3 ^(\d+)/(\d+)/(\d+)$ TRUE FALSE


Your incoming data is separated by dashes, not slashes.  In the very last line change your value to match on to ^(\d+)-(\d+)-(\d+)$


Thanks,


John

Login or Signup to post a comment