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
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.
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
Stephanie Osborne
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?