Bulk action: move series data from title to custom column

[annekaelber]

I have a LOT of ebooks where the title column has this:

title-of-book: enemies to lovers second chance romance (series name and book number)

I want to cut the whole parentheses from the title and add it to an existing custom column I have for series data. (Ideally, I'd love to cut the other stuff that comes after the actual title, but I often use that to set the genre, which isn't so cut-and-dried...)

Is what I want to do possible? Or... sobs Will I have to type them all in by hand? (I quit using the download metadata option because more often than not, I got the wrong book or no book.)