DATA Step, Macro, Functions and more

regular expression for beginning of a string

Accepted Solution Solved
Reply
Regular Contributor
Posts: 199
Accepted Solution

regular expression for beginning of a string

This seems to work for finding strings with numbers at the beginning.
However, I'm not sure how to add in the requirement that string may also begin with the letter A.

Does anyone know how to add this requirement to the regular expression below?

fnd=prxmatch('/^\d\/',Test_Result_Number)

So, I want to find 102, 9B101, A101, but I don't want Z10.

Thank you.


Accepted Solutions
Solution
‎05-15-2014 05:07 PM
Respected Advisor
Posts: 4,925

Re: regular expression for beginning of a string

The problem is the extra '\', it acts as an escape character. The pattern should be

fnd=prxmatch('/^A?\d/',Test_Result_Number)


I hadn't noticed.

PG

View solution in original post


All Replies
Respected Advisor
Posts: 4,925

Re: regular expression for beginning of a string

fnd=prxmatch('/^A?\d\/',Test_Result_Number) : A? matches the letter A 0 or 1 time. - PG

PG
Regular Contributor
Posts: 199

Re: regular expression for beginning of a string

Hi PG,

Do you know how resolve this error?

ERROR: Closing delimiter "/" not found after regular expression "/^A?\d\/".

ERROR: The regular expression passed to the function PRXMATCH contains a syntax error.

Thank you.

Solution
‎05-15-2014 05:07 PM
Respected Advisor
Posts: 4,925

Re: regular expression for beginning of a string

The problem is the extra '\', it acts as an escape character. The pattern should be

fnd=prxmatch('/^A?\d/',Test_Result_Number)


I hadn't noticed.

PG
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 598 views
  • 0 likes
  • 2 in conversation