Alistair,
You can use the Update Column command to join two columns together. In your
case, first create an extra column through Table|Maintanence which is at least
as big as the two columns you want to join together plus one. Now use the "Update
Column" command to update the new column with an expression like street_number
+ " " + streetname.
Hope this helps.
Regards,
Sue
++++++++++++++++++++++++++++++++++++++++
adding Susan Port
value Technical Support Coordinator
to [EMAIL PROTECTED]
your
spatial Spatial Plus
systems http://www.spatialplus.com
++++++++++++++++++++++++++++++++++++++++
>Hi,
>I'm mapping out a Dengue Outbreak that finished recently in North Queensland,
Australia and am using the State Digital Road Network to geocode my records.
>My problem is this: I have the street_name and street_number in different columns
and I think I need to combine this information into 1 column.
>
>There is plenty of info on parsing data from 1 field to 2 or more, but I couldn't
find anything referring to combining fields into 1 column.
>
>Does anyone know of a way to do this in MapInfo as opposed to going back to
the data source -an .xls (excel) file?
>
>I can be e-mailed at: [EMAIL PROTECTED]
>
>Thanks In Advance, *
>Alistair Hart
>Dengue Action Response Team
>Tropical Public Health Unit
>PO Box 1103
>Cairns, QLD, Australia
>PH: 4050 3628
>Fax: 4031 1440
>
>----------------------------------------------------------------------
>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]
