search for numbers (successively) in a string

[J_J_J]

Hi!

Can anybody help me please to find in a string numbers (successively). It can be different count of digits on different lines.

Example:

1) text #11111111# text

2) text

3) text #555555555# text

I would like to get 2 rows:

1) 1111111

2) 555555555

[PeterClemmensen]

Do you simply want to extract numbers (0123456789) from a string or do they have to be enclosed in ##?

[J_J_J]

They have to be enclosed in ##

[PeterClemmensen · Accepted solution]

Ok. Building on your previous thread, how about this?

data have;
input string $ 1-50;
datalines;
text #11111111# text
text
text #555555555# text
;

data want;
    set have;
    num=input(prxchange('s/.*#(\d+)#.*/\1/', -1, string), 8.);
    if num;
run;

Result:

string                   num
text #11111111# text     11111111
text #555555555# text    55555555

[J_J_J]

Thanks a lot! It works!