Shell Programming and Scripting

INPUT

have a file with 2 columns. evry set in a column ends with a symbol //.
the first one with something like chr, chr no, chromosome name, cell no. cell no. etc and the second column has values belong to the first columnlike chr Xy, 22, 345,22222 etc. Some clumns have repeated but not duplicate values. with these I want to make file with first cloumn as first row and second olumn as second row and so on...

chr chrXY
chr no 22
chrname FUUR
Cell 224Neuron
Cell no 22222

//

chr chrYY
chr no 23
chrname FUUS
Cell 225Neuron
Cell no 22223

//

chr chrYY
chr no 24
chrname FUUT
Cell 226Neuron
Cell no 22222
Cell 227Neuron
Cell no 222245
Cell 230Neuron
Cell no 22245
//

chr chrYY
chr no 25
chrname RUUS
Cell 225Neuron
Cell no 52223

OUTPUT

hr .........chr no....... chrname ......Cell............. Cell no

chrXY....... 22 ............FUUR .........224Neuron..... 22222
chrYY .......23 .............FUUS .........225Neuron .....22223
chrYY....... 24 .............FUUT.......... 226Neuron.... 222222
...................................................227Neuron.... 222245
..................................................230Neuron ......22245
chrYY .......25............. RUUS ..........225Neuron ......52223

Try this:

Code:

awk '
        BEGIN { printf("%8s %8s %8s %10s %8s\n","chr","chrno","chrname","cell","cellno") }
        /^chr no/ { chrno=$3; next }
        /^chr / { chr=$2; next }
        /^chrname / { chrname=$2; next }
        /^Cell no / {
                cellno=$3
                printf("%8s %8s %8s %10s %8s\n",chr,chrno,chrname,cell,cellno)
                chr=chrno=chrname=cell=cellno=""
                next
        }
        /^Cell / { cell=$2; next }
' inputfile

Thanx alot for the reply and tour valuble time
but i have a huge file and these are the som of the lines i have extarcted from the data base.
I think the same code is not apllicable to the whole databse rt.
And most importantly the list is not in the order.

????

If you ask an incomplete question, you will get an incomplete answer. The output of my solution is almost exactly what you described, and in the same order:

Code:

     chr    chrno  chrname       cell   cellno
   chrXY       22     FUUR  224Neuron    22222
   chrYY       23     FUUS  225Neuron    22223
   chrYY       24     FUUT  226Neuron    22222
                            227Neuron   222245
                            230Neuron    22245
   chrYY       25     RUUS  225Neuron    52223

hey sorry da if u find it hard
may b my mistake. I will try to post clearly. but the data is huge and i'm unable to make i tprecise.