Start a new topic

RegEx - Get Month Textfrom Date Time

Hi all,


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

2021-09-22T13:23:08.543704-07:00[US/Pacific]


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


Thank you!

 


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

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

Login or Signup to post a comment