Awk 2 lines to 1 line

pinnacle · #1 (**permalink**) 04-22-2009

Input File:

Quote:

Input:
host1 server1
database1 5
host2 server2
database2 5
host3 server3
database3 5

Required Result:

Quote:

host1 server1 database1 5
host2 server2 database2 5
host3 server3 database3 5

I have tried the following code:

Code:

nawk '{for(i=1; i<=NR; i+2) {print NR,$0; getline ;print \n $0; NR=NR+2}}' temp

But doesnt gives the right result.
Help is appreciated

vgersh99 · #2 (**permalink**) 04-22-2009

Code:

paste -d' ' - - < temp
OR
nawk 'ORS=(FNR%2)?FS:RS' temp

pinnacle · #3 (**permalink**) 04-22-2009

Quote:

Originally Posted by vgersh99

Code:

paste -d' ' - - < temp
OR
nawk 'ORS=(FNR%2)?FS:RS' temp

Thank you pro

Code:

paste -d' ' - - < temp
nawk 'ORS=(FNR%2)?FS:RS' temp

Would appreciate if you can explain this.

vgersh99 · #4 (**permalink**) 04-22-2009

Quote:

Originally Posted by zenith

Thank you pro

Code:

paste -d' ' - - < temp
nawk 'ORS=(FNR%2)?FS:RS' temp

Would appreciate if you can explain this.

You can read the man pages for 'paste' to give you a high-level of what it does - the rest should be easy.
awk:

Code:

(FNR%2) - get a 'modulo' of the current file RecordNumber (FNR) over 2 - every OTHER line.
If the mod is NON-zero, return 'FS' (FieldSeparator)
If the mod is zero, return RecordSeparator (RS)
ORS= - assign the returned value to the OutputRecordSeparator (ORS)

In other words...
If we're dealing with the ODD record/line numbers (1,3,5,7 etc), print the line and FS (separate the next line)
If we're dealing with the EVEN record/line numbers (2.4.6.8 etc), print the line and the ORS (which is by default is newLine).

pinnacle · #5 (**permalink**) 04-22-2009

Quote:

Originally Posted by vgersh99

You can read the man pages for 'paste' to give you a high-level of what it does - the rest should be easy.
awk:

Code:

(FNR%2) - get a 'modulo' of the current file RecordNumber (FNR) over 2 - every OTHER line.
If the mod is NON-zero, return 'FS' (FieldSeparator)
If the mod is zero, return RecordSeparator (RS)
ORS= - assign the returned value to the OutputRecordSeparator (ORS)
 
In other words...
If we're dealing with the ODD record/line numbers (1,3,5,7 etc), print the line and FS (separate the next line)
If we're dealing with the EVEN record/line numbers (2.4.6.8 etc), print the line and the ORS (which is by default is newLine).

Thank you Sir,

Minor change; need output comma seperated.

I have tried this but has syntax error.

Code:

nawk '{ORS=(FNR%2)?FS:RS}; OFS=,' temp

Appreciate your help

vgersh99 · #6 (**permalink**) 04-22-2009

Code:

nawk -F, 'ORS=(FNR%2)?FS:RS' temp

pinnacle · #7 (**permalink**) 04-22-2009

Quote:

Originally Posted by vgersh99

Code:

nawk -F, 'ORS=(FNR%2)?FS:RS' temp

When i pasted input file on website. i have some weird spaces but when i pasted i think website removed it. hence i am attaching it.

Requried Result
host1,server1,database1,5
host2,server2,database2,5
host3,server3,database3,5

Result i am getting is also attached

Appreciate help

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
cat file1 read line-per-line then grep -A 15 lines down in fileb	irongeekio	Shell Programming and Scripting	6	01-28-2009 06:30 AM
Joining lines in reverse. append line 1 to line 2.	dwalley	Shell Programming and Scripting	7	08-04-2008 07:11 AM
Appending line number to each line and getting total number of lines	chiru_h	Shell Programming and Scripting	2	03-25-2008 10:19 AM
to make 2 lines into 1 line using awk	cdfd123	Shell Programming and Scripting	2	10-03-2007 07:44 PM
Appending line/lines with sed	nir_s	Shell Programming and Scripting	28	07-24-2005 02:36 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: