Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 11-23-2020, 07:41 PM   #1
halloleo
Zealot
halloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
Posts: 114
Karma: 12649
Join Date: Feb 2020
Device: iPad
How to regex bulk update the Title column from another column?

In the regex bulk update dialog I found how to use one column (say, the custom column #import_filename) to set another column (the destination column).

And in the dialog's Destination dropdown I found many columns, e.g. the title sort column, but not the normal Title column which is displayed in the book list.

How can I update the Title (not title sort!) column from a regex?
halloleo is offline   Reply With Quote
Old 11-23-2020, 07:47 PM   #2
capink
Evangelist
capink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipediacapink knows more than wikipedia
 
Posts: 432
Karma: 47410
Join Date: Aug 2015
Device: Kindle
It is there, two places after the title_sort, which is out of position and sometimes make things confusing.

Edit: The reason the title_sort is out of position is probably because fields are sorted by name and not label. The name of the title_sort field (in the field metadata) is sort, so it appears in the menu before tag and title.
Attached Thumbnails
Click image for larger version

Name:	1.png
Views:	42
Size:	26.2 KB
ID:	183548  

Last edited by capink; 11-23-2020 at 07:50 PM.
capink is offline   Reply With Quote
Advert
Old 11-23-2020, 07:51 PM   #3
halloleo
Zealot
halloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
Posts: 114
Karma: 12649
Join Date: Feb 2020
Device: iPad
Thanks @capink! I could swear, that it was not there when I tried.

Will look at the list again tonight when I'm back at my calibre machine.
halloleo is offline   Reply With Quote
Old 11-25-2020, 01:30 AM   #4
halloleo
Zealot
halloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
Posts: 114
Karma: 12649
Join Date: Feb 2020
Device: iPad
You were totally right, @capink! I just had overlooked it because of teh starnge ordering...

Thanks that you bothered to tell my the obvious!
halloleo is offline   Reply With Quote
Old 04-07-2021, 05:56 PM   #5
GOROW
Junior Member
GOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to behold
 
Posts: 5
Karma: 11516
Join Date: Oct 2013
Location: Austria
Device: Kobo touch
Hello.
I found this thread and want to ask if somebody knows the name of the "sorted title" field in the CALIBRDB field list. i.e:
calibredb list --library-path "D:\EB_NEU" --separator \ --limit 500 --fields authors,author_sort,title,?title_sort? ....
I don't know the name for this field: ?title_sort?
Thanks for replys.
GOROW is offline   Reply With Quote
Advert
Old 04-07-2021, 06:40 PM   #6
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 12,173
Karma: 59280049
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Forma, Clara HD, Nexus 7 HD, iPad Pro, Tolino epos
Quote:
Originally Posted by GOROW View Post
Hello.
I found this thread and want to ask if somebody knows the name of the "sorted title" field in the CALIBRDB field list. i.e:
calibredb list --library-path "D:\EB_NEU" --separator \ --limit 500 --fields authors,author_sort,title,?title_sort? ....
I don't know the name for this field: ?title_sort?
Thanks for replys.
Check message #2 in this thread.

Quote:
Edit: The reason the title_sort is out of position is probably because fields are sorted by name and not label. The name of the title_sort field (in the field metadata) is sort, so it appears in the menu before tag and title.
DNSB is offline   Reply With Quote
Old 04-09-2021, 05:03 AM   #7
GOROW
Junior Member
GOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to beholdGOROW is a marvel to behold
 
Posts: 5
Karma: 11516
Join Date: Oct 2013
Location: Austria
Device: Kobo touch
Hallo David.
I tried this command:
"c:\Program Files\Calibre2\calibredb.exe" list --library-path D:\EB_VORRAT --separator { --fields authors,title,sort --line-width 2024 >D:\EB_VORRAT_INHALT.TXT
and the result is:
Unknown fields: sort
I think, CALLIBREDB does not knoe the fieldname "sort".
regards
GOROW is offline   Reply With Quote
Old 04-09-2021, 05:54 AM   #8
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 26,205
Karma: 41365337
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT(Fixed,New Bat.), Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by GOROW View Post
Hallo David.
I tried this command:
"c:\Program Files\Calibre2\calibredb.exe" list --library-path D:\EB_VORRAT --separator { --fields authors,title,sort --line-width 2024 >D:\EB_VORRAT_INHALT.TXT
and the result is:
Unknown fields: sort
I think, CALLIBREDB does not knoe the fieldname "sort".
regards
the sorted field is title_sort or author_sort
theducks is online now   Reply With Quote
Reply

Tags
calibre 5, regular expression, title column

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot figure out, please help: bulk metadata swap numeric mo/yr in title w/ regex anoukaimee Library Management 5 11-07-2019 02:36 AM
bulk custom column assignment procyon Library Management 1 11-27-2017 06:01 AM
shortcut: go to edit a specified user column in bulk directly? nikoski Library Management 13 02-07-2017 12:13 PM
Bulk Clear Custom Column Date - Not Working BetterRed Calibre 5 02-23-2013 05:04 AM
Bulk Edit Comments column Jade Aislin Library Management 0 10-27-2011 03:18 AM


All times are GMT -4. The time now is 06:12 PM.


MobileRead.com is a privately owned, operated and funded community.