a deep question about file format exchange !

Pacific Yan

Now the question getting a little bit deeper,

So how to re-write a shell script (no PERL or Java) to
change the the file format from file 1 to
file 2 and file 3?

file 1:

CASP1 (ADBA)   , CASP2, CASP3(abhjk) , CASP4, CASP5, CASP6, CASP7, CASP8, CASP9, CASP10, CASP13, .......



file 2:    FILE3:


CASP1       ADBA          <<<<<<<<
CASP2       CASP2
CASP3       abhjk          <<<<<<<<
CASP4       CASP4
CASP5       CASP5
CASP6       CASP6
CASP7       CASP7
CASP8       CASP8
CASP9       CASP9
CASP10     CASP10
  
......     ....


Thanks,

Pacific Yan

actually it is just deeper than my previous one

Pacific Yan

Sorry my question confuse you, I want the file 1 produce two new files (file 2 and file3), file 2 like this;

CASP1
CASP2
CASP3
CASP4
CASP5
CASP6
CASP7
CASP8
CASP9
CASP10
CASP13

file 3 like this

ADBA
CASP2
abhjk
CASP4
CASP5
CASP6
CASP7
CASP8
CASP9
CASP10
CASP13



Also, your scripts doesn't filter out the "()" completely, see my following output (marked).


Thanks and have a good day!



bash-2.00$ cat yourfile|tr "()" " " >yourfile.tmp
awk 'BEGIN {RS=","}
{if ($2 != "" print $1,$2;
else
print $1,$1}' yourfile.tmp
bash-2.00$ awk 'BEGIN {RS=","}
> {if ($2 != "" print $1,$2;
> else
> print $1,$1}' yourfile.tmp
CASP1 ADBA)     <<<<<<<<<<<<<<
CASP2 CASP2
CASP3 abhjk)    <<<<<<<<<<<<<
CASP4 CASP4
CASP5 CASP5
CASP6 CASP6
CASP7 CASP7
CASP8 CASP8
CASP9 CASP9
CASP10 CASP10
CASP13 CASP13
bash-2.00$ cat yourfile
CASP1 (ADBA)  , CASP2, CASP3(abhjk)  , CASP4, CASP5, CASP6, CASP7, CASP8, CASP9, CASP10, CASP13
bash-2.00$