Awk/grep

Shell Programming and Scripting
1

Hi,
I have been trying to resolve this issue but no luck !....please suggest !
I need to grep or awk(which ever helps me best) a pattern from a list of 1000 files in a given dir but the pattern is a lil tricky:
pattern : '"${ETL_VW_SCHEMA}"'.<my_table>
The quotes are mandatory(both single and double)

awk '/"{EDW_DB_SCHEMA}".WRKR/ || !/otable/&&/"{EDW_DB_SCHEMA}".WRKR/ || !/db-ter-load-data/&&/"{EDW_DB_SCHEMA}".WRKR/' <graph>.ksh

Please suggest..
Anduzzi

2

just use grep.

grep '\'"'${ETL_VW_SCHEMA}'"\''.my_table

i can't really see what quote comes first but....

These: '\'"' are stand-alone patterns.
The outside ticks are removed by the shell parser.
the \'" is passed into grep, without the backslash.

hth

3

grep '\'"'${ETL_VW_SCHEMA}'"\''.my_table
i can't really see what quote comes first but....

Single quote first and then double.
Eg text: (select emp_num from '"${ETL_VW_SCHEMA}"'.WRKR)

I am trying this:
grep '\'"${ETL_VW_SCHEMA}"'\.WRKR' *.ksh

but the parser still wudn't consider the pattern after backslash.
Any issue here?..

-Anduzzi

4

Single quotes cannot be included in a single-quoted string, but can be in a double=quoted one. Double quotes can be included in a double=quoted string, but must be escaped:

"'\"${ETL_VW_SCHEMA}\"'.<my_table>"