Removing Unwanted Characters from a String

Originally from ticket #513.

Hello,

I am attempting to nest a function, in order to remove a number of different characters from a particular "string" field.

What I need to do is to remove all characters from a phone number string. The phone number values are formatted as (###) ###-####. I need to remove all parentheses, spaces and dashes from this string.

I can successfully use an expression to remove one character at a time. Please see successful expression below - in this instance I am removing the spaces. However, I have only been successful when I use multiple expressions linked to each other (a total of 4 expression -->to remove spaces, parentheses and dashes). I can't figure out how to use one expression - like the one below - in order to remove multiple characters from a string.

Can you please help?

Thanks,

Laurence

[cid:image001.jpg@01CCA6B8.FB70AAC0]

TechSup1 November 19, 2011 21:42

You can use built-in functions GetDigits, which strips out all the non-numeric characters from a string, or RemoveChars, which removes only the specified characters. You can specify multiple characters in a single RemoveChars call.

Either of these should do the trick.

Removing Unwanted Characters from a String

1 comment