Using an ETL, is it possible to remove text without removing decimals?
For example, I have a dataset that includes values like this:
1.0
8.54578
N/A
7.49687587125516
.....
Using "Text Formatting" to "Only show numbers" results in the following output:
10
854578
749687587125516
How can I extract the numbers from a column while still keeping the decimals in the correct place?
Thanks!