Search Results

This code will not work since it contains an error because curly braces are used in the assignment.
For array assignment you need normal parentheses.

LOG_FILES=( "/Sandbox/logs/*" )
for file...

For completeness, some other ways to avoid shell quoting:
awk '$7=="PASS" && $0~ q "oncomineGeneClass" q ":" && $0~ q "oncomineVariantClass" q ":"' q=\" file

Reverse shell quoting:
awk...

Not quite. That does not give the output requested in post #1; the merge option to sort does not remove duplicates.

You could also use:
awk -v p1="PASS" -v p2="'oncomineGeneClass'" -v p3="'oncomineVariantClass':" '$0 ~ p1 && $0 ~ p2 && $0 ~ p3' file

So, in other words: match(s, r) takes a single regular expression, not multiple re's.


--
Another example:
awk '$7=="PASS" && /oncomineGeneClass/ && /oncomineVariantClass/' file

You could place the code in a file.awk to avoid the shell quoting.
You could also,
awk '$7=="PASS" && /\47oncomineGeneClass\47:/ && /\47oncomineVariantClass\47:/' file

Try: (GNU sed):
sed -r "s/([^']*)(('[^']*')?)/\L\1\E\2/g" file

Try awk -F"'" -vOFS="'" '{for (i=1; i<=NF; i+=2) $i = tolower($i)} 1 ' file
select a.login_id,a.password,nvl(a.temp_pass_expiry_dt,systimestamp),nvl(upper(a.status), ' ')
into v_login_id,...

Hi, AbelLuis.

Unless there is something additional here (or that I missed), this appears to fail if the quoted string is not bounded by whitespace ... cheers, drl

Results:
select...