Remove text without removing decimals
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!
Comments
-
Is there any other critiera in the data that is consistent? What I mean is that are there fields like "1.0 blah" or it is only "1.0", "9.9999", or "N/A" type examples? If the only other non-number you have to remove is "N/A" could you use "Replace Text". If there are others like "1.0 blah" and there is always a space seperating them you could again use Replace Text again, but time in that second box for search critieria use "RegEx" and create a regex that would remove everything on and after a space. This is a good site to test regex commands https://regex101.com/ . Hope that helps.
1 -
Thanks for your help! Unfortunately there is no consistency to the nonstandard data, so I can't look for a number of characters, or a certain string.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有