A BIG PUBLIC "THANK YOU" to Chris Matthews for his efforts in providing help on Sun
4/24. People, like Chris and others, who are willing to spend a part of a Sun
afternoon to help those in need (like me) make MapInfo-L very special. With the
command codes he provided (see below) I was able to use FileMakerPro to parse a
alphanumeric field into alpha characters and numeric characters. (The original posting
is also tacked on below for those who have further interest)
Thanks also to all those who sent or suggested the InvertSelection MBX that was
recently uploaded to the List site. Unfortunately, I am using 4.5 and it only works
with 5.0 and up.
Thanks also for the other offers of help through private communications.
...Bob
>>> Chris Matthews <[EMAIL PROTECTED]> 4/25/99 5:26:00 PM >>>
Here are the improved formulas (and I gave the fields shorter names)
I am resending the zip file with the FM database...
Set up 2 "calculation fields" to separate your mixed alphanumeric records.
One with this formula to grab the alpha part of the field:
Case((Left(input, 1) = "N"), Left(input,2), (Left(input, 1) = ">"),
Left(input,1),(Left(input, 1) = "<"), Left(input,1),"")
And the other with this formula to grab the numeric value:
Case((Left(input, 1) = "N"), Right(input, (Length(input)-2)), (Left(input,
1) = ">"),Right(input,(Length(input)-1)),(Left(input, 1) =
"<"),Right(input,(Length(input)-1)),input)
At 12:15 PM 4/25/99 -0400, Robert Karr wrote:
>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]
