[Archivesspace_Users_Group] CSV question

Rider, Jacqueline jacqueline.rider at ptsem.edu
Thu Oct 13 14:29:45 EDT 2016


When importing a CSV file of accession records, if a given value itself
contains a comma (as is especially common for descriptive text fields),
how should the internal comma be escaped? One common way to do this is to
use a backslash immediately before the comma, for example:

accession_acquisition_type,accession_title,accession_use_restrictions, ...
Gift,Horace T. Allen\, Jr. Collection,FALSE, ...


Another common method is to wrap the value in quotation marks, for example:

accession_acquisition_type,accession_title,accession_use_restrictions, ...
Gift,"Horace T. Allen, Jr. Collection",FALSE, ...


Which of these (or some other technique) does the accession CSV importer
allow?

Thanks,
Jackie Rider

Jacqueline Rider
Digital Archivist
Princeton Theological Seminary
Library
PO Box 821
Princeton NJ 08542
609-497-7862
jacqueline.rider at ptsem.edu


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20161013/9a4daf97/attachment.html>


More information about the Archivesspace_Users_Group mailing list