RE: CSV file and the delimiter

["Mike Shaw" <mhshaw@xxxxxxxxxxxxxxxx>]

Shannon,

You conveyed a very important message here.  It's whatever works best
for your situation/need.  Delimitation is purely a function of precision
required to get a task done.  If more precision is needed, then by all
means move up to CSV delimitation.  I'll opt for simplicity any day!
:-)

Regards,

Mike Shaw

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Shannon O'Donnell
Sent: Sunday, April 20, 2003 11:38 AM
To: Midrange Systems Technical Discussion
Subject: 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.
>


_______________________________________________
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.