Hi Folks! I have a challenge. I have worked out a solution but it takes
about 10 steps!!! I'd like to know if there is a more straight forward
query that can produce the same result.
The data is over 900 records of canadian census data at the subdivision
level. The profile data comes with a column for "geography" however, in
order to map the data you need the UID (unique identifier) for each
subdivision in a separate column so that it can be joined with the
boundary file. The following is a sample of the "geography" records that
come with the census data:
Hilton (3557004) TP 00000
Hilton Beach (3557006) VL 00000
St. Joseph (3557008) TP 00000
Laird (3557011) TP 00000
Bruce Mines (3557021) T 00000
Manitoulin, Unorganized, Centre Part (3551092) UNO 00000
Is there a way to query the table and extract only the numeric value
found between the brackets in the middle of each record and place it in
a separate column? The data type is "character" and the column width is
62 but there is zero consistency among the record lengths.
Thanks in advance for your help.
Sharon
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
