O$: is this a text file import bug?

Michael Houlberg michael at houlbergdevelopment.com
Wed Apr 8 20:13:31 EDT 2009


Yes, this is a new bug in 4.3.  Tech support tells me it is fixed the  
in 5.0 version.  I ended up having to write a routine to parse out  
double quote characters, except where they are the first and last  
character between tabs.  Yuck!

However, another solution if you don't have to do this often, open the  
file in Excel, then save again as tab delimited.  It puts extra  
delimiters around the offending columns and Omnis then can read it OK.

Michael Houlberg
Houlberg Development, LLC

On Apr 8, 2009, at 4:42 PM, Alan Schmidt wrote:

> I’m trying to import (using the Import Data command) a tab delimited  
> text
> file with numerous columns. One of the columns contains long text  
> entries
> some having a double quote character (for inch measurements, and  
> there’s no
> more than one double quote per record). When this file is imported  
> using
> Studio 4.3.1, the double quote character causes the tab delimiters  
> for all
> the following columns to be ignored and they are all crammed  
> together into a
> single field. If I remove the double quote using a text editor it  
> imports
> fine. I can also import this same file properly using Studio 4.2  
> with or
> without the double quotes. Is this a bug in Studio 4.3 or is there a  
> new
> preference setting that changes the import behavior?
> Thanks for the help.
> -Alan
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com

More information about the omnisdev-en mailing list