Dictionary Expression to Convert DD-Mon-YY Date to MM/DD/YYYY
K
Krizia Alba
started a topic
over 4 years ago
Hello,
I am trying to create a dictionary in IOM to convert a date in this format: DD-Mon-YY (example: 12-Apr-13) to this format: MM/DD/YYYY (example: 04/12/2013). I know I need to use a Regukar Expression but I'm not sure how to build it. Any help is appreciated. Thank you!
-Krizia
Best Answer
J
John Shephard
said
over 4 years ago
Hi Krizia,
The attached dictionary should do the trick for you.
Thank you for your suggestion. However, I'm not sure exactly how to format that in the dictionary. Would I need to add the months individually as well in the same dictionary?
Krizia Alba
Hello,
I am trying to create a dictionary in IOM to convert a date in this format: DD-Mon-YY (example: 12-Apr-13) to this format: MM/DD/YYYY (example: 04/12/2013). I know I need to use a Regukar Expression but I'm not sure how to build it. Any help is appreciated. Thank you!
-Krizia
Hi Krizia,
The attached dictionary should do the trick for you.
Thanks,
John
1 person has this question
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstCarrie Clark
https://omaticsoftware.freshdesk.com/support/discussions/topics/28000006503
Have you checked out this article? I think it might be helpful.
1 person likes this
John Shephard
Hi Krizia,
The attached dictionary should do the trick for you.
Thanks,
John
1 person likes this
Krizia Alba
Hi John,
Thank you for your suggestion. However, I'm not sure exactly how to format that in the dictionary. Would I need to add the months individually as well in the same dictionary?
Thank you!
John Shephard
See this article for instructions on importing a dictionary.
https://omaticsoftware.freshdesk.com/solution/articles/28000007789-how-to-import-a-dictionary
1 person likes this
Krizia Alba
Hi John,
Thank you so much! I didn't realize all you had to do was paste it. It worked like a charm! It's exactly what I needed.
Cheers,
Krizia
-
Dictionary Issue- RegEx to translate dollar amount to specific letter code
-
Preventing IoM from importing Blank Attributes
-
Dictionary default United States?
-
How to not add a gift attribute if the import cell is blank
-
RegEx to remove leading characters
-
Credit Card type Dictionary
-
Regular Expression to pull a specific word or string from a longer string
-
Object reference not set to an instance of an object Error
-
Event Participant importing question
-
Date Dictionary Help: YYYYMMDD to MM/DD/YYYY
See all 1184 topics