I'm working on this system for a client - where we need to import CSV data into VFP. This particular CSV file gets generated from UPS Worldship. Upon importing the data - we noticed that the top record in my system was not getting the Tracking#. Upon stepping thru the program - I found that the 1st line of data from the CSV file was NOT being Imported at All by VFP!
Now - I know a standard CSV file has field/column labels as the 1st record of a CSV file. However, upon opening up the CSV file from UPS in Notepad - I saw that the CSV file did NOT contain those field headers! And, so - I am assuming that VFP is considering the top line of data as field headers - and therefore ignoring the record. Could I be doing something wrong? Or, is this just a Non-Standard type of CSV file - and now I have to code things differently to handle it??? If I have to - I will code a work-around. My QA Tech buddy suggested that I open the CSV file and insert the field headers. Although, what I would really do is just generate this stuff to a secondary/temporary type CSV file - as opposed to messing with the original one. But, I figured I would post a message here to see what others thought... Thanks, -K- Developer Waitex Information System, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
