Hi All,
I have a column that do contains , alpahanumeric values and wholly numeric value:
e. g m2345t>0
234578
TTTYUG65H
5657890
what i need to do in this coulmn is to remove all numeric values and just stay with the alphanumeric
This transcend to :
m2345t>0
TTTYUG65H
FULLAH
no whole numeric field
Can someone help with this please
Solved! Go to Solution.
Another way to approach this which can handle things like decimals in numeric fields is to use the following formula:
ISNULL(TONUMBER([Field1],1,1))
This will convert your field to a number in the filter, replacing all non-numeric fields with a null value. By filtering to only show values that would be null when converted to a number, you get all non-numeric fields.