Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live!

Use regex to extract date

Highlighted
8 - Asteroid

Hi,

 

I have the below table and like to extract the date, digit and amount as below.

 

Commencement Date

Possible Extension Period

Rent Amount

2.    COMMENCING DATE  2/11/2017

4.   With an OPTION TO RENEW for a period of  5 years

$47,514.91, as calculated in accordance with Schedule D.

 

 

 

Required

 

 

02/11/2017

5

47514.91

 

 

Thanks

Jag

Highlighted
14 - Magnetar
14 - Magnetar

Hey @jagjit_singh! Try the following expressions in a single Formula tool...

 

For Commencement Date field:

REGEX_Replace([Commencement Date], "(.*)E\s+(.*)", "$2")

For Possible Extension Period field:

REGEX_Replace([Possible Extension Period], "(.*)of\s+(\d+)(\sye.*)", "$2")

For Rent Amount field:

REGEX_Replace([Rent Amount], "\$(.*)\,.*", "$1")

Hope this helps!

Labels