Error when converting a String Column to Floating Decimal

kim_barragan0126

I am trying to convert a string column to floating decimal, but I get the below error. How can I fix?

GrantSmith

You need to remove all non-numerical characters first.

In a formula tile you can do something like this:

REGEXP_REPLACE(`field`, '[^0-9.]', '')

Then feed that into the Alter Columns tile

GrantSmith

You need to remove all non-numerical characters first.

In a formula tile you can do something like this:

REGEXP_REPLACE(`field`, '[^0-9.]', '')

Then feed that into the Alter Columns tile

kim_barragan0126

thank you!