I recognize some influence of the Beyond2020 variety, a pain in the (census)
block
if a is the name of the column containing the data, then update a new column
with
mid$(a, instr(a,"(")+1, instr(a,")")- instr(a,"(")-1)
And thank tou, I had the same problem with Excel and now I have the solution
=MID(A1,FIND("(",A1,1)+1, FIND(")",A1,1)-FIND("(",A1,1)-1)
Jacques Paris
============================================================
e-mail [EMAIL PROTECTED]
alternate [EMAIL PROTECTED]
gis activity (MapInfo mainly)
http://www.total.net/~rparis/gisproducts.htm
============================================================
> -----Original Message-----
> [mailto:[EMAIL PROTECTED]]On Behalf Of Sharon Barnes
> 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.
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
