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 > _______________________________________________________________________ > _ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
