Re: CSV file and the delimiter

Booth,

I don't use CSV files much, but I do send a lot of data in a string to a PC
and back via sockets.  I use a colon (yeah, I know...it's a crappy choice,
but what'ya gonna do? :-)  Sorry! Couldn't resist!)....as the delimiter.
I've yet to have text that actually needs an embedded colon in it so the
colon makes a great delimiter for parsing on both sides of the equation.


Shannon O'Donnell


----- Original Message -----
From: "Booth Martin" <Booth@xxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Saturday, April 19, 2003 9:37 PM
Subject: CSV file and the delimiter


>
> I'd be interested in some feedback on building CSV files.
>
> When one uses the comma delimiter one must deal with the possibility of
> embedded commas within the character data.   Enclosing character fields in
> matched quotes will deal with that, but what happens if you enclose all
> fields in matching quotes, even numeric fields?
>
> Will Excel accept a numeric column as numeric, even if its in quotes?
Would
> it understand that an edited numeric field  "-$1,000,000.00" is a negative
> number?
>
>
> ---------------------------------------------------------
> Booth Martin   http://www.MartinVT.com
> Booth@xxxxxxxxxxxx
> ---------------------------------------------------------
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>