Regular Expression for filenames with commas

[jomaweb]

Hi all

I got a bunch of eBooks with this filename structure:

Surname, Firstname - book Title

When adding to Calibre library, using the default Regular Expression

(?P<author>[^_]+) - (?P<title>.+)

author appears with a strange symbol (pipe?) between name and surname because of the comma.

I'm not a computer geek, so if anyone can tell me how to fix the regular expression to add this kind of files I'll appreciate it.

A solution for bulk repairing the previously hundred books addedd is possible too? Fixing one by one is a lot of time consuming

Thanks in advance

[Starson17]

Originally Posted by jomaweb

Hi all

I got a bunch of eBooks with this filename structure:

Surname, Firstname - book Title

When adding to Calibre library, using the default Regular Expression

(?P<author>[^_]+) - (?P<title>.+)

author appears with a strange symbol (pipe?) between name and surname because of the comma.

I'm not a computer geek, so if anyone can tell me how to fix the regular expression to add this kind of files I'll appreciate it.

A solution for bulk repairing the previously hundred books addedd is possible too? Fixing one by one is a lot of time consuming

Thanks in advance

In Preferences, under Add/Save, select the "Swap author firstname and lastname" checkbox. It will split and swap at the comma. The regex you are using will work (but not for series names and numbers). Mass fixing isn't easy. For a few hundred, it may be easiest to simply remove and re-add them.

[jomaweb]

But it's not possible to readd them because I've deleted the original files.

my bad