|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
