Hi,
I've been trying to use the extract_quotelike and extract_delimited
functions to extract a SQL statement from a line of C++ code but I
just can't get it to work.
The script is searching all .cpp files in a folder for SQL commands;
it manages to extract some but not all of them. I'm using a basic
regex to select only the lines which contain the word "SELECT" (which
is the start of all the SQL statements I'm interested in) and then
passing the line from the file to extract_quotelike (as all the SQL is
contained in double quotes).
If the input line only contains the SQL with no prefix, it works, but
when there are other characters before the quoted string it fails. For
example, passing the the C++ line:
Open(CRecordset::snapshot, "SELECT SCOPE_IDENTITY()
Build_request_Id");
to extract_quotelike returns an empty string as the extracted result
and the whole string as the remainder, indicating it found no quoted
strings in the line.
Can anyone tell me how to get the quoted string out of that line? I've
tried specifying all manner of parameters to the function and even
tried using extract_delimited but I can't get that to work either!
Thanks for any help,
Anthony
