This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
'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!
I have the below table and like to extract the date, digit and amount as below.
Possible Extension Period
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.
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!