How to regex bulk update the Title column from another column?

halloleo · 11-23-2020, 07:41 PM

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?

capink · 11-23-2020, 07:47 PM

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.

halloleo · 11-23-2020, 07:51 PM

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 · 11-25-2020, 01:30 AM

You were totally right, @capink! I just had overlooked it because of teh starnge ordering...

Thanks that you bothered to tell my the obvious!

GOROW · 04-07-2021, 05:56 PM

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.

DNSB · 04-07-2021, 06:40 PM

Quote:

Originally Posted by GOROW

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.

GOROW · 04-09-2021, 05:03 AM

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

theducks · 04-09-2021, 05:54 AM

Quote:

Originally Posted by GOROW

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

11-23-2020, 07:41 PM	#1
halloleo Zealot 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?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

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

11-23-2020, 07:47 PM	#2
capink Evangelist 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 Last edited by capink; 11-23-2020 at 07:50 PM.

11-23-2020, 07:51 PM	#3
halloleo Zealot 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.

11-25-2020, 01:30 AM	#4
halloleo Zealot 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!

04-07-2021, 05:56 PM	#5
GOROW Junior Member 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.

04-09-2021, 05:03 AM	#7
GOROW Junior Member 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

Advert

Advert