substr 6 digits after comma

[selchen]

Hi everyone,

im a beginner and i try to substr some adresses.

Result should be cutted aber 6 digits after the comma.

input

Musterstr. 1b, 12345 Musterstadt

output:

Musterstr. 1b, 12345

i tried

substr (t1.adress, findc (t1.adress,",")-0)

any ideas how to solve to start the substr 6 digits after the comma?

thanks for your help.

[PeterClemmensen · Accepted solution]

Try this

data test;
   str = 'Musterstr. 1b, 12345 Musterstadt';
   new = substr(str, 1, find(str, ',') + 6);
run;

[selchen]

thanks a lot. it  is working.

[PeterClemmensen]

Anytime 🙂

[PeterClemmensen]

Also, a PRXCHANGE Approach. 

hope this helps 🙂

data test;
   str = 'Musterstr. 1b, 12345 Musterstadt';
   new = prxchange('s/(.*,.{6})(.*)/$1/', -1, str);
run;