Shell Programming and Scripting

hi,

i can't use paste because in the FILEB there's more line then FILEA so if i sort the two file and do paste i will not get the result.
can u help me to loop this problem with shell script to paste every info in each correspond line and after that i sort this file by columns (info columns).

thanks

Well can you show a sample of the contents of fileA and fileB?

Sample of FILEA :


comp, PASS
sim, FAILED
UF, PASS
promo, FAILED
xy, PASS
bad, PASS
bad_12, PASS
bridge_AD, FAILED
sim_V3 PASS
split_LSF, PASS
multiple, FAILED

and FILEB

comp, PASS
sim, test_sim
UF, data_uf
promo, data_uf
bad, test_bad
split_LSF, groupe_lsf
multiple, groupe_test

thanks

And what is the expected output based on the sample contents of fileA and fileB?

Sample of FILEA :


comp, PASS
sim, FAILED
UF, PASS
promo, FAILED
xy, PASS
bad, PASS
bad_12, PASS
bridge_AD, FAILED
sim_V3 PASS
split_LSF, PASS
multiple, FAILED

and FILEB

comp, groupe1
sim, test_sim
UF, data_uf
promo, data_uf
bad, test_bad
split_LSF, groupe_lsf
multiple, groupe_test

the excepted output is
FILEA:

comp, groupe1
sim, FAILED test_sim
UF, PASS data_uf
promo, FAILED data_uf
xy, PASS test_bad
bad, PASS
bad_12, PASS
bridge_AD, FAILED
sim_V3 PASS
split_LSF, PASS groupe_lsf
multiple, FAILED groupe_test


thanks

Code:

sort -t"," -k1,1 fileA > FILEA
sort -t"," -k1,1 fileB > FILEB
join -t"," -1 1 -2 1 -a 1 -o 1.1 1.2 2.2 FILEA FILEB > output.txt