MobileRead Forums - View Single Post - Custom Column with the length of the lengthiest author, How to?

Tatjana · 03-22-2018, 06:55 AM

My dear Calibre specialists, this is what I have done:

I have set a custom column Author Length (#AL).
this column populate with a numeric value, corresponding to the length of
fields Authors.

#AL as I have it is not very useful.

Is there a way to make #AL show not the length of the field Authors, but instead, the length of the lengthiest author of field Authors?

Example:
Authors = A. Star & Jessica Nicholls & Dariel Raye & Mia Darien & Abigail Owen & B. R. Kingsolver
#AL = 87
What I want to have:
#AL = 16 (Jessica Nicholls and B. R. Kingsolver are both 16 characters long,
while A. Star is 7, Dariel Raye is 11, Mia Darien is 10 and Abigail Owen is 12

Why do I want this?
So that a book with Authors "A. Star Jessica Nicholls Dariel Raye Mia Darien Abigail Owen B. R. Kingsolver" will show #AL = 77 and by that high value I can easily correct the Authors field.

Thank you very much in advance for your time and your help.

03-22-2018, 06:55 AM	#1
Tatjana Coffee Girl Posts: 16 Karma: 10 Join Date: May 2014 Device: no money for such things	Custom Column with the length of the lengthiest author, How to? My dear Calibre specialists, this is what I have done: I have set a custom column Author Length (#AL). this column populate with a numeric value, corresponding to the length of fields Authors. #AL as I have it is not very useful. Is there a way to make #AL show not the length of the field Authors, but instead, the length of the lengthiest author of field Authors? Example: Authors = A. Star & Jessica Nicholls & Dariel Raye & Mia Darien & Abigail Owen & B. R. Kingsolver #AL = 87 What I want to have: #AL = 16 (Jessica Nicholls and B. R. Kingsolver are both 16 characters long, while A. Star is 7, Dariel Raye is 11, Mia Darien is 10 and Abigail Owen is 12 Why do I want this? So that a book with Authors "A. Star Jessica Nicholls Dariel Raye Mia Darien Abigail Owen B. R. Kingsolver" will show #AL = 77 and by that high value I can easily correct the Authors field. Thank you very much in advance for your time and your help.