Where there is a multi-valued field, such as Author or Genre, it would be nice if the field could be split into its component parts. For example “The Annotated Alice” has the Author “Martin Gardner & Lewis Carroll”. On import it would be nice if this could create two authors, viz: “Martin Gardner” and “Lewis Carroll”.
When importing CSV and using a multifield you can set a couple of multi-field “delimiters” in the import screen. It looks like this:
Ampersand, the “&”, is indeed not one of them.
You could perhaps modify your CSV to replace all ampersands in the Author or Genre field by “;” (so only modify the author and genre columns).
We could also implement ampersand as a field delimiter.
Is that what you’re looking for?
How stupid am I?
There it was, right there on the import screen, and I didn’t notice.
Thanks AJ, that is EXACTLY what I wanted
Soooo you’re all good with not using ampersand in the import then?
I will not call you stupid though hah.
AJ,
Yes, the ampersand was a red herring. That is the character placed there by some other software, and is easy enough for me to change.
What I was looking for was simply if it was possible to split multiple fields, like author or genre, which it is.
I had looked in the manual for an answer, but didn’t find it there. But if I had only looked at the instructions on the screen, then I would have found exactly what I was looking for. So I do feel somewhat stupid.
Thanks for all your help.