Thanks for reply.
I wrote a php code that creates the following command:
join -t$'\t' -a1 -a2 -e- -j1 -o0,1.2,2.2 <(awk -f agg.awk fff1.txt) <(awk -f agg.awk fff2.txt) |
join -t$'\t' -a1 -a2 -e- -j1 -o0,1.2,1.3,2.2 - <(awk -f agg.awk fff3.txt) |
join -t$'\t' -a1 -a2 -e- -j1 -o0,1.2,1.3,1.4,2.2 - <(awk -f agg.awk fff4.txt) |
join -t$'\t' -a1 -a2 -e- -j1 -o0,1.2,1.3,1.4,1.5,2.2 - <(awk -f agg.awk fff4.txt) |
join -t$'\t' -a1 -a2 -e- -j1 -o0,1.2,1.3,1.4,1.5,1.6,2.2 - <(awk -f agg.awk fff6.txt) > tmp.txt
My only concern now is why it does not work if I call from php.
My php file is:
PHP Code:
<?php
$command ="awk -f onecol.awk f1.txt > outfirst.txt";
system($command);
$command ="join -t$'\\t' -a1 -a2 -e- -j1 -o0,1.2,2.2 <(awk -f agg.awk fff1.txt) <(awk -f agg.awk fff2.txt) > outsecond.txt ";
system($command);
?>
Thanks