PRXCHANGE Simple Pattern Change

[bendsteel6]

Hi,

In the following lines, I simply need to change the '0's in the patterns (08*119*5, 05*119*5, etc.) with a capital "O" (O8*119*5, O5*119*5, etc.) .  I've tried with the PRXCHANGE function but I can't seem to get it to work without changing all the other '0's in the datalines.

data test;

input COM_FIELD3 $1000.;

datalines;

CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150068 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2

CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150042 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2

CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150068 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2

CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150068 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2

;

run;

Any help would be greatly appreciated!

Thanks.

[Jagadishkatam · Accepted solution]

Hope this helps

please try

data test;
input COM_FIELD3& $1000.;
new=prxchange('s/(0)(\d\*)/O$2/',-1,COM_FIELD3);
datalines;
CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150068 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2
;
run;

[bendsteel6]

Works wonderfully!  Thanks!!!

[Jagadishkatam]

Could you please Mark answers as helpful and correct as appropriate. It helps future users narrow down what responses to look at.

[bendsteel6]

I'd love to!  How do I do that?

[Jagadishkatam]

you can see mark as answer and you need to click.

[bendsteel6]

Got it, done.  Thanks.