View Single Post
Old 03-25-2020, 08:19 PM   #10
sasilk
Connoisseur
sasilk began at the beginning.
 
sasilk's Avatar
 
Posts: 72
Karma: 14
Join Date: Jun 2008
Location: Australia
Device: iPad Air 2; Kindle Paperwhite
I've worked out a way of doing it using template input mode. Working out that it was treating each value separately was the bit I needed.

If I use {authors} as the input, search for everything up to the first '&' and replace that with NULL, then write the remaining string into destination field authors it work perfectly. (Only because the incorrect value is always the first one.)
sasilk is offline   Reply With Quote