Hey Ted - thanks for Extensive and Enlightening Clarification! Very interesting insight!!!
And - John - that suggestion of your's sounds very elegant and easy to implement - and a MUCH easier solution that the one I did. However, that being said - it probably took me like 10 minutes to write the code - which I did line by line, and tested it interactively line-by-line, then implemented it in the system - a total of like and ended up being a mere 7 lines of extra code. So - in the end - no Biggy... -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ted Roche Sent: Thursday, November 11, 2010 12:47 PM On Thu, Nov 11, 2010 at 12:34 PM, John Weller <[email protected]> wrote: > I have had problems like this. The command APPEND FROM <filename> TYPE CSV > will always drop the first line as it assumes it is the header. If your > data does not have a header line then use APPEND FROM <filename> TYPE > DELIMITED. It's mostly a terminology issue. In the minds of the FoxPro Developers, and Microsoft in general, a CSV file is a special case of a DELIMITED file with a first line of field names. (Check out an Excel export, for example.) Most of the rest of the world doesn't make that distinction. The Hacker's Guide covers this pretty well, iirc, and I think Tamar wrote up a follow-up article on it. DELIMITED WITH and SEPARATED BY give you the power to read a lot of different formats, at low-level speed, and without bugs in code you have to write and debug. -- Ted Roche _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a1409df1...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
