Spotfire extract decimal numbers from string column

Hi All,

I have a string column that looks like this:

ColumnA
"POINT (10.203942930 45.2903203)"
"POINT (11.356898730 25.2548565)"

from which I would like to extract the numbers and create two separete columns:

column1
10.203942930
11.356898730

column2
45.2903203
25.2548565

I have tried RXReplace, but I get one single number which is not decimal...

RXReplace([col], "[^0-9]", "", "g")

Any help will be really appreciate it.

Thanks in advance.

(1) Answer

Login