So sorry to ask, but my programming days were 40 years ago. Many .pdf's I import don't have the author in the correct field, instead it is in the title, for instance "Agriculture The Food We Grow and Animals We Raise (Natural Resources) by Julie Kerr Casper".
Right now I have to
go to each title,
cut text starting with "by" to the end of the title,
wait for the edited title to store,
enter the author column
paste the authors name
return to beginning of the field
delete "by "
Please, please don't tell me to study the template language - I'm happy to make an appropriate donation for a solution to the problem - see screen-clip.
Many thanks!