[StegBook]

I'm trying to use Bulk Edit to copy from the series name to the series index.

I have "The Secret Cold War 4[1]" in the series column and I want to change the index to 4 but am getting the following error

I'm using
Search Field: series
Search For: \d
Destination Field: series_index



calibre, version 3.28.0
ERROR: Failed: could not convert string to float: The Secret Cold War

Traceback (most recent call last):
File "site-packages\calibre\gui2\dialogs\metadata_bulk.py", line 168, in do_it
File "site-packages\calibre\gui2\dialogs\metadata_bulk.py", line 445, in do_all
File "site-packages\calibre\db\cache.py", line 63, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1092, in set_field
File "site-packages\calibre\db\write.py", line 540, in set_books
File "site-packages\calibre\db\write.py", line 540, in <dictcomp>
File "site-packages\calibre\db\write.py", line 141, in adapt_series_index
File "site-packages\calibre\db\write.py", line 96, in adapt_number
ValueError: could not convert string to float: The Secret Cold War


Any help is appreciated