prefixes

#11

p.s.:

You can easily write a script to "refresh" the prefix list as necessary
after data entry or imports along the lines of the following:

Add:
L (calculation, number result) = Length(Prefix)

Pseudo-Script:

Sort by L descending
Export to prefixes.tab
Delete found set
Import prefixes.tab

I'm sure it would be possible to force a match through other means, but
keeping the prefixes table organized this way eliminates the need for
complicated calculations and/or relationships.

Bill

"Bill Marriott" <wjm (AT) wjm (DOT) org> wrote

Quote:

This is because you have "van " as well as "van der " as prefixes.

I think the easiest solution is to

1) Modify the TestPrefix formula to:

If ( Length(Extend(Surname)) >= Get ( CalculationRepetitionNumber ) ;
Left ( Extend(Surname); Length(Extend(Surname))-Get (
CalculationRepetitionNumber )+1); "")

This will reverse the trimming so that your repeating field is

van der Meter
van der Mete
van der Met
van der Me
van der M
van der{space}
van der
van de
van d
van{space}
van
va
v

2) Make sure your Prefix table has all double (and triple) word prefix
variants entered (physically, not by sort) before any single-word prefixes
that are a subset of the double-word prefix. In other words, "van der "
must be appear (in Unsorted mode) before "van " in the table.

This will force the relationship to consider the double-words ahead of any
similar single-word matches.

In the case that you want to later add a double-word prefix when a similar
single-word prefix already exists, you would add the double-word version,
then delete and re-add the single-word variant.

Bill

"ursus.kirk" <secret (AT) nowhere (DOT) com> wrote in message
news:43920384$0$35283$dbd4d001 (AT) news (DOT) wanadoo.nl...
Sorry to ask again Bill,

I have found (or rather Remi-Noel has found) an other working solution.
But yours is more sleek. There is however still a bug. We have lots of
poeple with duble prefixes. So
van der Meer
is a valid name, which in my solution should result into Meer.
I have trioed adding "van der " including the space, but Ido understand
it just matches the first connection (being the 'van' bit), returning der
Meer as solution.

You don't have to wring your neck, but if there is a solution I missed I
would like to know.

Ursus

"Bill Marriott" <wjm (AT) wjm (DOT) org> schreef in bericht
news:1dmdndtkrbTiZgzenZ2dnUVZ_v-dnZ2d (AT) comcast (DOT) com...
Ursus,

The method I outlined and sample file I attached will correctly handle
the "van Meter" and "Vanmeter" situations. You simply need to specify
"van " (with a space) in the prefix table. It even works with the
apostrophe in "O'Mally." Download it and give it a try.

Bill

"ursus.kirk" <secret (AT) nowhere (DOT) com> wrote in message
news:4391c1b8$0$35257$dbd4d001 (AT) news (DOT) wanadoo.nl...
Thanks Bill

But I am not there quite yet.

You have understood correctly about the two tables.

But I want the name
van Meter
to return only Meter.
And the name
Vanmeter
To return Vanmeter

And to complicate things even further O'Mally should return Mally, but
it has no space between the prefix and the suffix. (But this is not
very important to solve)

Ursus

"Bill Marriott" <wjm (AT) wjm (DOT) org> schreef in bericht
news:FdudnQFIwNGnAg3eRVn-rQ (AT) comcast (DOT) com...
Ursus,

If I understand correctly, you have two tables:

Prefixes
========
van
der
o'
vander
mac
mc

CompleteSurnames
================
O'Mally
MacNichols
McDonald
Smith
VanDerHoff

#12

Thanks again for your effort

Ursus

"Bill Marriott" <wjm (AT) wjm (DOT) org> schreef in bericht
news:kdqdnQDBndqvkg_eRVn-qg (AT) comcast (DOT) com...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

prefixes

comp.databases.filemaker comp.databases.filemaker

Re: prefixes - 12-03-2005 , 03:33 PM

Re: prefixes - 12-05-2005 , 04:26 AM