If the field value contains the character used as a delimiter (‘ or ‘), then you must type the character twice in succession to make the system treat it as a literal value. For example, you must type ‘Sammy's Store' as ‘Sammy''s Store' for it to be parsed correctly. The extra delimiter character will not be included in the stored value.