I am trying to get rid of numbers smaller than 0 in column A. Column A is type V-WString. I tried using the filter tool after convert the column type to double but could not find a way for this issue. Can you help? Thank you
This is the sample I have:
This is the desired outcome:
Solved! Go to Solution.
It might be as simple as just doing a filter for records that do not contain the dash, assuming that there are no other dashes in the column outside of negative numbers.
You may want to look into why you have two sets of headers in the data though. I'd imagine if you get rid of the duplicate headers you could convert the column to be numeric easily and do a filter for >0.
you can use a filter with:
not(REGEX_Match([numbers],"[-]\d*"))
- that assumes you need to keep the rows with "numbers" as a value.
Another option is something along the lines of:
contains([numbers],"numbers") or tonumber([numbers])>=0
Hi @Minh
This function work well, too.
The ToNumber function returns 0 when it encounters a non-numeric value.