Search Results

I have requirement where i need to read data from .sh file. I am using awk to identify the particualr data and extracting it.
mY CODE : awk '/SELECT/,/;/' SOURCE.sh
I am getting output as...

It is giving me syntax error...:(

awk: syntax error near line 1
awk: bailing out near line 1

Thanks for quick reply..but,

My SQL statement is not on a single line. I am reading from a file say .txt which has many other statement apart from 'select'.

Say my file source.txt is like:
...

Hi all,

I have a requirement where i have to search data between strings 'SELECT' and ';' and replace this text as "SELECT.....;" so that i can export this extracted string into a excel cell.
...

No requirement is of same csv file for all iterations so for that 'echo grep shell' will work?
No i am still figuring out on how to build the code but the idea is to use only one csv output file....

I meant iterative...My requirement is to find text between specific strings using awk send this to csv file then move ahead and find the next string send it to csv and so on till the end of the...

Can someone help me coding a loop (like for loop in C)? I mean what is the syntax....?

My requirement is, i have to send every successive string searched using awk to a csv file till the end of...

tnx a ton... its works great

Can someone tell me, how do i write a recursive code using shell ( eg like 'for' loop in C) which outputs the record to a database table as one row per iteration?

The awk is giving below output:

SELECT
divrel.child_org_idn org_main_idn
NULL ( VARCHAR(200)) div_nam_2
NULL ( VARCHAR(200)) div_nam_3
NULL ( VARCHAR(200)) div_nam_4
NULL (...

:)dat really works... great and tnx a ton...

The awk is outputting the file with ; as delimiter. so do i hv to change the delimiter to , manually? also the data shud go into different rows of the excel bt nt into differnt columns.... suggest on...

Can someone help me out to export awk output to excel file in different rows? Plzzzz its urgent...:(

I have requirement where i have to export the data extracted from a flat file to a microsoft excel sheet. If the awk returns multiple records then all these records should go in into different rows...

I have a requirement where i have to read from a .sh file a text lying bet characters like 'SELECT' & ';'...Please help me out in this. I am new to shell scripting.