Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A



I'm running SAP program RS_ABAP_SOURCE_SCAN and enter string to search for as ^(?:SELECT)|(?:SELECT+\s)$ and select checkbox 'String is regular expression'.

This works okay, but it includes non-Z tables. I'd like to only get the SELECT statements from Z tables. But I'm not experienced enough and the examples I get are not clear. If you can adjust the REGEX above to extract SELECT statements only from Z tables, that would be great thanks.

Why is it required to have a similar expression split by a | character in REGEX? What is the purpose of the expression to the left and the one to the right?

Please assist.



Former Member

Hi Adrian,

try this regexp

\<(?:select\b).+(?:from z).+

the | character combines the left and right patterns with OR so either match is valid.

My above example translates as follows:

Find where select is separate word (\< and \b define word start and word end), is followed by one to many characters of no description and then is followed by 'from z" wich indicates a Z-Table. Again 1 to many characters may follow.

Try it out.

Best regards - Jörg

3 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question