Replace Escaped Apostrophe in SQL File with Python

Question

I am cleaning up a SQL script to replace escaped apostrophes \' with '' as it is in MySQL syntax and I need it to work in MSSQL but no matter what I try it doesn't work. How do you replace escaped apostrophes with two apostrophes in a file with Python?

user3882865 · Accepted Answer · 2022-04-06 23:45:12Z

1

It turns out replace("\'", "''") works. I'm sure I tried this but it must have been something else that stopped it from working initially.

answered Apr 6, 2022 at 23:45

user3882865

1739 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Khush Kaushik · Accepted Answer · 2022-04-05 08:20:33Z

0

Create a store procedure the write the script to replace the special characters or regular expression like

`update table set column = REPLACE(column,"'",'"'); update table set column = REPLACE(column,"/","");

update table set column = REPLACE(column,"'",""");`

Reference : Remove special characters from a database field

And in the last call it by using Python script

EXEC PROC procedureName

answered Apr 5, 2022 at 8:20

Khush Kaushik

12 bronze badges

1 Comment

user3882865 Over a year ago

Thanks, but it's the actual SQL insert statement itself that needs the escaped apostrophe replaced with '', so I can actually run it to begin with.

Collectives™ on Stack Overflow

Replace Escaped Apostrophe in SQL File with Python

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related