REGEX find 'SELECT FROM Z'
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?
Jörg Wulf replied
try this regexp
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