Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Use regex to extract date

Highlighted
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
Magnetar
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