Perhaps use STRTRAN() to remove all quotes then append. If I remember correctly VFP will allocate the data types based on the table structure.
John Weller 01380 723235 07976 393631 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of MB Software Solutions, LLC > Sent: 18 January 2012 22:01 > To: [email protected] > Subject: Delimited dilemma > > VFP9SP2 > > I've got to import a CSV file. Format spelled out by vendor says > char(30), numeric(12,2), date. Ok. Great. Should be easy. File has > fields delimited by double quotes. Fine, except that the numeric fields > are also delimited by quotes. This screws up my simple APPEND FROM > c:\custfile.csv TYPE CSV command. Ugh. > > My initial thought is to change the n(12,2) to varchar(12) and then > modify the field after the import, but I don't like that idea because I > want something automated, not something I have to manually adjust. > > How do I easily (in code) overcome the vendor's decision to put " around > ALL fields?!?!? > > Thanks in advance! > --Mike > _______________________________________________ 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.
