Shell Programming and Scripting

I have data in a CSV file that looks like;

Code:

1353557880:1.111:123.3
1353557940:1.113:123.3
1353558000:1.118:123.3
1353558060:1.123:123.3
1353558120:1.218:123.3

I'm running the following;

Code:

while IFS=":" read d a b; do rrdtool update temp.rrd $d:$a:$b; done <temp6

It gives me the following error for each data line;

Code:

' to float not complete: tail ''123.3

If I echo the line it prints fine and if I manually type what was echoed it works fine. It appears that when running in the "while" loop it wants the data in floating point? The "$a" variable works fine and if I replace the "$b" variable with a U for undefined the script will work. I've tried several things, even just using one read variable, still doesn't work.

Anyone got any ideas?

Seems a problem of Windows-style line-terminators (CR-LF combination).
Run dos2unix on the file first.
If you don't have this utility, use tr -d '\r' < infile > new_infile.

Figured out what was causing the problem. The CSV file has some hidden characters at the end. I was able to strip them off using grep and now it works.

---------- Post updated at 02:14 AM ---------- Previous update was at 02:07 AM ----------

Didn't re-fresh my screen soon enough, you are correct elixir, it probably is the line terminators. I used the grep command;

Code:

grep -o '..........:.....:.....' infile >outfile

This strips off any extra characters but the tr command looks more straight forward.
Thanks,