MI: HELP! Reverse select, search & replace

[Robert Karr]

Greetings All:  Very short on time. Couldn't get into the Searchable Archives over the 
weekend.  I'm sure part of the answer is there.

I have a character formatted field (TESTRESULTS) in a MapInfo database that I need to 
split into alpha characters and numbers.  The alpha characters (<,>,NT) are always the 
first in the string.  Only about 40% of the approx. million records have alpha 
characters.

Don't have MapBasic.  Have Excel, which accepts only the first 32k records and ignores 
the rest without telling you.  Have available FileMakerPro, but know almost nothing 
about it.

Have a copy of KGM's Search and Replace MBX (only works on 32k records at a time 
without closing down with an "Out of Memory" msg).  I could make do with this if I had 
a reverse selection capability by making a duplicate of the TESTRESULTS field, then 
(in 32k record chunks) select for and delete all the alpha characters in one field, 
then in the other field, also select for all the alpha characters then reverse the 
selection to delete the numbers.  A lot of "brute force" typing, but it would get the 
job done.

Can some one point me to a "reverse select" MBX??

Any other better ideas??

...thanks   ...Bob









Robert Karr
[EMAIL PROTECTED]
517-373-3028
517-373-0171 FAX
Science Research Assistant
Science and Technology Division
Legislative Service Bureau
Michigan State Legislature
124 West Allegan, 4th Floor
pob 30036
Lansing, MI  48909-7536
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                !
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                                                                                       
                              
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]