topic how to replace the two consecutive special characters with single character in SAS Programming

how to replace the two consecutive special characters with single character

raja777pharma — Tue, 31 May 2022 11:01:15 GMT

Hi Team,

I have string with two colons (::) and would like to repalce this two colons with single special charcters like '@' or '$' or ',' or ';'

String : "test1::test2::test3::test4::test5::"

Expected out put string : "test1,test2,test3,test4,test5"

Thank you,

Rajasekhar.

Re: how to replace the two consecutive special characters with single character

PaigeMiller — Tue, 31 May 2022 11:24:47 GMT

data want;
string="test1::test2::test3::test4::test5::";
wanted_string=tranwrd(string,'::',',');
/* Remove final comma */
if substr(wanted_string,length(wanted_string))=',' then wanted_string=substr(wanted_string,1,length(wanted_string)-1);
run;