Error: Apostrophe characters in text causing an error

Occurs: When importing text that contain an apostrophe into QuickBooks results in an error message that the name is not found.

Apostrophe Character type
Character code
Vertical apostropheU+0027O'Briens
Right Single Quotation MarkU+2019O'BriensYes
Left Single Quotation MarkU+2018O`BriensYes

Cause: The apostrophe character (vertical apostrophe or U+0027) used is not supported when importing into QuickBooks as the character is not recognized in the character set that the QuickBooks API uses.

Resolution:  Convert the vertical apostrophe to the more commonly used Right or Left single quotation mark that is more widely supported.  Use a search a replace function to replace the character.

More references: