#!/bin/bash
#
#
cut -f1 -d'^' FOOD_DES.txt > /tmp/dbjoin1
cut -f2 -d'^' FOOD_DES.txt | sed -e "s/^~0/~/" | sed -e "s/00~$/~/" > /tmp/dbjoin2
cut -f4,10 -d'^' FOOD_DES.txt > /tmp/dbjoin3
paste -d"^" /tmp/dbjoin1 /tmp/dbjoin2 /tmp/dbjoin3 > /tmp/dbjoin
preprocess/dbjoinfoodedits
cut -f9,12,13,14 -d'^' FOOD_DES.txt | paste -d"^" /tmp/dbjoin - | sed -f preprocess/foodedits > /tmp/dbjoin1
mv /tmp/dbjoin1 /tmp/dbjoin

cut -f1 -d'^' NUTR_DEF.txt |
{
while read nut junk
do
grep "$nut" NUT_DATA.txt | cut -f1,3 -d'^' > /tmp/dbjoin${nut}
join -v 1 -j 1 -t'^' /tmp/dbjoin /tmp/dbjoin${nut} | sed -e "s/.*/&^-0/" > /tmp/dbjoinnomatch &
join      -j 1 -t'^' /tmp/dbjoin /tmp/dbjoin${nut} > /tmp/dbjoinmatch &
wait
rm /tmp/dbjoin${nut}
cat /tmp/dbjoinnomatch /tmp/dbjoinmatch |  sort > /tmp/dbjoin
done
}

cat /tmp/dbjoin | tr -d "~" > /tmp/dbjoin1
mv /tmp/dbjoin1 /tmp/dbjoin
rm /tmp/dbjoin*match > /dev/null 2>&1