Hi Laurence, You could reproduce the number (using Mapbasic) with the Format$() function. In your case it would be Format$(bignumber,""). Note that the result will be a string and not a number.
Marco Kok CityDisc -----Original Message----- From: Laurence Seeff [mailto:[EMAIL PROTECTED]] Sent: donderdag 19 december 2002 10:02 To: MI-List Subject: MI-L Number format change Dear Listers, I have an ASCII delimited text file which I open in MI. The first column contains a long string of numbers representing an unique id code and is 14 characters long. The code is displayed in scientific notation for example: 9122130159597 becomes 9.12213e+012. I save the table as a native MI table and use it for various purposes. The number in it's entirety i.e. 9122130159597 is available for selections, in other words, a "select * where col1=9122130159597" does produce correct results. The problem arises when exporting the table back into an ASCII delimited text file . I need to reproduce the original number i.e. 9122130159597. Does anyone know where the number is hidden or how to reproduce it? Thanks, Laurence Seeff Points Business Mapping Ltd. 22 Tuval St., Ramat Gan, 52522, Israel Tel: +972-3-6126216 Fax: +972-3-6126323 Email: [EMAIL PROTECTED] Web: www.points.co.il --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4626
