2

Syntax error using Awk

view story
linux-howto

http://www.unix.com – more report2.txt Quote: col1 col2 col3 col4 . . coln how to modify the AWK to print above out put for given n no of inputs using report2.txt file? out put should be Quote: A.col1=B.col1 and A.col2 = B.col2 and A.col3 = B.col3. .. .. A.coln= B.coln where (HowTos)

suki's picture
Submitted by suki on 09/21/2010

Stories similar to Syntax error using Awk

Hi All,

I got stuck up with shell script where i use awk. The scenario which i am working on is as below.

Moving columns around 51 weeks 2 days ago

This is a mysql night mare that I cant seem to wrap my head around.

Hi,

I need to compare multiple columns from 2 files.

I can, for example, have these 2 files:

file1:

Code: col1, col2, col3,col4 a,1,4,7 b,2,5,8 c,3,6,9 file2:

Code: col1, col2, col3,col4 a,2,3,2 b,5,7,5 c,1,9,8 As a result, I need for example the difference between the columns 2 and 4:

Code: col2, col4 1,-5 3,-3 -2,-1 I made something that works for comparing 1 column, but I w

Column overruns in bash 27 weeks 6 days ago

So say you have something like:

Code: col1        col2        col3 .          .          . .          .          . Say using bash you want the columns to always have exactly the same width (including spaces).

Hi All,

i have a CSV file like below,

col1 col2 col3 col4 col5 col6 col7 a1 a2 a3 a4 a5 a6 a7 b1 b2 b3 b4 b5 b6 b7 c1 c2 c3 c4 c5 c6 c7 d1 d2 d3 d4 d5 d6 d7

Col1,col2.. are the column names and a1,a2,b1,b2..

I want to the following results using unix script, can some one help ? Thanks

Input:

select col1, col2 from tab1 where ......... select col1,.....,coln from tab2, tab3 where.... select clo1,clo2,col3 from tab4 where...

output (results) tab1 tab2 tab3 tab4

basically I need the list of table names from list of select statements in a file.

Thank You,

Hi

My file have 7 column, FIle is pipe delimed

Code: Col1|Col2|col3|Col4|col5|Col6|Col7 I want to find out uniq record count on col3, col4 and col2 ( same order) how can I achieve it. ex

Code: 1|3|A|V|C|1|1 1|3|A|V|C|1|1 1|4|A|V|C|1|1 Output should be

Code: FREQ|A|V|3|2 FREQ|A|V|4|1 Here last column is count.

Moderator's Comments:

I have an input file with contents in the following format:

ABCD XYZAB 1234 PQRSTUV STU SKIP LMN OPRQM 8966 RSTUV OPM SKIP TUV ZXU SKIP

I want to parse this file and output it to a new file such that, rows with their last column as "SKIP" do not appear in the final output file, as below:

ABCD XYZAB 1234 LMN OPRQM 8966

To process the above, I wro

I want to the following results using unix script, can some one help ? Thanks

Input:

Code: select col1, col2 from tab1 where ......... select col1,.....,coln from tab2, tab3 where.... select clo1,clo2,col3 from tab4 where...

output (results)

Code: tab1 tab2 tab3 tab4 basically I need the list of table names from list of select statements in a file.

Thank You,