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

https://omaticsoftware.freshdesk.com/support/discussions/topics/28000006503

Have you checked out this article? I think it might be helpful.

Hi Krizia,

The attached dictionary should do the trick for you.

Thanks,

John

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!

See this article for instructions on importing a dictionary.

https://omaticsoftware.freshdesk.com/solution/articles/28000007789-how-to-import-a-dictionary

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