On 12/19/2010 6:06 PM, Sytze de Boer wrote: > Richard has pinpointed the issue > > The 2nd and subsequent lines in the csv file are all enclosed with speech > marks > Here are the 1st 3 lines when opened with Notepad > > "Vehicle,Registration,VehicleGroup,ActivityDate,ActualDistance,Units" > "127,HIAB 6,Auckland,1/10/2010,52.7,km" > "127,HIAB 6,Auckland,4/10/2010,45.6,km" > > If I issue Appe from (impfile) type CSV I get the records, but they're all > in first field of the table > If I issue Appe from (impfile) delim I get the records, but they're > all in first field of the table
Of course. With the quotes, each record is a single quoted string, and goes in the first column. Fairly simple solution is to preprocess, stripping off the quotes at front and back. It still would be worthwhile to check with Navman to see if this was a one-time aberration (in which case you don't want to do a lot of programming) or is this the way they'll come from now on. Dan Covill _______________________________________________ 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/[email protected] ** 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.
