View Single Post
Old 02-26-2023, 08:49 PM   #11
culytera
Zealot
culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.culytera ought to be getting tired of karma fortunes by now.
 
Posts: 131
Karma: 295674
Join Date: Jul 2021
Device: iPhone
Quote:
Originally Posted by ownedbycats View Post
Ah, that makes sense.

In theory, I think it might be possible to use a gpm template to regex a full-text column and display it as an unsorted column. In practice, I'm not quite good enough at templates or regexes to try this. And it'd be the unmodified tags, which would make it kinda messy.

I did use a regex search & replace to populate my #fanficratings column from the longtext rather than run a 'update from column' on everything, though.

search: (?s).*(<p><span class='label'>Rating<\/span>: <div class='metadata' id='rating'>(.*?)<\/div><p>).*
replace with: \2
Interesting method. So you just put all the metadata pulled by FanFicFare into one long text custom column? Is the search & replace afterwards automated?

I wonder if that's faster than filling each custom column via FanFicFare.

Last edited by culytera; 02-26-2023 at 08:54 PM.
culytera is offline   Reply With Quote