Start a new topic

RegEx - Get Month Textfrom Date Time

Hi all,

The Date field in my csv file is formatted as such:


I need to get a Dictionary that gives me the Month as Text (I need it to return September not 9)

Thank you!


I don't know how to use RegEx. I need someone to how me/write it for me.

You can use a formula to get characters 6-7 and then a dictionary to convert 01 to January, 02 to February, etc.

Login or Signup to post a comment