11-15-2018 03:44 AM
I've an access warehouse that has a text type column with attributes like:
and want only the numbers, removing the spaces and the m2 and m^2 characters
What expression(s) should I use?
I've been trying with LEFT and LEN without success.
Thank you in advance
11-20-2018 06:51 AM
You can use REPLACE to supress the m2 and m^2 and TRIM to supress the residual spaces
TRIM(REPLACE(REPLACE(Input.AttributeName, 'm2', ''), 'm^2', '')) must return you the correct string
You can use the VALUE function to get a numerical value
12-05-2018 11:49 AM
If all registers have an empty space between the number and the m2/m^2, you can use the following functional attribute formula:
LEFT(Column, SEARCH(' ', Column) - 1)
It will extract all characters before the empty space