Double apostrophe on imported data

I'll log this as an issue. I think the reason is that there is some older code that is escaping single quotes for SQL server (in inline SQL, singles quotes are used to indicate strings, so if they appear within a string, they need to be escaped by using two single quotes).

You could try a find replace on the language elements in SQL to fix it locally on the imported data.

Something like

UPDATE tblKartrisLanguageElements SET LE_Value = replace(LE_Value,'''''', '''')

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb

Author	Message
erdemalkan	Posted Thu 16 May 2013
Supreme Being Group: Awaiting Activation Last Active: Mon 30 Sep 2013 Posts: 0, Visits: 95 9,176	I just imported csv product list into the Kartris database. But some items with apostrophe for example julie's or mike's that appear in web site with two apostrophe, like julies''s or mike''s. Any solution please help me. This is realy annoying .Regards.
	REPLY QUOTE LIKE 377
Paul	Posted Thu 16 May 2013
große Käse Group: Administrators Last Active: Fri 15 Sep 2023 Posts: 806, Visits: 2,737 449,542	I'll log this as an issue. I think the reason is that there is some older code that is escaping single quotes for SQL server (in inline SQL, singles quotes are used to indicate strings, so if they appear within a string, they need to be escaped by using two single quotes). You could try a find replace on the language elements in SQL to fix it locally on the imported data. Something like UPDATE tblKartrisLanguageElements SET LE_Value = replace(LE_Value,'''''', '''') -- If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future. If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb Tags data tool, single quote
	REPLY QUOTE LIKE 377
erdemalkan	Posted Thu 16 May 2013
Supreme Being Group: Awaiting Activation Last Active: Mon 30 Sep 2013 Posts: 0, Visits: 95 9,176	This is worked best regards
	REPLY QUOTE LIKE 348
roblasch	Posted Wed 4 Dec 2013
Supreme Being Group: Forum Members Last Active: Mon 20 Jan 2014 Posts: 3, Visits: 27 2,015	I have had allot of trouble figuring this out, and much frustration. When I have apostrophes in the supplier column it short circuits the import. In that column, and apparently only that column, it works to escape them with another apostrophe. For some reason, that doesn't work in any other column, which it should. It seems someone took the time to correct it, but not everywhere.
	REPLY QUOTE LIKE 323

Double apostrophe on imported data

Double apostrophe on imported data

Similar Topics

Reading This Topic