Re: O$ 10.1: Single quote (inverted coma) converts to ’ when importing a comma delimited file into a list

[Asif Jabbar]

Thank you so much Doug - that’s exactly what I was looking for - will give it a shot.

Kind Regards - 

> On Mar 22, 2022, at 9:12 PM, Asif Jabbar <asifj at sanmar.com> wrote:
> 
> EXTERNAL EMAIL: Do not click any links or open any attachments unless you trust the sender and know the content is safe.
> 
> Hi Doug,
> 
> Correct it is a UTF-8 character single quote.  So if I read you suggestions correctly: do it pre or post import - there’s nothing in the Import command itself which can keep the UTF-8 char and not convert it to ’ (because that’s where the conversion is happening?
> 
> Thank you - 
> 
>> On Mar 22, 2022, at 12:58 AM, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>> wrote:
>> 
>> EXTERNAL EMAIL: Do not click any links or open any attachments unless you trust the sender and know the content is safe.
>> 
>> hi Asif.
>> 
>> It likely isn’t a single quote.    
>> 
>> It is more likely to be a single curly quote (or some other such UTF8 character), which means you many need to either pre-process the file and remove/replace those.
>> 
>> or do it as part of your import process.
>> 
>> 
>> 
>> 
>> 
>> Doug Easterbrook
>> Arts Management Systems Ltd.
>> mailto:doug at artsman.com <mailto:doug at artsman.com> <mailto:doug at artsman.com <mailto:doug at artsman.com>>
>> http://www.artsman.com <http://www.artsman.com/> <http://www.artsman.com/ <http://www.artsman.com/>>
>> Phone (403) 650-1978
>> 
>>> On March 21, 2022, at 10:48 AM, Asif Jabbar <asifj at sanmar.com <mailto:asifj at sanmar.com><mailto:asifj at sanmar.com <mailto:asifj at sanmar.com>>> wrote:
>>> 
>>> Hi List,
>>> 
>>> Did lots of research (Omnis and general) but didn’t see a way to prevent a single quote converting to  ’ when importing a comma delimited file into a list.
>>> 
>>> Is there a way to enforce the non-conversion when using Import from File command?
>>> 
>>> Thanks as always for any help,
>>> 
>>> Asif Jabbar
>>> _____________________________________________________________
>>> Manage your list subscriptions at https://lists.omnis-dev.com
>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at https://lists.omnis-dev.com <https://lists.omnis-dev.com/> <https://lists.omnis-dev.com/ <https://lists.omnis-dev.com/>>
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com> <mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com <https://lists.omnis-dev.com/>
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>