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

[Das Goravani]

With Studio 10 I found that if I save the text file WITH BOM, then it imports those characters correctly in Omnis, otherwise I got the garbage. 

On the Mac, you can use BBEdit to save a test file WITH BOM… they give this option.

I do not know an editor on the PC that does this but I’m sure some do. 

It’s a lot easier to do than any coding equivalents. 



> On Mar 24, 2022, at 1:46 AM, Asif Jabbar <asifj at sanmar.com> wrote:
> 
> 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>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com