Stripping non-numeric characters from a string


#1

I want to strip all characters except numbers or periods from a text string. I came up with a formula that works, but isn’t there a better way?

characterfilter("0a1.b2c",{?((asc(import())>=48 and 
asc(import())<=57) or asc(import())=46,import(),"")})

#2

stripchar(“0a1.b2c”,“09…”)


#3

Damn. My mouse was hovering over Reply when that appeared.


#4

Thank you both.