Remove duplicate entries from table of cross references
I am working in 64bit Windows 7 using InDesign CS6.
I am creating a book from multiple files and one of the files is a table of cases drawn from data in the other files. The entries for the table are created using crossreferences to page numbers. I am trying to find a way to eliminate duplicate page numbers from appearing for a single entry. I have tried search and replace and some simple regex, but since the page number output is actually a cross reference, I can't seem to find the proper way to remove duplicates.
For example:
John v Smith................3-12, 3-12, 4-5
Jones v Roberts............2-5, 6-2, 6-2, 7-1
In the example the case John v Smith shows up in two locations on page 3-12 and Jones v Roberts appears twice on page 6-2. The table might have several hundred similar duplicates, and I am looking for a way to clear the duplicates with a search and replace or simple script. Does anyone have any ideas on how to remove or hide duplicate cross references?
Thanks for any assistance.
