On May 14, 2004, at 11:39 AM, Storey, Paul wrote:
When you populate your array, load each field using <@SUBSTRING>.
-----Original Message----- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 1:35 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: best practice for uploading from file to db
yes. Then what?
On May 14, 2004, at 11:31 AM, Storey, Paul wrote:
Can you have the file exported so the fields are fixed width?
-----Original Message----- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 1:26 PM To: WiTango List Subject: Witango-Talk: best practice for uploading from file to db
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
