I'd like to use awk to pull out information from SQL output like the following:
(count(distinct serverclass)='2')
And need to extract the number, which is 2 in this example.
I'd like to do something like the following, but cannot figure out how to escape the single quote:
<sqlCommand> | awk 'BEGIN{FS="'"}{print $2}'
How can I get a literal single quote as my field separator in awk?