At 10:16 29/06/2020 -0700, Dave Stevens wrote:
There's a bug in the storage layout of some data I'm getting from an
archive that results in duplicate rows in Calc 6.4, adjacent in all
the cases I've seen. Is there a simple way to remove duplicates in this case?
Try this:
o Select all the
Is the data a CSV or text file.
Could you pre-process it, i.e.
with awk '!seen[$0]++' file.txt (from
https://stackoverflow.com/questions/106/how-to-delete-duplicate-lines-in-a-file-without-sorting-it-in-unix)
or awk '!_[$0]++' file (from
That suggestion looks great, it seems to only manage 8 columns
(conditions), I will have to remember for smaller sheets.
The process at present I use on my data is to sort it in order so
duplicates always appear together. If you need the data back in original
order and don't have a column with a
Here's one suggestion that I found:
https://ask.libreoffice.org/en/question/53569/delete-duplicates-in-calc/
Otherwise I guess you have to write a macro.
Kind regards
Johnny Rosenberg
Den mån 29 juni 2020 kl 19:20 skrev Dave Stevens :
> There's a bug in the storage layout of some data I'm
There's a bug in the storage layout of some data I'm getting from an
archive that results in duplicate rows in Calc 6.4, adjacent in all the
cases I've seen. Is there a simple way to remove duplicates in this
case? Not all rows are duplicates but as high as 40%.
Dave
--
Affectionate tactile