Re: DTW_POS

[<Matt.Haas@xxxxxxxxxxx>]

In a CSV file, anything that is wrapped in quotes is considered a single
field. For example, if you put Haas, Matt in a CSV file, it will be
parsed as two different fields. If you put "Haas, Matt" in there, it
will be parsed as a single field. Since it's pretty common to have
commas in text fields (especially name and address fields), I just
automatically wrap anything that isn't a number in double quotes.

One other problem you may run into with CSV files is Excel. If you have
text fields that look like a number (say for example, an ISBN), Excel
will drop leading zeros even though it's enclosed in double quotes.
There is a work around for that but I don't recall what it is.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Peter Vidal
Sent: Friday, January 20, 2006 12:35 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] DTW_POS

Thanks Matt!

"If you wrap the text in quotes, you don't have to worry about commas."

Can you explain this, please?


Peter Vidal 
PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com

"To live a creative life, we must lose our fear of being wrong."
Joseph Chilton Pearce