I would use VFP to edit your csv table in orde to avoid Excel messing up your character fields into numberic Regards Koen
Op maandag 29 februari 2016 heeft Ted Roche <[email protected]> het volgende geschreven: > On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer <[email protected] > <javascript:;>> wrote: > > > > I make some changes to the price (using Excel) > > I now import from this same file and the supcode has changed to 12345.56 > > > > Whats the best way to overcome this? > > If you're exporting a field that looks like a number, Excel will > helpfully try to convert the column into a number. If you want it to > remain as a text field, precede the fields with a single quote: > > select [']+code, price, [']+supcode from mytable to tempcursor > copy to tesfile.csv type csv > > Alternatively, there may be some option in the Excel import dialog to > turn off "Smart Parsing" or whatever Excel calls it. (LibreOffice > user, sorry.) > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACUu1St6+xtLU6u8Ft5d=cep4p7t9eqtn6o9um02moqbsrw...@mail.gmail.com ** 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.
