Re: Witango-Talk: Import CSV

[Chris Millet]

Do not mean to frustrate, just thought you might be interested in a  
possible workaround – which you would have seen if you had read a  
little further. Depending on the source of the file, you might be able  
to specify a different and less common delimiter (such as a pipe) to  
avoid the problem altogether.

Chris

If you would still rather create an array, and if you have any control  
over the output of the csv file, you might consider  
terminating/delimiting your fields with a pipe or some other uncommon  
character like it. I have done this in cases where loading data was  
just not an option and it has also served very nicely.

Your array then, would look something like this:

<@assign user$csvdata value="<@array cols=2 value='<@arg csvdata>'  
rdelim='<@crlf>' cdelim='|'>">


On Apr 15, 2004, at 1:13 AM, Wayne Irvine wrote:

I would do almost anything to
avoid it – including converting to MySQL : )
Please forgive me if I seem a little frustrated, but this really isn't
helping.
The site uses FileMaker.

The data files are CSV.

The issue is bringing CSVs (some of whose fields contain commas) into  
arrays
in Tango.

If you can help with the latter I would love your assistance.

Wayne Irvine

                  Byte Services Pty Ltd
               http://www.byteserve.com.au/
                  [EMAIL PROTECTED]
   Ph 02 9960 6099   Mob 0409 960 609   Fax 02 9960 6088
_______________________________________________________________________ 
_
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf