RegexReplace for Special Character

[sindhuk]

Hi,

I would like to replace any character with blank . Only valid characters are A-Za-z0-9Space.
Anything other than this should be replaced with blank.

Thanks

[ArjenEX]

Hi @sindhuk

You can use regexReplace($column1$,"[^a-zA-Z0-9 ]+"," ") for this

[AlexanderFillbrunn]

Hi,
I just wanted to point out that this replaces any sequence of non a-zA-Z0-9Space with one space character. If by blank the original poster means empty string, then it needs to be

regexReplace($column1$,"[^a-zA-Z0-9 ]+","")

It does not make much sense to replace a space by a space, after all.
Alexander