Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

quotation mark use

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users quotation mark use
# 1  
Old 07-12-2011
quotation mark use
Hi colleagues,

I am development a script.

this flat file pp.txt contain this tree lines.

Code:
prueba
prueba1
prueba2

Code:
cat pp.txt |awk '{print a}' |while read a
do
  var=`db2 select count(*) from $a`"
  echo $var
done

executing var show me error.

I need var contain: db2 "select count(*) from prueba;"

any help is very appreciate.

Thank you for advanced.
Last edited by pludi; 07-12-2011 at 05:51 PM..
# 2  
Old 07-12-2011
Code:
while read a
do
  var=$(db2 "select count(*) from $a")
  echo "$var"
done < pp.txt

Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add double quotation to Output

tail -n +7 1.txt |head -n -2|awk '{print "sql", $1,"-c groom table " $5 ,"versions"}' sql DB1 -c groom table T1 versions sql DB2 -c groom table T2 versions sql DB3 -c groom table T3 versions but i want out should be sql DB1 -c "groom table T1 versions" sql DB2 -c "groom table T2... (3 Replies)
Discussion started by: rocking77
3 Replies

2. Shell Programming and Scripting

Question regarding quotation syntax

Hey guys, my first post on UNIX Forums(much overdue IMO)! I've got this bit of code that doesn't seem to be working correctly for an Android app I'm working on: "screen -S gmod1 -p 0 -X stuff " & "" & command.text & "`echo -ne '\015'`""" Basically it types command.text(variable determined... (4 Replies)
Discussion started by: stingwraith
4 Replies

3. Shell Programming and Scripting

carriage returns within quotation marks causing new lines in csv

I have a csv file with 3 columns. Fields are comma delimited and strings are enclosed with quotation marks "". About 40% of the time, the line of values will start a new line thanks to carriage return characters within a string. Example: "apple","banana","orange" "pineapple","grape","straw... (6 Replies)
Discussion started by: koeji
6 Replies

4. Shell Programming and Scripting

Shell Script help for Quotation Delimited File

I need help extracting a column in a file separated by quotations. I would like to extract the first column of data and write it to a flat text file. EXAMPLE of data: "c6e181396a1100ba19c53a6757a845c4","2012-05-18","email" "70879000563753bb9051b4ab8df43ac4","2012-05-18","email"... (5 Replies)
Discussion started by: nickytcom
5 Replies

5. UNIX for Dummies Questions & Answers

PHP parsing quotation

Delete the post. (0 Replies)
Discussion started by: yifangt
0 Replies

6. Shell Programming and Scripting

Count number of character occurence but not from quotation marks

I have the following string: 31-01-2012, 09:42:37;OK;94727132638;"Mozilla/5.0 (Linux; U; Android 2.2.1)";3G;WAP;I need a script which is counting the occurrence of semicolons ( ; ) but exclude the ones from the quotation marks. In the string given as example there are 8 semicolons but the script... (3 Replies)
Discussion started by: calinlicj
3 Replies

7. UNIX for Dummies Questions & Answers

Tricky Quotation Question

Hi, I am at a point in my script where I defined the number of the command line parameter I would like to set a variable equal to: parameter_number=14 I would then like to set a variable equal to the correct parameter: variable=$parameter_number The issue here is that {} is required... (2 Replies)
Discussion started by: msb65
2 Replies

8. Shell Programming and Scripting

enclose a line with quotation marks

i have a file like this aaaa bbbb cccc aaa aaaa aa cccccccccccccccc aaaaaaa aaaa aaaa i want to enclose this lines with double quotation: "aaaa bbbb cccc" "aaa aaaa" "aa cccccccccccccccc" "aaaaaaa aaaa aaaa" any idea? (preferably without using sed) thanks in advance... (3 Replies)
Discussion started by: gfhgfnhhn
3 Replies
Login or Register to Ask a Question