TMG-L Archives

Archiver > TMG > 2004-03 > 1078534691


From: "John Cardinal" <>
Subject: RE: [TMG] Two word last names
Date: Fri, 5 Mar 2004 19:58:24 -0500
In-Reply-To: <006e01c40313$5e463d60$230110ac@TANARI>


tanari wrote:
> I am not sure why the two instances of Van showed up as the original.
> I could have sworn looking at the file that it wasn't that way. But
> everytime I think not, it is so must have been in this case also. I
> did not check each of these people however, just noticed it starting
> with Abraham. Yes I do know why! I ran the utility twice without
> realizing it. The first log below is the first time I did it, I
> included the second log below. Didn't realize it until I went to find
> the log and there were two copies there with different names. If
> there is a way to make a mess, I sure seem to find it. And yeah I
> forgot to do the log only function either time so the database has
> been changed. That's not a biggie, I can just reimport the original
> from FTM again and start over but just would like to figure out the
> two last names issues so I can hopefully! do it right the next time.

Tiffany,

There is a mistake in the rules I gave you. With the mistake, running it
multiple times would add "Van"s. I said

If GivenName ends with " van"
Change GivenName delete prefix " van"
******
And Change Surname prepend "Van "
And Change SortGiven copy GivenName
And Change SortSurname copy Surname

BUT the underlined "prefix" should have been "suffix":

Change GivenName delete suffix " van"

Sorry!

As you said, you can reimport to correct the problem. If you don't want to do
that for some reason, let me know and I can write a rule to fix the current
names.

John

This thread: