Shell Programming and Scripting

Jambesh try this one.....here jam1.txt is lookup file and jam2.txt is data file needs to be rearranged.you need to create temp directory in directory where you will run this script.May be this will help...and jamt will be the output file

Code:

maxcol=`sed '1q' jam1.txt | awk -F" " '{print NF}'`
col_look=`sed '1q' jam1.txt`
col_seq=`sed '1q' jam2.txt`
set -A look $col_look
set -A seq $col_seq
set -A pos

i=0
while [ $i -lt $maxcol ]
  do
   j=0
   while [ $j -lt $maxcol ]
   do
   [[ "${look[$i]}" = "${seq[$j]}" ]] && pos[$i]=`expr $j + 1` 
   j=`expr $j + 1`
  done
i=`expr $i + 1`
done

k=0
while [ $k -lt $maxcol ]
do
cut -d ' ' -f${pos[$k]} jam2.txt>temp/tempjam${k}  
 k=`expr $k + 1`
done

paste temp/tempjam* >jamt
rm -f temp/tempjam*

p.s.
output file columns will be tab delimeter if you want to make it space delimited replace "paste command with

Code:

paste -d ' ' temp/tempjam* >jamt

Dhruv,

Here is my jam2.txt file

cat jam2.txt
MANDT SERAIL EQTYP SERSCHA SEREX BSTVP
510 hsgdfs 44 sercha sex1 bst233
510 bg 89 fg 23 98
510 gh 89 we sew mn

jam1.txt contain look up column

MANDT SERAIL SERSCHA SEREX EQTYP BSTVP

when i run your script it produce jamt but upon cat the file
i got the out put in a garbled form not readable

out put of jam1.txt should be jampt and it should contain
MANDT SERAIL SERSCHA SEREX EQTYP BSTVP
510 hsgdfs
510 bg
510 gh

this way ...but i got the result like ...

MANDT SERAIL EQTYP SERSCHA SEREX BSTVP MANDT SERAIL EQTYP SERSCHA SEREX BSTVP MANDT SERAIL EQTYP SERSCHA SEREX BSTVP MANDT SERAIL EQTYP SERSCHA SEREX BSTVP MANDT SERAIL EQTYP SERSCHA SEREX BSTVP MANDT SERAIL EQTYP SERSCHA SEREX BSTVP
510 hsgdfs 44 sercha sex1 bst233 510 hsgdfs 44 sercha sex1 bst233 510 hsgdfs 44 sercha sex1 bst233 510 hsgdfs 44 sercha sex1 bst233 510 hsgdfs 44 sercha sex1 bst233 510 hsgdfs 44 sercha sex1 bst233
510 bg 89 fg 23 98 510 bg 89 fg 23 98 510 bg 89 fg 23 98 510 bg 89 fg 23 98 510 bg 89 fg 23 98 510 bg 89 fg 23 98
510 gh 89 we sew mn 510 gh 89 we sew mn 510 gh 89 we sew mn 510 gh 89 we sew mn 510 gh 89 we sew mn 510 gh 89 we sew mn

unreadable ------please assist me asap im in stuck last two days

f1=${ccseq[0]};f2=${ccseq[1]};f3=${ccseq[2]};f4=${ccseq[3]};f5=${ccseq[4]};f6=${ccseq[5]}

awk -v c1=$f1 -v c2=$f2 -v c3=$f3 -v c4=$f4 -v c5=$f5 -v c6=$f6 'BEGIN{OFS=FS="\t"} {print $c1,$c2,$c3,$c4,$c5,$c6}' ${fname}

what is the problem with this two line ??? i could not get ? any idea to correct it so that it will print the desired column ????

i have checked with the below files and found output file jamt.Please see i had updated my post with paste command.you remove rm command in script and check what is going into tempjam files.
jam1.txt:::

Code:

col1 col2 col3 col4
11 22 33 44
111 222 333 444

jam2.txt::::

Code:

col3 col4 col2 col1
33 44 22 11
333 444 222 111
3 4 2 1

jamt::::

Code:

col1 col2 col3 col4
11 22 33 44
111 222 333 444
1 2 3 4

Dhruv ,
Here is sample out put of each of temjam0 , tempjam1 tempjam2,....
tempjam0 tempjam1 tempjam2 tempjam3 tempjam4 tempjam5
$ cat tempjam0
MANDT SERAIL EQTYP SERSCHA SEREX BSTVP
510 hsgdfs 44 sercha sex1 bst233
510 bg 89 fg 23 98
510 gh 89 we sew mn

$ cat tempjam1
MANDT SERAIL EQTYP SERSCHA SEREX BSTVP
510 hsgdfs 44 sercha sex1 bst233
510 bg 89 fg 23 98
510 gh 89 we sew mn

$ cat tempjam2
MANDT SERAIL EQTYP SERSCHA SEREX BSTVP
510 hsgdfs 44 sercha sex1 bst233
510 bg 89 fg 23 98
510 gh 89 we sew mn

$ cat tempjam3
MANDT SERAIL EQTYP SERSCHA SEREX BSTVP
510 hsgdfs 44 sercha sex1 bst233
510 bg 89 fg 23 98
510 gh 89 we sew mn

$ cat tempjam4
MANDT SERAIL EQTYP SERSCHA SEREX BSTVP
510 hsgdfs 44 sercha sex1 bst233
510 bg 89 fg 23 98
510 gh 89 we sew mn

$ cat tempjam5
MANDT SERAIL EQTYP SERSCHA SEREX BSTVP
510 hsgdfs 44 sercha sex1 bst233
510 bg 89 fg 23 98
510 gh 89 we sew mn
sequence is not changing in any of the file ...what is wrong ?
i guess each of the file should produce only one column ..right ?? but it is containing the whole file again surprise !!!!!!!!!!!!!!

yes only one column in each file.problem here is with cut command.
run the below commands on command line one by one and check what is going in files.The field delimeter is single space.
Make sure there is a single space in ' ' (single quotes in below command)

Code:

cut -d ' ' -f1 jam2.txt>temp/tempjam0
cut -d ' ' -f2 jam2.txt>temp/tempjam1
cut -d ' ' -f3 jam2.txt>temp/tempjam2

dhruv,
You are cutting data using cut -d ' ' ??? it is a space delimeter but i think it should be tab delimited ??
is it the problem please assist me.