topic Re: Subtract string using regular expression in New SAS User

Extract string using regular expression

daradanye — Fri, 24 Jan 2020 15:19:19 GMT

Hi,

I need to use SAS regular expression to extract a substring from some messy strings. I've compiled regular expression patterns but not quite sure how to do that in SAS.

The examples are as follows:

Have	Want
a2191625zex-10_14.htm	10_14
ade4378dexhibit10_2.txt	10_2

The regular expression I come up with is (ex\D*)(\d+\D+\d*)

I am using two sets of brackets here to group. In Python or other languages, I can locate what I want by identify group(2). Is there any similar function here in SAS?

I would be very grateful if someone can help out here.

Thanks,

Dara

Re: Subtract string using regular expression

PGStats — Thu, 23 Jan 2020 22:48:25 GMT

Try prxChange:

want = prxChange("/.*ex\D*(\d+\D\d*).*/\1/", 1, have);

Re: Extract string using regular expression

Ksharp — Sat, 25 Jan 2020 09:13:53 GMT

data x;
input have : $40. ;
pid=prxparse('/[\d_]+(?=\.[a-z]+)/io');
if pid>0 then do;
call prxsubstr(pid,have,p,l);
want=substr(have,p,l);
end;
cards;
a2191625zex-10_14.htm
ade4378dexhibit10_2.txt
;
proc print;run;

Re: Extract string using regular expression

Ksharp — Sat, 25 Jan 2020 09:15:39 GMT

OR this Scan():

data x;
input have : $40. ;
want=scan(scan(have,1,'.'),-1,'_','kd');
cards;
a2191625zex-10_14.htm
ade4378dexhibit10_2.txt
;
proc print;run;