Shell Programming and Scripting

Hi,

I want to print two columns from a .txt file to a .csv file using awk.

data in text file:

Application
-------------------------------------------------- -----------
OS Related Issues 1
EMEA Solutions 9
Global Solutions 2


what i want to print is:

OS Related Issues,1
EMEA Solutions,9
Global Solutions,2

Please suggest some way to get this done. I'm new to shell scripting and m not really familiar with awk.

Thanks in advance.

FYI: working on ksh

Code:

$ awk '{for(i=1;i<NF;i++){printf("%s ",$i)} printf(",%s\n",$NF)}' test.txt 
OS Related Issues ,1
EMEA Solutions ,9
Global Solutions ,2

---------- Post updated at 01:39 PM ---------- Previous update was at 01:25 PM ----------

Code:

$ awk '$NF=","$NF' test.txt
OS Related Issues ,1
EMEA Solutions ,9
Global Solutions ,2

is there any way to skip the first two lines and display values from the 3rd line..??

the text file starts with:

Application
-------------------------------------------------- -----------

i want to remove the first two lines and get values from the 3rd line.. is that possible..??

you can use

Code:

 
if ( NR >= 3 )

If the additional blank is/was no problem you can try:

Code:

$> awk 'NR>2 {$NF=","$NF; print}' infile
OS Related Issues ,1
EMEA Solutions ,9
Global Solutions ,2

that worked fine.. one last question (i know i should have asked this earlier), how do i avoid the last line in that file..? sorry for bothering..

With a little adjustment of zaxxon's code:

Code:

awk 's{print s} NR>2 {$NF=","$NF; s=$0}' infile