Concatenating strings containing many quotations results in slashes in output

Vote count:

0

I am trying to build a string that needs to contain specific double and single quotation characters for executing a SQL expression.

I need my output to be formatted to something like this:

" "Full_Stree" = 'ALLENDALE RD' "

where the value of ALLENDALE RD will be a variable defined through a For Loop. In the following code sample, the variable tOS is what I am trying to pass into the query variable.

tOS = "ALLENDALE RD"
query = '" "Full_Stree" = ' + "'" + tOS + "' " + '"'

and when I print the value of query variable I get this output:

'" "Full_Stree" = \'ALLENDALE RD\' "'

The slashes are causing my query to fail. I also tried using a modulus operator to pass the value of the tOS variable, but get the same results:

where = '" "Full_Stree" = \'%s\' "' % (tOS)
print where
'" "Full_Stree" = \'ALLENDALE RD\' "'

How can I get my string concatenated into the correct format, leaving the slashes out of the expression?

asked 19 secs ago

csterling

163

Concatenating strings containing many quotations results in slashes in output