Extract a date from text

[PakinamBakr]

Hi guys, 

1) I have been trying to extract dates from text using the Regex tool, but I'm missing something and the expression wouldn't work. Can you please refer to the attached workflow?

This is the expression I've been attempting

(\<\w+\>-\d{2}-\d{4})

2) Also, in the same attached workflow of 1 column, I am trying to create a new column, which populates "In Force" and "Pending" in front of the below cells. Can anyone help on this too please?

Thank you!

[Jonathan-Sherman · Accepted solution]

Hi @PakinamBakr,

I'd use the following regex expression to extract the year from your text:

\((\<\w+\> \d+, \d{4})\)$

I've also parsed the text into a date format if you need

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Assaf_m · Accepted solution]

Hi,

Please find attached solution for both queries. let me know if it works out on full data set

[PakinamBakr]

Thank you guys so much for the solutions!