Prxparse

[Kiteulf]

I have this type of data:

125628,59000,.,.,.,.

.,50000,.,.,.,.

using 

 prx=prxparse("s/.,[., ]*/, /");

I get 

12562, 5900, , , , .

, 5000, , , , .

I would like to have 

125628,59000

50000

[RW9 · Accepted solution]

Well, perl I can't help you with, however its a simple thing in Base SAS code to do:

data have;
  tmp="125628,59000,.,.,.,."; output;
  tmp=".,50000,.,.,.,."; output;
run;

data want (drop=i);
  length tmp2 $200;
  set have;
  do i=1 to countw(tmp,",");
    if scan(tmp,i,",") ne "." then tmp2=catx(',',tmp2,scan(tmp,i,","));
  end;
run;
  

[andreas_lds]

not fully tested:

data want;
   set have;
   tmp2 = transtrn(tmp, ',.', ' ');
   tmp2 = strip(transtrn(tmp2, '.,', ' '));
run;

[ChrisNZ]

With a RegEx:

data t; 
  STR=prxchange('s/,\./ /', -1, '125628,59000,.,.,.,.');
  putlog STR=;
run;

STR=125628,59000