Skip to content

Broken Import: handle strings with double quotes and strings with single-quote/comma #95

@rhodges

Description

@rhodges

single quotes are escaped with another single quote: "he'll" becomes "he''ll"

If that single quote (or apostrophe) is right before a comma, that breaks the current regex pattern:
eg_match = r'(E'".+?(?!\)"'|E'.*?(?!\)'|.+?)(?:,\s|$)'
import_sql near line 180

It also fails on strings with double quotes, which switch from:
E'I'm a string!'
to
E'I'm a "string"!'
so that it can be single quoted

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions