I think you may have to do it in steps, on a copy of your original data of
course. Mapbasic would be able to automate the process. you could try
something along the following (have not tried myself), either from the menu
or from the mapbasic window.
To get the value of pure integer strings (perhaps)
Select * from tablename where Str$(Val(Fieldname)) = FieldName
To get the characters on the right of a space:
Update tablename set fieldname = Right$(FieldName,
len(Fieldname)-Instr(1,FieldName," ")-1)
and repeat this until there are no more spaces in any of the records.
R
Robert Crossley
Whats Here
10 Trinity Street
Parramatta Park 4870
AUSTRALIA
Ph 40314877
F 40314810
M 0419 718642
E [EMAIL PROTECTED]
_______________________________________________________________________
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.
