Shell Scripting

Shell Scripting RSS

OMG... simple question driving me nuts

•

Join Date: Nov 2009

Posts: 5

Reputation: Hilliard is an unknown quantity at this point

Solved Threads: 0

Hilliard

Offline

Newbie Poster

OMG... simple question driving me nuts

18 Days Ago

Hey guys,

Just trying to do a simple shell script to generate a query line... can someone tell me why this does not work?

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
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\'\)\;; done;
 
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\'\)\;; done;

if you take out the $ before each of the e's, I get exactly what I am looking for... except of course there is an e where I want the variable to be.

•

Join Date: Jun 2009

Posts: 6

Reputation: versatileint is an unknown quantity at this point

Solved Threads: 1

versatileint versatileint is offline

Offline

Newbie Poster

18 Days Ago

what you are looking for is not clear.

can you please post a sample output of what you require

•

Join Date: Feb 2009

Posts: 3,187

Reputation: sknake has much to be proud of

Solved Threads: 571

sknake

Offline

.NET Enthusiast

17 Days Ago

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\'\)\;; done;
INSERT INTO `omstest_omstest`.`GEN2_FIELD` VALUES (NULL, 'ABC', 'ABC', '4', '2009-10-05 00:00:00', '0' '0');
 
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\'\)\;; done;
INSERT INTO `omstest_omstest`.`GEN2_FIELD` VALUES (NULL, 'ABC', 'ABC', '4', '2009-10-05 00:00:00', '0' '0');

Some shells do not like to evaluate $vars unless they are in a " , not a single ' .

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Nov 2009

Posts: 5

Reputation: Hilliard is an unknown quantity at this point

Solved Threads: 0

Hilliard

Offline

Newbie Poster

14 Days Ago

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?