Replace colon : with a space using prxchange in a string

94seanhogan — Wed, 19 Apr 2023 09:37:56 GMT

Using prxchange, how can I replace the : in the below string with a space. This is only an example of the string, so to make it as dynamic as possible please. i.e. the string may not be in this exact order, or it may be longer/shorter. I only want to remove the colon between 3Sbvx6822:Mcnt8969, and leave the rest.

have: {"var1":"0","var2":"3Sbvx6822:Mcnt8969","var3":"0","var4":"0","var5":"0"}

want: {"var1":"0","var2":"3Sbvx6822 Mcnt8969","var3":"0","var4":"0","var5":"0"}

using the below code partially worked, but removed 3Sbvx6822: rather than just the :

prxchange('s/(\w+:)//oi', -1,trim(keyvaluepairs))

Any help is appreciated.

Cheers.

Re: Replace colon : with a space using prxchange in a string

FreelanceReinh — Wed, 19 Apr 2023 10:53:30 GMT

Hello @94seanhogan and welcome to the SAS Support Communities (as a first-time poster)!

You could replace a string of word characters followed by a colon with that same string followed by a space:

want=prxchange('s/(\w+):/$1 /',-1,keyvaluepairs);

Or replace a colon, if preceded by a word character, with a space:

want=prxchange('s/(?<=\w):/ /',-1,keyvaluepairs);

topic Replace colon : with a space using prxchange in a string in SAS Programming

Replace colon : with a space using prxchange in a string

Re: Replace colon : with a space using prxchange in a string