On May 14, 2004, at 1:06 PM, Scott Cadillac wrote:
Hi Roland,
Try using the CDELIM and RDELIM attributes on the @ARRAY Meta Tag, not the
@ASSIGN Meta Tag.
Hope this helps. Cheers...
________________________________
From: Roland Dumas [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 1:46 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: best practice for uploading from file to
db
Perhaps my problem is not being able to make the delimiters change
from the defaults. No matter what I set the delimiters to be (I'm trying a
pipe delimiter here), the array attributes don't override the defaults.
<@ASSIGN request$newarray value="<@ARRAY
value='@@request$fromFile'>" CDELIM=| RDELIM=;>
On May 14, 2004, at 11:26 AM, Roland Dumas wrote:
System A exports a file that has many records, 10K to 15K.
Records have fields that are text and fields that are numeric.
That file will be read by witango and turned into records to
add to a database.
I can have the exported file in any text format. (CSV,
different delimiters, quoted values, whatever)
I did a couple of quick attempts to read the file, turn it
into an array, and ran into issues. No matter what I set the delimiters to,
a comma in a field triggers errors when creating the array.
So, rather than stumble into the right approach, I thought
I'd ask the list for what the best practices are for creating uploaders like
this.
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
