Do you guys think it's realistic to load a csv data file in witango following the standards to the letter?
If so i think it would be a great custom tag for someone to make, i'm just wondering if it'd be possible to make it quick enough to load larger files too or if there would just be too much parsing and logic on a fine grained detail.
I was thinking something like:
Step 1: Break apart data (based on comma's and end of lines? how would you get around the "hello, world" situation?)
Step 2: Remove the double quotes from around text values where appropriate (would you have to loop through all the data? seems like thatd take quite a bit of processing)
One way to maybe get around the "hello, world" situation even though it would also take alot of processing would be to check if a column started with a double quote, and if so, you'd know to combine that column + "," + next column until you reach a column that ends in a double quote.
Anyone have any thoughts?
Maybe if we ask nicely we can get a hard coded CSV tag in a future release too (:
Normally when i have to load csv data, i load it directly into a database table w/ a database script but i bet there's need enough for a witango csv parsing tag.
On 9/21/06, Robert Garcia <[EMAIL PROTECTED]> wrote:
The csv standard, is to DQ text values, and NOT quote numeric.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Sep 21, 2006, at 9:11 AM, Roland Dumas wrote:
> this is the approach I most often use. Then make sure the app that
> exports quotes absolutely everything.
>
> On Sep 21, 2006, at 8:58 AM, Stefan Gonick wrote:
>
>> Instead of using cdelim=',' you can use cdelim='<@dq>,<@dq>'. Most
>> csv files have double quotes
>> around each value just to deal with the comma issue:
>>
>> "value 1","value 2","value 3","value , 4"
>>
>> Stefan
>>
>
> ______________________________________________________________________
> __
> 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
