RegEx

[SylviaK]

Hi 

I am trying to get the date out of the comments column using RegEx. 

I used this expression. but it doesn't seem to work. What am I doing wrong?

Many thanks, 

Sylvia

[Ladarthure · Accepted solution]

Hi @SylviaK,

I used this regex, may not be the best but it worked on my side : 

(\w+\s\d+\,\s\d{4})\s.+

Hope it helped!

[AshleyL · Accepted solution]

Hi @SylviaK,

I've attached a sample workflow. I would suggest using Parse and then if you want to convert the new separated date into a date data type, you'd use the DateTime tool.

If you wanted to use replace, I would uncheck 'Copy unmatched text to output'.

Does this help?

Ashley

[neilgallen]

In this case you need to replace the \n with \d to signify digits. The rest of the expression should work!