SOS!! I can't figure this out!!!

I have a FMPro7 table (lets call it main table) that has a phone field
(among others)

I'm checking it against another table (also with a phone field..don't
know if this makes a difference but this second table (in a seperate
file, has the phone numbers imported from a csv file) established a
relationship (=) and am using the following calculation in the main
table phone field:

If ( Phone = other table:ther phone field; 0 ; 1 )

Problem is I can't get a match.

I get the no match result even though I can see the exact same numbers
in both tables!!

If I manual reenter the exact same phone number in the phone field
(main table), then the match works

I've been aggravating over this for about 4 hours now and I can't see
to get it.

Anybody have any ideas what I'm doing wrong?

Thanks you so very much for any help!!!!

Use the length function to see if the # of characters is the same for
both.... it could be a space or carriage return embedded in the field that
is causing the problem.


--
Lawrance Database Designs
A J Lawrance
British Columbia, Canada
URL: http://www.members.shaw.ca/ajlawrance/index.html

"Renfer" <realso (AT) hotmail (DOT) com> wrote

Renfer <realso (AT) hotmail (DOT) com> wrote:

Check your field types. Match text to text, not number.

Replace all the numbers that were imported with themselves, but trim off
extra spaces or returns, or quotes, which can sometimes be brought in
from .csv files.

See this very elegant and useful Trim4 custom function at:

http://www.briandunning.com/filemake...ail.php?fn_id=
166

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting

Thank you Lynn and AL.

Due to your insight, I stumbled upon this solution which works great:

Put an auto enter calculation with this calculated value:

Let(Phone = Filter(Phone;"0123456789");"(" & Left(Phone;3) &
")" & Middle(Phone;4;3) & "-" & Middle(Phone;7;4))

Works perfect on both tables.

Thank you guys so much for setting me on the right track

Hope this solution helps somebody.

Alfred



On Mon, 25 Jul 2005 13:06:23 -0700, lynn (AT) NOT-semiotics (DOT) com (Lynn
allen) wrote: