Check for unique rows, but ignore one particular column
- by user269148
I have an XML document, that looks like this:
Column A to S with headers, and there are 1922 rows.
This is an backup of some SMS, and I want to get rid of duplicates.
The problem is, that the Time in the readable_date header has been messed up.
There is nothing wrong with the date, but the clock time is wrong, so I have split that column in…