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.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive