[eschwartz]

Excellent point... so you could import using

(?P<comments>.*)

And then select all books, select Edit Metadata, go to the Search and replace tab, and select
Search mode: Regular Expression
Search field: comments
Search for:

\[Novel\] ([^)(]+)\((.+)\) (\d+) (.*)

Then toggle through the following Replace with and Destination field sets:

for:
title: \1 -- #alt_title: \2 -- series: \1 -- series_index: \3 #status: \4

Replace with: \1
Destination field: title
---------------------------
Replace with: \2
Destination field: #alt_title
---------------------------
Replace with: \1
Destination field: series
---------------------------
Replace with: \3
Destination field: series_index
---------------------------
Replace with: \4
Destination field: #status


Wheeeee! But ugly as heck and takes quite a few steps. Definitely faster than hand-editing.

@xd1986k, you got that?