Search Results

$ tr "\n" " " < input.txt | nawk '{for(i=1;i<=NF-1;i++){if($i~/from/){print $(i+1)}}}'
table_name1
table_name2
table_name3
table_name4

Hi,
Please use this code

$ sed -n '/from/,/where/p' f1.txt|awk '{print $4}'

O/p:-
----
$ sed -n '/from/,/where/p' f1.txt|awk '{print $4}'
xyz
abc


$ cat f1.txt
select * from...