ssis - Konesans Regex Cleaner Transformation -

i have tried using konesans regex cleaner transformation in cleaner want spacial characters removed column,

i tried code in regex cleaner

match expression:

!@#$%^&*_+`{};':,./<>? 

replace expression:

""  http://www.sqlis.com/post/regexclean-transformation.aspx 

so i've never used konesans regex cleaner , don't particularly want download it, per comment i'll try help.

looking @ samples online, looks have put

[!@#$%^&*_+`{};':,./<>?] 

in "match" column, , nothing @ in replace column. perhaps empty string - ""

you can use this test find , replace regexes.

here few examples can feel it:

string: #is &&%^an !ugly &$%^string.  match: [!@#$%^&*_+`{};':,./<>?] replace:  result: ugly string  match: [!@#$%^&*_+`{};':,./<>?] replace: - result: -is ----an -ugly ----string-  match: [!@#$%^&*_+`{};':,./<>?]+ replace: - result: -is -an -ugly -string- 

edit: since can't use empty string, can try this:

match: [!@#$%^&*_+`{};':,./<>?]() replace: ${1} result: ugly string 

edit 2:

match: [!@#$%^&*_+`{};':,./<>?](?<empty>) replace: ${empty} result: ugly string 

this works creating empty capturing group, , replacing contents of (). if $1 doesn't capturing group in konesans, i'm sure similar syntax will.