Hi Dan
A very simple way would be to convert your table in ASCII format using a
separator different from the semi-colon (use comas or anything else)
Then you open the txt file in a text editor (like notepad), drop the header
line and perform a Find/Replace on the semi-colon string
Find: ;
Replace by: "," (Double quote and the separator you have chosen, comas in
this case)
Save your file and import it back in MapInfo using the comas separator
Hope this will help!
Fran�ois Robitaille
Conseiller en g�omatique
SiGis
514.247.8845
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de
[EMAIL PROTECTED]
Envoy� : 11 juillet, 2001 15:58
� : [EMAIL PROTECTED]
Objet : MI-L creating new fields
I have this mapinfo table in which one of the fields called "reference" has
information in a text string in which each item is separated by a semi-colon
example: john;1994/01/01;52;B12 (name;date;number;assignment)
I would like to take this "reference" field and separate it into 4 new
fields
called Name, Date, Number, Assignment., one for each "category". That way
would make it easier to query names or dates etc...
Anyone know how this can be done?
TIA
Dan
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
