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.
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!