How to convert a doube quoted string to single quotes for each indivdial value in python?

Question

I have a string

S= "SD,HG,FG,LM"

I would like to convert this to a single quotes for each element?

S = 'SD','HG','FG','LM'

I need this way because i get some configurations from a json which is in double quotes and I would like to format it in the required manner to pass it onto a where clause in a select query in sql

"""SELECT * FROM TABLE WHERE COLUMN_NAME IN ({X});""" .format(X = S)

Does this answer your question? [Split by comma and strip whitespace in Python](https://stackoverflow.com/questions/4071396/split-by-comma-and-strip-whitespace-in-python) — lucidbrot, Aug 17 '20 at 11:20
your question is not about quoting really. mind making proper post? — Marcin Orlowski, Aug 17 '20 at 11:20

score 0 · Answer 1 · answered Aug 17 '20 at 17:11

0

try inbuilt function split() to get desired output.

s= S.split(',')
print(s)

answered Aug 17 '20 at 17:11

Juhi Dhameliya

170
2
9

How to convert a doube quoted string to single quotes for each indivdial value in python?

1 Answers1