How to trim all special charecters?

[cool7878]

Hi

I want to trim all these special characters from a variable \ / : * ? " < > |. Now tried the wordprocessing - trim - own characters. But it did not work. Please let me know what is the correct way to put them in that box so that it works.

Thanks
Raj

 

[bigcajones]

Use replace with regex as a match. You will have to delimit the characters and use a pipe as separator. Don't forget to delimit the last pipe so that regex engine doesn't see it as regex OR. Use nothing as replacement

 

[cool7878]

Thank you. this perfectly worked. One more note for other users. * and ? needs to be replaced separability as text as they are used in regular expression.

Raj

 

[nitin2003]

You can use backslash to treat * and ? as regular characters within a regular expression.

Thank you. this perfectly worked. One more note for other users. * and ? needs to be replaced separability as text as they are used in regular expression.

Raj