Bash Merge 2 files conditionally

Question

I'm trying to merge the second field of the csv with all the id's in the diff file. codes.csv has 2 fields: ID,Description. I keep getting an error on the second cat.

cat: codes.cvs: No such file or directory.

The file does exist and I'm running the script from the same directory as codes.csv.

for i in `cat diff.txt`;
do
 for j in `cat codes.cvs`;
 do
  id = `sed  "$j"`;
  desc = `sed "?=$j"`;
  if [$i == $id]
  then
    echo "$id $desc"
  fi
 done;
done;

Any ideas what I am doing wrong here?

Good luck with this... Better use a real programming language and a CSV parser — Gilles Quénot, Feb 26 '13 at 16:37

score 1 · Accepted Answer · edited Feb 26 '13 at 16:52

1

Looks like a simple typo. codes.cvs should be codes.csv as you indicated the name was everywhere else.

for i in `cat diff.txt`;
do
 for j in `cat codes.csv`;
 do
  id=`sed  "$j"`;
  desc=`sed "?=$j"`;
  if [ $i == $id ]
  then
    echo "$id $desc"
  fi
 done;
done;

edited Feb 26 '13 at 16:52

user000001

32,226
12
81
108

answered Feb 26 '13 at 16:43

Buggabill

13,726
4
42
47

1

Don't you need spaces after the `test` command? i.e. the `[`. And there should be no spaces before and after the `=` – user000001 Feb 26 '13 at 16:45
I do believe so... Updated. – Buggabill Feb 26 '13 at 16:48
The "=" is equivalent to "==". See http://tldp.org/LDP/abs/html/comparison-ops.html – Buggabill Feb 26 '13 at 16:51

Bash Merge 2 files conditionally

1 Answers1