Hi!
Regex question. How can I remove non numeric characters from the beginning or end of a string (but not from the middle)?
e.g. before:
65x
2.5
si98
a99a
3-
I want the result to be:
65
2.5
98
99
3
This is important because I do not want to lose the decimals, e.g. 2.5 should not become 25
Solved! Go to Solution.
@alexnajm very true, guess data celanese and then a formula tool with replace([field],"-","") assuming that's the only puncuatuion you would want to get rid of.
Agreed @aatalai!