How to remove semi-duplicated text

**variatsioon** · 11-05-2010, 01:10 AM

Hello!

I got txt document with info like that:

<NOTE PlayerId="mes5107" ColourIx="2" Text="asdasdasd" />
<NOTE PlayerId="Dreaming 4uvak" ColourIx="5" Text="possibleDUB" />
<NOTE PlayerId="monezza12" ColourIx="12" Text="" />
<NOTE PlayerId="Dreaming 4uvak" ColourIx="4" Text="random text" />
...

I would like to remove second line because that name(palyerID) is used multiple times.

and the first one(second from that example list) from this list because it has Text="possibleDUB".

How can I do this?

Im very grateful for any answer.

**TMS** · 11-05-2010, 02:46 AM

You could use text to columns delimited by the "=" sign.

You could then use an Advanced Filter to copy unique entries to a new location.

Please post a sample workbook if you want a more detailed response.

Regards