Try this: TEXT TO m.lctext NOSHOW TEXTMERGE "Frank","1234567.89" ENDTEXT
STRTOFILE(m.lcText, "Test.txt") CREATE CURSOR c_Import; (UserName c(10),; UserFee n(10,2)) APPEND FROM test.txt TYPE DELIMITED This should bring the number in as numeric. Frank. Frank Cazabon On 18/01/2012 06:01 PM, MB Software Solutions, LLC wrote: > 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.
