Looking for to use the regex or equivalent replaceText feature in order to sanitize inputs before saving to DB.
Anyone would know how to succesfully remove several symbols that I can not seem to kick out ?
the following works 90% but fails for those...
Code: Select all
put replaceText(tFieldText,"[-$&~'#%?!@°,*+=></\(){}]","") into field "textcleaned"
>>> :
Code: Select all
\
(both slash are already included, but one does not get removed)
.... beside how would one includes the brackets and the ' " ' symbol ?
>>>
Code: Select all
' [' , ']' ,' " '
Thanks for any help