BBEC: Out of the box import in 2.9 does not properly handle single quotes

We have an issue where we are using out of the box import to bring in some email addresses and it is not functioning correctly when we have records where a field is wrapped in single quotes and also when there is an unclosed single quote at the beginning or end of a field. Removing the single quotes or modifying the underlying data in any way before it gets inserted to the DB is not an option.

For example
 
'Customer@company will create an exception
 
 We are currently evaluating this issue and will update this article when we have more information.

Environment

 2.9

Was this article helpful?