Need help with metadata by filename

[myle00]

@oldcrow74 The reason why the filenames didn't come out exactly as in the test cases may be because calibre imports metadata from the files and it might have found different info in the metadata than that based on the regex. Also, regex is not that hard to learn and once learned is very powerful. You can also use it in java.

[kovidgoyal]

calibre gets metadata from two sources, in the following order:

1) The file itself
2) The filename

(2) is only used if there is no metadata in the file itself. If you want (2) to be used in preference to 1, there is an option in preferences to do just that

[sbin]

I'm curious about option 1):
how does the file need to have the metadata info written in it?
My books come from html files, where should I write the metadata?
(Maybe I could do so -almost- automatically, because before calibre I used to index my books in an excel spreadsheet)
I already tried to write them like this https://wiki.mobileread.com/wiki/Metadata#HTML_metadata, but when I add the book in calibre, it doesn't work.



My books are named as:
Harris, Charlaine - Aurora Teagarden 01 - 1990. Real Murders [9780425218716].htm
Harris, Charlaine - Sookie Stackhouse 04.1 - 2004. Fairy Dust [9780441011977].htm

As you can see, a lot of info in the filename.
So far, I've come up with this regular expression:
(?P<author>.+?) - ((?P<series>.+?) (?P<series_index>\d+) - )?(?P<title>.+)
but it recognizes metadata until the <title> (not included).

Can someone help me? Thank you.


--edit:
Maybe I got it:
(?P<author>.+?) - ((?P<series>.+?) (?P<series_index>\d+) - )(?P<pubdate>\d+\.)(?P<title>.+)\[(?P<isbn>\d+)\]