Forum Discussion
Solved
converting text to numeric conditionally
Good day community, I have a text column that contains numeric data (as text) as well as alphanumeric data. I have tried to convert the text column to numeric, but receive error messages on rows...
Create a custom column using this formula below, then you can convert this custom column to numeric
try Number.FromText([Text]) otherwise null
Create a custom column using this formula below, then you can convert this custom column to numeric
try Number.FromText([Text]) otherwise null