TMG-L Archives

From: "Jeff Clenard" <>
Subject: Re: [TMG] Master Place List
Date: Thu, 1 Nov 2001 10:06:40 -0800
References: <4.2.2.20011101105521.01807af0@pop3.norton.antivirus>

Cheri Casper wrote:
> >I know that this has been answered on this list before, but I can't find
> >the answer handily (have also checked the manual and Help).
> >
> >I merged two data sets and now have duplicate places in the MPL (really,
> >truly duplicates; not minor variations). I have done a reindex and
> >repair, and several external repairs. Closed and opened the dataset and
> >still have duplicates.

Lee Hoffman wrote:
> If the two entries are _exactly_ the same (no leading or trailing spaces,
> and both have exactly the same cases) in all fields (cells), then
> File=>Maintenance=>Optimize should eliminate the duplication.

If the duplication remains after selecting File=>Maintenance=>Optimize then
there probably ARE leading or trailing spaces. Select Tools=>Advanced
Utilities=>Strip Trailing Spaces to eliminate them. Then re-select
File=>Maintenance=>Optimize.

Jeff Clenard

This thread:

• Re: [TMG] Master Place List by bob gillis <>
  • Re: [TMG] Master Place List by Lee Hoffman <>

    • Re: [TMG] Master Place List by "Jeff Clenard" <>