Extract a date from text

Question

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!

Extracting date from text.yxmd

Jonathan-Sherman · Accepted Answer

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 Answer

Hi,

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