Removing special characters from different lengths of strings in Intersystems cache sql
I have a set of strings that contains special characters. Im trying to write a sql query to remove all the special characters in the string. Im using Intersystems cache sql.
Example
%Lis&ten - Listen
Discussion (4)0
Comments
you can use $ZSTRIP retrieve the specified string, for more information you can refer https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?…
This helps alot, Thank you Dhinupa.
if you know exactly what characters you want to remove you may use $TRANSLATE (in SQL) !
docs: https://cedocs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=RSQL_d_translate
characters are random, it can be any of the special characters. but yeah i was able to use this directly in my query. Thank you :)