Rune,
Possible solution...
Create 3 new columns - one 'from' one 'to' and one 'distance' (or
whatever)
Using Table>update column: update the 'from' column using the Mid$
operator. To extract the 'from' number in "1 1573 1688" you'd use
Mid$(source_col,3,4) where source_col is the column with your data in.
This extracts 4 figures starting at the third character, putting the
number 1573 in the 'from' column.
Then, similarly, update the 'to' column using Right$, e.g.
Right$(source_col,4) would extract the rightmost four figures, putting
1688 in the 'to' column.
Finally, update the 'distance' column with an expression subtracting the
to column from the from column e.g. to-from
A problem is where the placement of characters in your source column
changes e.g. where your roadnumber becomes two figures. Then the Mid$
and Right$ statements need to be changed accordingly to extract the
correct figures. If this changes a lot between records, this will get a
bit boring...may be alternatives?
Hope this helps,
Ben
--------------------------
Ben Wheeler
Data Analyst
Gloucestershire Health Authority
UK
e-mail: [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]
