Skip to Content

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

REGEX find 'SELECT FROM Z'

Hi

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.

Thanks,

Adrian

Tags:
Former Member
replied

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

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