Oups!
I made a mistake! I should have written "e.g. Integer type instead of
Character"
Fran�ois Robitaille
D�partement de g�ographie, UQAM
T�l.(514) 987-3000 p. 4170
Fax: (514) 987-6784
mailto:[EMAIL PROTECTED]
-----Message d'origine-----
De : Francois Robitaille [mailto:[EMAIL PROTECTED]]
Envoy� : 10 mars, 2000 13:02
� : Swayze, Natalie: #PNWT - PTNO
Cc : MapInfo-L
Objet : RE: MI Formating columns
Hi Nathalie,
You must certainly have a table with a Character type column (for the 9
digits) and the other one with an integer type (or any numeric type)
You can perform a Table -> Table Maintenance -> Table Structure operation
where you should change the type of your column (e.g. Character type instead
of Integer or whatever it is)
Before you do that, you'd better back up your table (just in case!)
Good luck!
Fran�ois Robitaille
D�partement de g�ographie, UQAM
T�l.(514) 987-3000 p. 4170
Fax: (514) 987-6784
mailto:[EMAIL PROTECTED]
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de Swayze, Natalie:
#PNWT - PTNO
Envoy� : 10 mars, 2000 11:21
� : [EMAIL PROTECTED]
Objet : MI Formating columns
I'm trying to link 2 tables with a common column "PIN#". The problem is, in
one table, the column has a default of 9 digits( Char) with 2-3 zeros
inserted in front of the actual number. In the other table, only the number
itself is displayed with 6-7 digits( i.e. without the zeros).
Is there a way to either delete the zeros from the 1st table or make the
second table 9 digits in length with the zeros added.? Can this be done
directly in MI or a text editor or spreadsheet?
( I have the files in .tab, .dbf, and .txt formats...)
Any input much appreciated!
Natalie Swayze
Spectrum/ROS/IC/GC/CA
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
