https://communities.sas.com/t5/SAS-Programming/string-cleaning/m-p/363788#M86186 <P><U>Hello,</U></P><P>I have a variable called link_detail that is json file and I want to get rid of {}[]'":. I see that prxchange type funtions can be applied to do this. Any help is appreciated.I am attaching one record that hopefully will help understandig the question.</P> Fri, 02 Jun 2017 13:06:31 GMT mesfandiari 2017-06-02T13:06:31Z https://communities.sas.com/t5/SAS-Programming/string-cleaning/m-p/363788#M86186 <P><U>Hello,</U></P><P>I have a variable called link_detail that is json file and I want to get rid of {}[]'":. I see that prxchange type funtions can be applied to do this. Any help is appreciated.I am attaching one record that hopefully will help understandig the question.</P> Fri, 02 Jun 2017 13:06:31 GMT https://communities.sas.com/t5/SAS-Programming/string-cleaning/m-p/363788#M86186 mesfandiari 2017-06-02T13:06:31Z https://communities.sas.com/t5/SAS-Programming/string-cleaning/m-p/363802#M86196 <P>Use the compress function:</P> <P>data _null_;<BR />link_detail = '{a} [a]';<BR />link_detail = compress(link_detail, '{}[]');<BR />put link_detail;<BR />run;</P> Fri, 02 Jun 2017 13:27:42 GMT https://communities.sas.com/t5/SAS-Programming/string-cleaning/m-p/363802#M86196 WarrenKuhfeld 2017-06-02T13:27:42Z