Removing special characters from different lengths of strings in Intersystems cache sql

Question

Question

Mohamed Ashik · Jun 20, 2020

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

Log in or sign up to continue

Dhinupa Weerathunga · Jun 20, 2020

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?K...

1 0

score 1 · Answer 1 · 2020-06-20T01:58:19-04:00

Mohamed Ashik · Jun 20, 2020

This helps alot, Thank you Dhinupa.

1 0

score 1 · Answer 2 · 2020-06-20T02:46:00-04:00

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

score 0 · Answer 3 · 2020-06-21T00:36:03-04:00

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 :)