remove duplicates (paternel; paternel {m.}; ancestral => paternel {m.}; ancestral)

[julia81]

Hi,

i have dictionary data which contains duplicates. The seperators are "," or ";" and numbers with dot like "1. ", " 2. "...
Here is an example of how my data looks like:

Column D.
famille paternelle; famille paternelle {f.}
paternel; paternel {m.}; ancestral
début, commencement {m.}, commencement
primaire {adj. et n.}; primaire {m.}; initial; élémentaire; primaire
inquiet; perplexe; soucieux; inquiet {adj. et n.}

Now sometimes there is the same word two or more times there. I need to delete those duplicates which are not followed by "{...}". I would like to copy the whole content of Column D to F and then let the duplicates remove by a macro in F. The result should then look like as follows:

Column F
famille paternelle {f.}
paternel {m.}; ancestral
début, commencement {m.}
primaire {adj. et n.}; primaire {m.}; initial; élémentaire
perplexe; soucieux; inquiet {adj. et n.}


I will be very thankful for each kind of help.

P.S. I am attaching an example file with few rows but the original one contains over 40000 rows.

[JieJenn]

For row 4 début, commencement {m.}, commencement, won't that be semicolon instead of comma? If the answer yes, it can probably be done via VBA.

[julia81]

Hi JieJenn,
the seperator is sometimes "," and sometimes ";". Semicolon is used for those meanings which really differ from each other and comma is used for synonyms of the same meaning.

[JieJenn]

Can't figure a solution. I hope someone else can come up with something. I would like to see how to solve the problem as well.

[julia81]

Can anyone help?

[julia81]

I can live with it even if I could get code which works with one seperator!

[nilem]

Hi Julia. Try this option. This works if there are no symbols "1.", "2." ... in the original string.
Can you show more options of writing the text with numbers?

Please Login or Register  to view this content.

[julia81]

Hi nilem,

thank you very much. It worked for me very well.
To solve the problem with number, I replaced "1." to "1.;" and " 2." to "; 2.;".... Then i ran your code and after the duplicates were deleted, I reversed the replacement of numbers.
Thanks alot. It was a great help.