CODEWITHSUNDEEP
python-3.xcx-oracle
Shell_Magic
Shell_Magic

Reputation: 33

How to remove quotes from a string

I am running an insert query towards an oracle DB, where I am getting an error which says column not allowed here.

the value I am entering for date is :

'ToDate('11/01/21','dd/mm/yyyy')' - > I get column error
ToDate('11/01/21','dd/mm/yyyy') -> I don't get error if I remove the quotes.

as the value is coming from a dictionary I want to know how can I remove the quotes at the end . I tried strip() its not working looks like it doesn't think that quotes are there at the end.

Upvotes: 0

Views: 60

Answers (1)

Hameez Rizwan
Hameez Rizwan

Reputation: 326

You can use the method

your_string_name.replace('"', "")

Upvotes: 1

Related Questions