Help with "Guessing metadata from file names"

[Justy]

Originally Posted by kovidgoyal

Have you checked the option to read metadata only from filenames.

Yes, I have that option and 'merge similar file names' both checked.

Originally Posted by Starson17

Try this:

([^_]+ )(?P<author>[A-Za-z]+) ((?P<series>[^_\d]+)(?P<series_index>\d+)? )?(?P<title>[^_]+)

Thank you so much, such a small change but it made all the difference.

You guys are great!

[Starson17]

Originally Posted by Justy

Thank you so much, such a small change but it made all the difference.

You guys are great!

It works, but it shouldn't. There's something odd going on with the regex. When I get time, I'll take a look at it. In the meantime, I thought I'd post something that works for you to use.

[Justy]

I feel kind of silly asking for help on this same issue again. I found more files to import and these 2 pieces of code which both worked at various times in the past are not giving the expected results now. I suspect that Calibre has changed a bit with all the wonderful updates Kovid & team have been adding for us.

Originally Posted by user_none

This will work provided there are no numbers in the series name:

[^_]+_(?P<author>[^_]+)_((?P<series>[^_\d]+)(?P<series_index>\d+)?_)?(?P<title>[^_]+)

Originally Posted by Starson17

Try this:

([^_]+ )(?P<author>[A-Za-z]+) ((?P<series>[^_\d]+)(?P<series_index>\d+)? )?(?P<title>[^_]+)

My test file names were:

1. Genre_AuthorLastName_Title.prc
2. Genre_AuthorLastName_Series01_Title.prc

which gave the following results respectively:

1. Title = Genre AuthorLastName Title
2. Title = Genre AuthorLastName Series01 Title

[Starson17]

Originally Posted by Justy

I feel kind of silly asking for help on this same issue again. I found more files to import and these 2 pieces of code which both worked at various times in the past are not giving the expected results now. I suspect that Calibre has changed a bit with all the wonderful updates Kovid & team have been adding for us.

I just tested the code I gave you previously, and it still works for me.

([^_]+ )(?P<author>[A-Za-z]+) ((?P<series>[^_\d]+)(?P<series_index>\d+)? )?(?P<title>[^_]+)

My test file names were:

1. Genre_AuthorLastName_Title.prc
2. Genre_AuthorLastName_Series01_Title.prc

which gave the following results respectively:

1. Title = Title
2. Author = AuthorLastName
   
   and
3. Title = Title
4. Author = AuthorLastName
5. Series= Series
6. SeriesIndex = 1
   

[Justy]

That code works perfectly this morning, I don`t know what was happening last night. Thank you for checking into this for me!

[Ababakar]

i´m losing my hair on the same issue.
i got it working - but exactly the way i want.

My files are named:
isbn_authors_title - 2nd title.pdf

so for example:
123456789_Peter Pan and Bugs Bunny_The Science of things - And other stories.pdf

so far i made it work for this scheme

123456789 - Peter Pan and Bugs Bunny - The Science of things- And other stories.pdf

The code used for this is:
(?P<isbn>.+) - (?P<author>[^_]+) - (?P<title>[^_]+)

But i didn´t get the "_" to work. Also in some cases i got a year and an edition after the title (isbn_authors_title - 2nd title_year_edition.pdf) - but as these won´t be imported anyway (if i understood correctly).

[Manichean]

What regexes did you try to get the underscores to work?

[Ababakar]

figured it out myself with the link of ilovejedd in this thread here: https://www.mobileread.com/forums/showthread.php?t=40993

thanks anyway