topic Re: Interesting Shell Script Requirement in Operating System - Linux

Interesting Shell Script Requirement

Anurag_7 — Tue, 09 May 2006 08:47:06 GMT

There is a command for which the output is as follows

-----------------------------------
1
2
3
4 5 6 7
8 9 10 11
12 13 14 15
16 17 18 19

-----------------------------------

The requirement is to extract information from the 4th line and write it to a file as comma separated values 4, 5, 6, 7

And similary for the next two lines(each line goes to a different file.)

Is there a good way to do this?

Any help in this regard would be highly appreciated.

Regards,

Anurag

Re: Interesting Shell Script Requirement

Ivan Ferreira — Tue, 09 May 2006 08:59:38 GMT

Maybe something like this:

awk 'NR==$2 {print $0}' $1 | tr " " "," > $3

Usage:

script.sh line_numb input_file output_file

Re: Interesting Shell Script Requirement

Peter Godron — Tue, 09 May 2006 09:00:40 GMT

Anurag,
assuming your initial data file is called a.dat. Also that there are no trailing spaces.
This command translates all spaces into commas and writes the new data to file b.dat.

tr " " "," < a.dat > b.dat

will create

1
2
3
4,5,6,7
8,9,10,11
12,13,14,15
16,17,18,19

Re: Interesting Shell Script Requirement

Kent Ostby — Tue, 09 May 2006 09:05:01 GMT

create a file called "pull.awk" which looks like this:

NR<7&&NR>3 {for (idx=1;idx=NF;idx++) {printf("%s,",$idx);}
printf("\n");}

awk -f pull.awk < inputfile > outputfile

That takes care of the comma seperated part.

What is the file name syntax that you are using for each file?

Re: Interesting Shell Script Requirement

Enrico P. — Tue, 09 May 2006 09:29:15 GMT

Hi,
you can try with:

head -n n_of_line file_source|tail -1|sed 's/ /,/g' > file_dest

Enrico

Re: Interesting Shell Script Requirement

Rodney Hills — Tue, 09 May 2006 09:46:49 GMT

Here is something that will generate the individual files. 1 per line starting with the fourth line of your input file-

awk 'NR>3{gsub(" ",",");print $0}' yourdata.dat | split -l1 - outfil

This will generate files outfilaa, outfileab, etc. One file per line.

HTH

-- Rod Hills

Re: Interesting Shell Script Requirement

A. Clay Stephenson — Tue, 09 May 2006 09:51:01 GMT

I'm looking for the interesting requirement; none of this interests me in the least.

Re: Interesting Shell Script Requirement

Peter Nikitka — Tue, 09 May 2006 12:12:36 GMT

Hi,

yourcommand |
awk -v OFS=, 'NR>3 {out="/tmp/outf"++x;for (i=1;iout;print $NF >out;close(out)}'

will produce files /tmp/outf* .

mfG Peter

Re: Interesting Shell Script Requirement

Anurag_7 — Tue, 09 May 2006 12:20:59 GMT

Thanks a lot Iva, Peter Godron, Kent, Enrico, Rodney, Peter Niktka......

All the solution were damn good......

I will handle the naming convention for the output files myself.

Thanks a lot again

Anurag

Re: Interesting Shell Script Requirement

Anurag_7 — Tue, 09 May 2006 12:23:24 GMT

Solution Found with the help of other forum members.