[GUI Plugin] Multi-Column Search - Page 17

DaltonST · 01-13-2018, 03:41 PM

Yes, but it updates only Custom Columns. See the posts starting from Oct 13, 2017, some of which include examples. Also read the MCS ToolTips.

If you want to change Comments itself, simply update an appropriate CC and the copy it to Comments using Bulk Edit Search and Replace. Then empty that CC.

DaltonST

ilovejedd · 01-13-2018, 10:56 PM

Awesome. Thanks! Managed to get it working using the following regex:

Code:

Summary[\s]+(.{0,2000}?)[\s]{3,}

Couldn't figure out a way to get rid of Summary[\s]+ via regex tab but calibre's metadata search and replace worked.

DaltonST · 05-06-2019, 04:48 PM

Tanjamuse:

See the attached.

You will need to revise your Full Text Search regular expression based variations in your first page of your TXT files. I have no idea what they really look like, and how standardized or non-standardized they might be. Regardless, the attached example shows you how to get started.

DaltonST

Tanjamuse · 05-07-2019, 01:38 AM

I added the information to the metadata CC, but because it doesn't look like how FFF plugin creates it, it doesn't update any of the columns.

All the lines included in the txt query are lines constant.

This is the non-html version of the metadata column:

Spoiler:

ilovejedd · 05-09-2019, 03:40 PM

Quote:

Originally Posted by Tanjamuse

I added the information to the metadata CC, but because it doesn't look like how FFF plugin creates it, it doesn't update any of the columns.

All the lines included in the txt query are lines constant.

This is the non-html version of the metadata column:

Spoiler:

I don’t think there’s a one-click method of transferring that in bulk to multiple custom columns.

Running multiple regex saved searches should work, though. I have like 20+ of those for my AO3 direct downloaded fanfics (yes, I have a lot of custom columns). Hence, I usually wait to process stuff in batches of at least 10. It’s pretty quick to go through all the saved searches though. Just a continuous Load search/replace and click Apply, rinse and repeat until done.

Either that or convert the metadata into a format that FFF will accept.

Tanjamuse · 05-10-2019, 01:15 AM

I was trying to add it to the saved metadata column and then have FFF update based on that column.

ilovejedd · 05-10-2019, 03:44 AM

Quote:

Originally Posted by Tanjamuse

I was trying to add it to the saved metadata column and then have FFF update based on that column.

As mentioned, if you go that route, you'll need to convert it first to a format that FFF likes. I doubt that'll be easy. You'll probably need to program your own user-defined template function.

Or perhaps you can request JimmXinu to add support for that layout in FFF saved metadata.

Tanjamuse · 05-10-2019, 06:53 AM

I tried changing it to only add the fandoms (category) to a column but I don't think I've done it correctly:

Code:

^Category[:]-Genre[:][ ]

DaltonST · 05-10-2019, 01:09 PM

Quote:

Originally Posted by Tanjamuse

I tried changing it to only add the fandoms (category) to a column but I don't think I've done it correctly:

Code:

^Category[:]-Genre[:][ ]

Try ^Category[:].+Genre[:][ ]

Show Tooltip

Tanjamuse · 05-10-2019, 01:15 PM

I only want the line for category, is that possible? And if I add all the metadata in the columns where they belong can you create a tool that would let me create the saved metadata exactly the way FFF creates them (html included)?

DaltonST · 05-15-2019, 02:10 PM

See the attached image which shows how using a regular expression can isolate a very specific single line in a TXT format ebook due to the regular expression compile option "Multiline".

Pythex is a great tool for independently testing regular expressions using random sample text and then showing the selected text results, if any.

DaltonST

ilovejedd · 05-15-2019, 03:16 PM

Quote:

Originally Posted by Tanjamuse

I only want the line for category, is that possible?

This is the MCS Full TXT search regex I use for extracting Additional Tags from AO3 direct downloaded epubs (converted to TXT using Calibre).

Spoiler:

Code:

(?<=\nAdditional Tags:)[\n]+([^\n]+?)[\n]{2,}

I direct the MCS search results into a temporary #txtquery long text custom column and use a Calibre saved search/replace to copy from #txtquery to the correct tag-like custom columns. If I put the MCS search results directly into tag-like custom columns, I get a single tag "foo, bar" instead of two separate tags "foo", "bar".

As an example, for the following:

Spoiler:

You would use this to extract fandom:

Code:

(?<=\nFandoms:)[\n]+([^\n]+?)[\n]

DaltonST · 06-18-2019, 02:42 PM

MCS needs a lot of testing of its changes for Python 3 before I can release it into the wild. Attached is the first beta test version.

If you frequently use MCS, and especially if you use it for anything FF-related, I would greatly appreciate the fine details of any anomalies you might find.

Thanks in advance.

DaltonSTShow Tooltip

DaltonST · 07-07-2019, 09:53 AM

Any issues found by the 10 (thank you) people who have installed it?

DaltonST

DaltonST · 07-08-2019, 10:02 AM

Version 1.0.75 - 08 July 2019 Python 3 Compatibility. Minimum Calibre Version 3.41.3.

