Start a new topic
Answered

Dictionary Expression to Convert DD-Mon-YY Date to MM/DD/YYYY

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

Hi Krizia,


The attached dictionary should do the trick for you.


Thanks,


John



csv
(253 Bytes)

1 person has this question

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


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



1 person likes this
Answer

Hi Krizia,


The attached dictionary should do the trick for you.


Thanks,


John



csv
(253 Bytes)

1 person likes this

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


1 person likes this

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 

Login or Signup to post a comment