My files are in this order
Lastname, Firstname - [Series 02] - Book title
and Lastname, Firstname - [Series name 01] - Book Title [read]
I want to have any book marked [read] to show in the custom column I created on import so I do not have to manually edit them.
I found these snippets from a penguinaka that work well for importing the books but not sure how to deal with the custom column.
^(?P<author>[^-]+)(\s*-\s*(\[?(?P<series>[^-0-9]+)\s*(?P<series_index>[0-9.]+)?]?)?)?.*?-\s*(?P<title>[^\]{[()]+\w)
this one removes all brackets around the series and anything in brackets in the title section doesn't get imported imported
^(?P<author>[^-]+)(\s*-\s*(\[?(?P<series>[^-0-9]+)\s*(?P<series_index>[0-9.]+)?]?)?)?.*?-\s*(?P<title>[^-]+)
this one removes brackets around the series section but leaves things in brackets in the title so you get version information imported with the title