topic Problem with PRXMATCH in SAS Programming

Problem with PRXMATCH

ICL1986 — Wed, 18 Oct 2017 09:52:07 GMT

I'm looking to extract IBAN numbers from some SWIFT data I have, but my PRXMATCH function doesn't seem to be working, does anyone know why?

An example of the text field I'm searching in would be:

LV05AIZK1234567891234 COMPANY NAME ADDRESS

In order to find the starting character for the match to use in a substring extract, I'm using:

PRXMATCH('/\LV\d{2}\D{4}\d{13}\s/', COLUMN)

This looks right to me but I keep getting a result of zero where I can see this IBAN form in the data.

Re: Problem with PRXMATCH

RW9 — Wed, 18 Oct 2017 10:20:29 GMT

Would not scan(string,1," ") not work?

Re: Problem with PRXMATCH

ICL1986 — Wed, 18 Oct 2017 10:26:08 GMT

That's a much neater solution for this particular problem thanks. For instances where the IBAN can potentially be anywhere in the string, can you think what's wrong the the PRXPARSE statement?

Re: Problem with PRXMATCH

RW9 — Wed, 18 Oct 2017 10:33:27 GMT

Well, I am not familiar with Perl so much, so will let others comment on that. If it always starts with "LV" and length 21 which your regex seems to indicate then:

want=substr(thestring,index(thestring,"LV"),21);

So find LV in the string, and then substr out 21 characters from there.

Re: Problem with PRXMATCH

ICL1986 — Wed, 18 Oct 2017 10:34:54 GMT

Perfect, thanks

Re: Problem with PRXMATCH

FredrikE — Wed, 18 Oct 2017 10:40:18 GMT

This seemes to work 🙂

data one;
length iban $32 column $200;
column = 'One IBAN Number: LV05AIZK1234567891234 COMPANY NAME ADDRESS';
pos = PRXMATCH('/LV\d{2}\D{4}\d{13}/', COLUMN);
run;

I removed the first \ and the trailing \s.....

//Fredrik

Re: Problem with PRXMATCH

ICL1986 — Wed, 18 Oct 2017 15:15:39 GMT

Yes, this works now thanks