line to column using awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting line to column using awk
# 8  
Old 01-17-2008
Quote:
Originally Posted by vgersh99
Code:
nawk 'ORS=(FNR%3)?FS:RS' myFile

The above command (nawk) works perfectly! I discarded the last awk command...

awk 'BEGIN {FS="\n";RS="";ORS=""} { x=1; while (x<NF) {print $x"\t"; x++} print $NF "\n"}'

so the structure is...

string1
string2
string3
string(n)

and inserted...

nawk 'ORS=(FNR%3)?FS:RS'

and got...

string1 string3 string3 string(n)

plus i wanted a tab delimited so the final code was...

....nawk 'ORS=(FNR%3)?FS:RS' | awk 'BEGIN {OFS="\t"} {print $1,$2,$3}'

thanks for all replies!

Last edited by genix2008; 01-17-2008 at 11:06 PM..
# 9  
Old 01-18-2008
Understand that you are expecting an awk solution.But what about this?

Code:
cat file3 | xargs -n3

# 10  
Old 01-18-2008
Quote:
Originally Posted by jacoden
Understand that you are expecting an awk solution.But what about this?

Code:
cat file3 | xargs -n3

hey, your code this worked as well... this how i used it.

....some codes | xargs -n3 | awk 'BEGIN {OFS="\t"} {print $1,$2,$3}'

for tab delimited ouput.

thanks!

Last edited by genix2008; 01-18-2008 at 02:27 AM..
# 11  
Old 01-18-2008
Quote:
Originally Posted by genix2008

plus i wanted a tab delimited so the final code was...

....nawk 'ORS=(FNR%3)?FS:RS' | awk 'BEGIN {OFS="\t"} {print $1,$2,$3}'

thanks for all replies!
why?

Code:
....nawk -v OFS='\t' 'ORS=(FNR%3)?OFS:RS'

# 12  
Old 01-21-2008
Quote:
Originally Posted by vgersh99
why?

Code:
....nawk -v OFS='\t' 'ORS=(FNR%3)?OFS:RS'

i will try also.... i don't know anything about nawk. i know, man nawk. thanks....
Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add column to end of each line with ´awk´

Hi, I have data with approximately 300 columns. I want to add a column to the end of each column with the value "1". Is there a way that I can do this is ´awk´ without having to specify each individual column. For instance, my data looks like: pvb 1 2 3 4 5 ....... 300 fdh 3 4 5 2 4 ......... (4 Replies)
Discussion started by: owwow14
4 Replies

2. UNIX for Dummies Questions & Answers

awk help: how to pull phrase and one column from line above?

Hi everyone, Here's my awk statement so far: awk '/TOTAL TYPE:/{print x;print};{x=$0}' file1 >file2 'file1' has too much proprietary data in it to include here, so let's go with the output from code above. It looks like this: 123456 JAMES T KIRK D ... (2 Replies)
Discussion started by: Scottie1954
2 Replies

3. Shell Programming and Scripting

KSH or Awk first and last line based on column 2

Example: 10.160.101.160,0707073711,22.203.203.200 10.160.101.160,0707075132,22.203.210.249 10.160.101.160,0707085436,22.203.210.249 10.160.101.160,0707091712,22.203.221.176 10.160.101.160,0707091811,22.203.221.176 10.160.101.160,0707091845,22.203.221.176... (1 Reply)
Discussion started by: BrownBob
1 Replies

4. Shell Programming and Scripting

awk , conditional involving line and column

Dear All, I indeed your help for managing resarch data file. for example I have, data1.txt : type of atoms z vz Si 34 54 O 20 56 H 14 13 Si 40 17 O ... (11 Replies)
Discussion started by: ariesto
11 Replies

5. Shell Programming and Scripting

Awk next line as column

Hi, This forum rocks. I think this might be an easy thing, but since I am new to awk, please help me. input: x y z 1 a b c 2 d e f 3 g h i 7 output: x y z 1 a b c 2 d e f 3 (8 Replies)
Discussion started by: jacobs.smith
8 Replies

6. Shell Programming and Scripting

Counting rows line by line from a specific column using Awk

Dear UNIX community, I would like to to count characters from a specific row and have them displayed line-by-line. I have a file called testAwk2.csv which contain the following data: rabbit penguin goat giraffe emu ostrich I would like to count in the middle row individually... (4 Replies)
Discussion started by: vnayak
4 Replies

7. Shell Programming and Scripting

awk : Remove column1 and last column in a line

Hi All, How to remove col1 and last column in a line. Please suggest some awk stuffs. Input col1 col2 col3 col4 col1 col2 col3 col4 col5 col1 col2 col3 col4 col1 col2 col3 Output Processing col2 col3 ... Processing col2 col3 col4 ... Processing col2 col3 ... Processing... (5 Replies)
Discussion started by: k_manimuthu
5 Replies

8. Shell Programming and Scripting

awk search column, print line

Hello. I've been banging my head against walls trying to search a comma delimited file, using awk. I'm trying to search a "column" for a specific parameter, if it matches, then I'd like to print the whole line. I've read in multiple texts: awk -F, '{ if ($4 == "string") print $0 }'... (2 Replies)
Discussion started by: Matthias03
2 Replies

9. Shell Programming and Scripting

awk convert from line to column

i have an output like this : 012008 25760883 022008 12273095 032007 10103 032008 10115642 042007 20952798 but i would like to have it like this 012008,25760883 022008,12273095 032007,10103 032008,10115642 042007,20952798 (4 Replies)
Discussion started by: jarmouda
4 Replies

10. Shell Programming and Scripting

awk to select a column from particular line number

The awk command awk -F: '{print $1}' test1 gives the first columns of all the lines in file ,is there some command to get a particular column from particular line . Any help is appreciated. thanks arif (4 Replies)
Discussion started by: mab_arif16
4 Replies
Login or Register to Ask a Question