Alright, I grabbed a brand new ff.net story in my test database, with those two extra columns. I'm not sure why the initial expression didn't work, but with a few adjustments, I got something that does.
Removing the quotes IE, no extra spaces
especially at the end since that'll screw up the regex:
Code:
"(.*?)http(s?)://www.fanfiction.net/u/(.*?)/(?s).*"
-or-
"([\s\S]*)http(s?)://www.fanfiction.net/u/(.*?)/([\s\S]*)"
both work fine for me with everything you specified.
Search mode: regex,
search field: #author_url
Search for: (either above option)
Replace with:\3
Destination field: (your choice)
Keep in mind to change /u/ and /s/ for whichever you're using.
Note: I didn't try it with the title (storyID) since it didn't download for some reason and since the author one works fine, I'm assuming the title one will too. If not I'll go back and figure it out.
Nevermind, checked and it works.
Also, I'd like to add if you weren't aware,
" storyId=>#id"
that's an easier way to keep the story ID number in a custom column (#id in my case) for newly downloaded (or updated) fics. I don't think there's one for author ID though.