Hi how can I remove the number "1" in the string "1 TOTAL ACCUM DEPN". What is the formula for this?
Solved! Go to Solution.
You can use formula like this
Trim(Replace([Field1], "1", ""))
Hope this helps : )
Hi how about if I have a lot of numbers in a string?
Try formula like this
Trim(REGEX_Replace([Field1], "\d", ""))
Hope this helps : )
an alternative to the use of RegEx (more expensive),
replacechar([field],"1234567890",'')
this will replace anything in the quotes with nothing.
cheers,
mark
This was very helpful. Can you also remove leading and trialing spaces? I assume this would be a conditional statement such as IF LEFT(1) = ' ' THEN TRIM .... but there's probably a simpler solution.