Awk help 1

[driddickemc]

Looking to parse a file.. excel.. looks like..

data 10000
20000

data2 30000
40000

I need output to be as such..

data 10000 20000
data2 30000 40000

Please help not scripting guru

 

[PHV]

You really want to parse an EXCEL file with AWK ????

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[driddickemc]

I copy it into a text file.. so that's what the text file looks like..

 

[PHV]

A starting point:
awk 'NF==2{if(NR>1)print x;x=$1" "$2;next}NF{x=x" "$1}END{print x}' /path/to/input > output

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[driddickemc]

Worked great !