At 02:01 PM 06/16/1999 -0400, you wrote:
>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.
Sure, Try using "Update Column" into a new column, and use the InStr()
function as follows (you will need to use your own column name, of course).
mid$(old_column,InStr(1,old_column,"(")+1,InStr(1,old_column,")")-InStr(1,ol
d_column,"("))
Steve Wallace
GIS & Market Information Manager
Florida Farm Bureau Insurance Companies
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
