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

GOROW · 04-13-2021, 05:46 AM

hello theducks.
Sorry, but I tried to run the calibredb.exe from CMD. May there is no field in the calibre-database for sorted titles.

1st try; the field-list operand is:
--fields authors,author_sort,title,sort
and errormessage is:
Unknown fields: sort

2nd try; the field-list operand is:
--fields authors,author_sort,title,title_sort
and errormessage is:
Unknown fields: title_sort

regards Gorow

theducks · 04-13-2021, 12:01 PM

Well, title_sort is a valid field name (it IS available in the Bulk MDE) , but it may not be accessible from the CLI.

GOROW · 04-16-2021, 02:27 AM

OK. I just want to inform about the output from field_list function of calibredb:

C:\Users\TEST>"c:\Program Files\Calibre2\calibredb.exe" set_metadata --list-fields ...

Titel Feldname

Autorensortierung author_sort
Autoren authors
Kommentare comments
Titelbild cover
Kennungen identifiers
Sprachen languages
Veröffentlicht pubdate
Verlag publisher
Bewertung rating
Serie series
Serie Index series_index
Größe size
Titelsortierung sort
Schlagwörter tags
Datum timestamp
Titel title
Titelbild cover

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

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 Wizard Posts: 1,085 Karma: 1948136 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 Groupie Posts: 156 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 Groupie Posts: 156 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: 8 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: 8 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

04-13-2021, 05:46 AM	#9
GOROW Junior Member Posts: 8 Karma: 11516 Join Date: Oct 2013 Location: Austria Device: Kobo touch	hello theducks. Sorry, but I tried to run the calibredb.exe from CMD. May there is no field in the calibre-database for sorted titles. 1st try; the field-list operand is: --fields authors,author_sort,title,sort and errormessage is: Unknown fields: sort 2nd try; the field-list operand is: --fields authors,author_sort,title,title_sort and errormessage is: Unknown fields: title_sort regards Gorow

04-13-2021, 12:01 PM	#10
theducks Well trained by Cats Posts: 29,785 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Well, title_sort is a valid field name (it IS available in the Bulk MDE) , but it may not be accessible from the CLI.

04-16-2021, 02:27 AM	#11
GOROW Junior Member Posts: 8 Karma: 11516 Join Date: Oct 2013 Location: Austria Device: Kobo touch	OK. I just want to inform about the output from field_list function of calibredb: C:\Users\TEST>"c:\Program Files\Calibre2\calibredb.exe" set_metadata --list-fields ... Titel Feldname Autorensortierung author_sort Autoren authors Kommentare comments Titelbild cover Kennungen identifiers Sprachen languages Veröffentlicht pubdate Verlag publisher Bewertung rating Serie series Serie Index series_index Größe size Titelsortierung sort Schlagwörter tags Datum timestamp Titel title Titelbild cover