Upgrade Calibre first.

DaltonST

01-13-2018, 10:56 PM	#242
ilovejedd hopeless n00b Posts: 5,126 Karma: 19597086 Join Date: Jan 2009 Location: in the middle of nowhere Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9	Awesome. Thanks! Managed to get it working using the following regex: Code: Summary[\s]+(.{0,2000}?)[\s]{3,} Couldn't figure out a way to get rid of Summary[\s]+ via regex tab but calibre's metadata search and replace worked.

05-06-2019, 04:48 PM	#243
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	FF Text #Metadata Custom Column Extraction Tanjamuse: See the attached. You will need to revise your Full Text Search regular expression based variations in your first page of your TXT files. I have no idea what they really look like, and how standardized or non-standardized they might be. Regardless, the attached example shows you how to get started. DaltonST Attached Thumbnails

05-07-2019, 01:38 AM	#244
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I added the information to the metadata CC, but because it doesn't look like how FFF plugin creates it, it doesn't update any of the columns. All the lines included in the txt query are lines constant. This is the non-html version of the metadata column: Spoiler: Adapter_Classes: ArchiveOfOurOwnOrgAdapter AO3 Categories: M/M Author: Mews1945 Authorhtml: Mews1945 Author ID: Mews1945 Author URL: http://archiveofourown.org/users/Mew...seuds/Mews1945 Byline: Mews1945 Packaged: 2017-10-08T14:18:06.733000 Published: 2006-04-07T00:00:00 Updated: 2006-04-07T00:00:00 Summary: Frodo is lost in a storm, and Merry comes to find him. Fandoms: Lord of the Rings (2001 2002 2003) Langcode: en Language: English Lastupdate: Last Update Year/Month: 2006/04 Last Update: 2006/04/07 Chapters: 1 Words: 6324 Python_Version: 2.7.15+ (default, Jan 16 2019, 15:06:17) [MSC v.1900 64 bit (AMD64)] Rating: Explicit Story URL Section: https://archiveofourown.org/works/73969 Series: Additional Series: Additional Series: Additional Series: Publisher: archiveofourown.org Site Abbrev: ao3 Status: Completed Story ID: 73969 Story URL: http://archiveofourown.org/works/73969 Title: Shelter From the Storm Titlehtml: Shelter From the Storm Downloader Version: FanFicFare v3.7.0 Warnings: No Archive Warnings Apply

05-10-2019, 06:53 AM	#248
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I tried changing it to only add the fandoms (category) to a column but I don't think I've done it correctly: Code: ^Category[:]-Genre[:][ ]

05-15-2019, 02:10 PM	#251
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	MCS Full-Text Search Regular Expression Compile Option "Multiline" See the attached image which shows how using a regular expression can isolate a very specific single line in a TXT format ebook due to the regular expression compile option "Multiline". Pythex is a great tool for independently testing regular expressions using random sample text and then showing the selected text results, if any. DaltonST Attached Thumbnails

01-13-2018, 03:41 PM	#241
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Yes, but it updates only Custom Columns. See the posts starting from Oct 13, 2017, some of which include examples. Also read the MCS ToolTips. If you want to change Comments itself, simply update an appropriate CC and the copy it to Comments using Bulk Edit Search and Replace. Then empty that CC. DaltonST

05-10-2019, 01:15 AM	#246
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I was trying to add it to the saved metadata column and then have FFF update based on that column.

05-10-2019, 01:15 PM	#250
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I only want the line for category, is that possible? And if I add all the metadata in the columns where they belong can you create a tool that would let me create the saved metadata exactly the way FFF creates them (html included)?

06-18-2019, 02:42 PM	#253
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	MCS for Py3 Beta #1 - Especially Fan Fiction Users MCS needs a lot of testing of its changes for Python 3 before I can release it into the wild. Attached is the first beta test version. If you frequently use MCS, and especially if you use it for anything FF-related, I would greatly appreciate the fine details of any anomalies you might find. Thanks in advance. DaltonSTShow Tooltip Last edited by DaltonST; 07-08-2019 at 11:29 AM.

07-07-2019, 09:53 AM	#254
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	MCS for Py3 Beta #1 - Especially Fan Fiction Users Any issues found by the 10 (thank you) people who have installed it? DaltonST

07-08-2019, 10:02 AM	#255
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Version 1.0.75 Python 3 Compatibility. Minimum Calibre Version 3.41.3. Version 1.0.75 - 08 July 2019 Python 3 Compatibility. Minimum Calibre Version 3.41.3. Upgrade Calibre first. DaltonST

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[GUI Plugin] Search the Internet	kiwidude	Plugins	436	05-12-2025 09:02 PM
[GUI Plugin] Clipboard Search	kiwidude	Plugins	29	04-02-2024 10:05 PM
[GUI Plugin] Walk Search History	kiwidude	Plugins	38	03-17-2024 12:47 AM
[GUI Plugin] Recoll Full Text Search	Satas	Plugins	16	08-05-2016 03:54 AM
[GUI Plugin] Full Text Search (SOLR)	peterpisljar	Plugins	2	08-09-2015 08:16 AM