You can translate the question and the replies:

Special character

I want to stripe-off special character when i query the column. is there a special funtion to do this. e.g. i have characters like ~ @ in the data. so if have value@like, i want to select valuelike. if i have panda~, i want to select panda.
#SQL #VQL
user
06-03-2017 16:13:49 -0500
code

1 Answer

Hi, I would suggest you to use REGEX function to remove the Special characters in the data. Syntax: REGEXP(original_text:text, regexp:text, replacement_regexp:text):text For example, to remove the special characters in “value@like~panda” you could use: REGEXP('value@like~panda','[^0-9a-zA-Z]+','') As an alternative, I would also use the Replace function to remove the Special characters. You can also refer the section “REGEX ” and “REPLACE” in [Advanced VQL Guide](https://community.denodo.com/docs/view/document/Denodo%20Express/Denodo%206.0/Advanced%20VQL%20Guide). Hope this helps.
Denodo Team
09-03-2017 07:24:02 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here