MobileRead Forums - View Single Post

jwahome2002 · 01-08-2023, 09:14 PM

Thank you Chaley! This has gotten me so much closer to my goal! I would never have figured out closing with 'fi'.

Here are the field names (assuming you are asking for the Lookup name vs Column Header): #universe, #saga, #book_num, authors, title

You are correct - the true statement is when universe is NOT blank. Mis-type on my end.

My library is primarily fantasy novels. Some of the sets (e.g. Forgotten Realms) are sorted by their book order, the rest I want sorted by author and saga or author and title.

Does Calibre allow one to pull out the author last name? Or at least use a string that has last name first? This field will be ultimately used as a sort.

Here are examples of what I am trying to do:

Universe sample:
Universe = Forgotten Realms
Book# = 26
Desired Result = Forgotten Realms26

Book w Saga
Universe = (blank)
Author = Terry Brooks
Saga = Saga of Shannara
Book# = 12
Title = Bearer of the Black Staff
Desired Result = Brooks, TerrySaga of Shannara12

Book w no Saga
Universe = (blank)
Author = Terry Brooks
Saga = (blank)
Book# = (blank)
Title = Daughter of Darkness
Desired Result = Brooks, TerryDaughter of Darkness

Does the syntax here follow Excel rules, where once you get past the first criteria, you no longer have to reference it? In other words, can I just perform an ELSEIF where Saga is NOT BLANK or do I still need to reference the Universe criteria?

Thank you for any assistance you can offer!

01-08-2023, 09:14 PM	#3
jwahome2002 Junior Member Posts: 5 Karma: 10 Join Date: Jan 2023 Device: Calibre	Thank you Chaley! This has gotten me so much closer to my goal! I would never have figured out closing with 'fi'. Here are the field names (assuming you are asking for the Lookup name vs Column Header): #universe, #saga, #book_num, authors, title You are correct - the true statement is when universe is NOT blank. Mis-type on my end. My library is primarily fantasy novels. Some of the sets (e.g. Forgotten Realms) are sorted by their book order, the rest I want sorted by author and saga or author and title. Does Calibre allow one to pull out the author last name? Or at least use a string that has last name first? This field will be ultimately used as a sort. Here are examples of what I am trying to do: Universe sample: Universe = Forgotten Realms Book# = 26 Desired Result = Forgotten Realms26 Book w Saga Universe = (blank) Author = Terry Brooks Saga = Saga of Shannara Book# = 12 Title = Bearer of the Black Staff Desired Result = Brooks, TerrySaga of Shannara12 Book w no Saga Universe = (blank) Author = Terry Brooks Saga = (blank) Book# = (blank) Title = Daughter of Darkness Desired Result = Brooks, TerryDaughter of Darkness Does the syntax here follow Excel rules, where once you get past the first criteria, you no longer have to reference it? In other words, can I just perform an ELSEIF where Saga is NOT BLANK or do I still need to reference the Universe criteria? Thank you for any assistance you can offer!