Thread: OMG... simple question driving me nuts

What shell are you using, and what error are you receiving? It seems to work for me: Help with Code Tags Shell Scripting Syntax ( Toggle Plain Text ) sk@svn:/tmp$ for e in ` cat file .txt`; do echo INSERT INTO \`omstest_omstest\`.\`GEN2_FIELD\` VALUES \ ( NULL, \ '$e \' , \' $e \' , \' 4 \' , \' 2009-10-05 00:00:00 \' , \' 0 \' \' 0 \' \)...

I'm using bash... No errors... but the moment I put a $var in place of the two e's, my output gets all jumbled up... and only the last line of the file prints correctly... it is almost like it is reading a new line that is not there... or at least that I am not seeing. What shell did you use? Did you try it with more than one line in the test file?

rofl... ha ha I'm a newb. The problem was with the text file not the commands. Should have been the first thing I checked Thanks everyone who tried to help.

I'm glad you got it working Please mark this thread as solve as you have found your solution to the issue and good luck!