Hello Anne,
While this would be technically possible, it would probably be relatively
heavy in terms of performance if we have to support that for any field (or
all).
Alternatively, I would suggest that you address this with plain formulas,
e.g., assuming A1 is the cell that you want to deduplicate, have a new
column B added with, in B1, the following formula that you can then drag
down for all your rows:
=join("||",transpose(unique(transpose(split(A1,"||")))))
(just replace A1 in there with whatever works for you).
I hope this will do the trick for you.
Best regards,
Benoît
On Monday, 29 July 2019 16:32:16 UTC+2, Anne Lawrence wrote:
>
> Bram,
>
> Thank you for these power tools and video. They look quite useful. I have
> a request for additional functionality: to identify duplicate values in a
> given field.
>
> Anne
>
> On Thursday, July 25, 2019 at 10:06:59 AM UTC-4, Bram Luyten wrote:
>>
>> Hello,
>>
>> we have released a suite of power tools that allow following
>> post-processing on CSVs exported from DSpace:
>>
>> - removal of authority keys
>> - consolidating different columns for the same metadata field
>> (language code variations)
>> - removing unselected columns
>>
>> A walkthrough video for these tools is available from
>> https://www.youtube.com/watch?v=iF3Xs1-oSoA
>>
>> The tools themselves have documentation and can be copied from
>> http://bit.ly/atmire-csv-power-tools
>>
>> Shout out to my colleagues David Cavrenne and Benoît Wéry for their help
>> with this.
>>
>> cheers,
>>
>> Bram
>>
>> [image: logo] Bram Luyten
>> *250-B Luci*us Gordon Drive, Suite 3A, West Henrietta, NY 14586
>> Gaston Geenslaan 14, 3001 Leuven, Belgium
>> atmire.com
>> <http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=braml>
>>
>
--
All messages to this mailing list should adhere to the DuraSpace Code of
Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/88abcf29-827e-4bf1-a155-a2634b4c1ca5%40googlegroups.com.
