Search Results

Other than awk, how do I execute all these SQL's and have the output printed in a txt file?

Hi All,

I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.

Can you anyone pls let me know how do I do it and execute...

Thanks agama.

My Bad. As you mentioned, There were three more empty lines after the first line in the input file.

The awk code goes like the below, (input.txt and output.txt is provided below). The output prints the same XML four times. The first XML only contains the valid values from the input and the...

My Output in the text file output.txt is getting printed thrice now.

The input is,

2012-01,S27,GC00000T

command used:

awk -f test.awk input.txt > output.txt

Script:

BEGIN{
FS=",";...

Wow. That worked. Thanks. Can you please explain what was done? I did not understand the code
sed 's/'`printf "\015"`'//g' test.awk > test_new.awk.

Also What should I do to avoid this error if I...

It prints


mdmdev:/usr/chandra# awk 'BEGIN { print "hello world" }'
hello world

I modified the code as above and this time also , I almost got the same error,

mdmdev:/usr/chandra# awk -f test.awk input.txt > output.txt
syntax error The source line is 1.
The error context...

Yes Exactly this is the output I need. But Why Am i not able to get the success response? I am trying to execute this in an AIX server that has awk installed. Unix is the OS.

Hi,

I have an awk script(test.awk) as below which I am trying to execute through the following command and I am getting error as follows. Request your valid inputs on where I am going wrong....