Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 05-13-2019, 02:09 AM   #1
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,158
Karma: 5306
Join Date: Jan 2014
Device: none
Change Metadata in a Long Text Column

Hi.

I need some help creating a S&R if it's possible (or more than one).

This is an example of what I want.

This:

Spoiler:



A Lot More

by Nicky_Gabriel



Category: Riptide (TV)
Genre: Gen
Language: English
Status: Completed
Published: 2010-05-13
Updated: 2010-05-13
Packaged: 2017-10-09 10:37:39
Rating: Teen And Up Audiences
Warnings: No Archive Warnings Apply
Chapters: 1
Words: 1,306
Publisher: archiveofourown.org
Story URL: https://archiveofourown.org/works/86358
Author URL: https://archiveofourown.org/users/Ni.../Nicky_Gabriel
Summary: <blockquote class="userstuff">
<p>I'm not that brave, Cody. Not anymore.</p>
</blockquote>


Needs to be changed to this:

Spoiler:
<div><p><span class="label">Adapter_Classes</span>: </p><div class="metadata list" id="adapter_classes"><ul>
<li>ArchiveOfOurOwnOrgAdapter</li>
</ul></div><p>

</p><p><span class="label">AO3 Categories</span>: </p><div class="metadata list" id="ao3categories"><ul>
<li>Gen</li>
</ul></div><p>

</p><p><span class="label">Author</span>: </p><div class="metadata list" id="author"><ul>
<li>Nicky_Gabriel</li>
</ul></div><p>

</p><p><span class="label">Authorhtml</span>: </p><div class="metadata" id="authorHTML"><a class="authorlink" href="https://archiveofourown.org/users/Nicky_Gabriel/pseuds/Nicky_Gabriel">Nicky_Gabriel</a></div><p>

</p><p><span class="label">Author ID</span>: </p><div class="metadata list" id="authorId"><ul>
<li>Nicky_Gabriel</li>
</ul></div><p>

</p><p><span class="label">Author URL</span>: </p><div class="metadata list" id="authorUrl"><ul>
<li>https://archiveofourown.org/users/Nicky_Gabriel/pseuds/Nicky_Gabriel</li>
</ul></div><p>

</p><p><span class="label">Byline</span>: </p><div class="metadata" id="byline">Nicky_Gabriel</div><p>

</p><p><span class="label">Packaged</span>: </p><div class="metadata datetime" id="dateCreated">2017-10-09T14:34:34.947000</div><p>

</p><p><span class="label">Published</span>: </p><div class="metadata datetime" id="datePublished">2010-05-13T00:00:00</div><p>

</p><p><span class="label">Updated</span>: </p><div class="metadata datetime" id="dateUpdated">2010-05-13T00:00:00</div><p>

</p><p><span class="label">Summary</span>: </p><div class="metadata" id="description">

<blockquote class="userstuff">
<p>I'm not that brave, Cody. Not anymore.</p>
</blockquote>

</div><p>

</p><p><span class="label">Fandoms</span>: </p><div class="metadata list" id="fandoms"><ul>
<li>Riptide (TV)</li>
</ul></div><p>

</p><p><span class="label">File Extension</span>: </p><div class="metadata" id="formatext">.txt</div><p>

</p><p><span class="label">File Format</span>: </p><div class="metadata" id="formatname">txt</div><p>

</p><p><span class="label">Freeform Tags</span>: </p><div class="metadata list" id="freeformtags"><ul>
<li>Gen</li>
</ul></div><p>

</p><p><span class="label">Langcode</span>: </p><div class="metadata" id="langcode">en</div><p>

</p><p><span class="label">Language</span>: </p><div class="metadata" id="language">English</div><p>

</p><p><span class="label">Lastupdate</span>: </p><div class="metadata list" id="lastupdate"><ul>
<li>Last Update Year/Month: 2010/05</li>
<li>Last Update: 2010/05/13</li>
</ul></div><p>

</p><p><span class="label">Chapters</span>: </p><div class="metadata int" id="numChapters">1</div><p>

</p><p><span class="label">Words</span>: </p><div class="metadata" id="numWords">1306</div><p>

</p><p><span class="label">Python_Version</span>: </p><div class="metadata" id="python_version">2.7.15+ (default, Jan 16 2019, 15:06:17) [MSC v.1900 64 bit (AMD64)]</div><p>

</p><p><span class="label">Rating</span>: </p><div class="metadata" id="rating">Teen And Up Audiences</div><p>

</p><p><span class="label">Story URL Section</span>: </p><div class="metadata" id="sectionUrl">https://archiveofourown.org/works/86358</div><p>

</p><p><span class="label">Series</span>: </p><div class="metadata" id="series00HTML"></div><p>

</p><p><span class="label">Additional Series</span>: </p><div class="metadata" id="series01HTML"></div><p>

</p><p><span class="label">Additional Series</span>: </p><div class="metadata" id="series02HTML"></div><p>

</p><p><span class="label">Additional Series</span>: </p><div class="metadata" id="series03HTML"></div><p>

</p><p><span class="label">Publisher</span>: </p><div class="metadata" id="site">archiveofourown.org</div><p>

</p><p><span class="label">Site Abbrev</span>: </p><div class="metadata" id="siteabbrev">ao3</div><p>

</p><p><span class="label">Status</span>: </p><div class="metadata" id="status">Completed</div><p>

</p><p><span class="label">Story ID</span>: </p><div class="metadata" id="storyId">86358</div><p>

</p><p><span class="label">Story URL</span>: </p><div class="metadata" id="storyUrl">https://archiveofourown.org/works/86358</div><p>

</p><p><span class="label">Title</span>: </p><div class="metadata" id="title">A Lot More</div><p>

</p><p><span class="label">Titlehtml</span>: </p><div class="metadata" id="titleHTML"><a class="titlelink" href="https://archiveofourown.org/works/86358">A Lot More</a></div><p>

</p><p><span class="label">Downloader Version</span>: </p><div class="metadata" id="version">FanFicFare v3.7.0</div><p>

</p><p><span class="label">Warnings</span>: </p><div class="metadata list" id="warnings"><ul>
<li>No Archive Warnings Apply</li>
</ul></div><p></p></div>


It has to include all the html because otherwise FFF can't recognize it.

I hope someone can help.
Tanjamuse is offline   Reply With Quote
Old 05-13-2019, 09:59 AM   #2
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 3,867
Karma: 9099999
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, iPad 9.7, iPad 12.9
Unless someone's willing to take up the task of writing code to convert from plain text to HTML (probably via user-defined program which is a relatively significant undertaking) or you learn to program in python and do it yourself, converting from plain text directly to custom columns is easier.

e.g.
Code:
Search field:
#your_source_metadata_column

Search for:
Category: ([^\n]+)

Replace with:
\1

Destination field:
#fandom

Code:
Search field:
#your_source_metadata_column

Search for:
Story URL: https://archiveofourown.org/works/([0-9]+)

Replace with:
\1

Destination field:
#storyId
ilovejedd is offline   Reply With Quote
Old 05-13-2019, 10:36 AM   #3
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 23,063
Karma: 24012262
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab A, Kobo Aura2
Yep! I was looking at that and going: Why aren't those values in individual Columns? (not a good plan if the 'columns' needed vary widely. Should be for a few 'well defined' uses)

BUT
(I don't know how to write the code). Isn't most of what you want, what Convert from: TXT to: HTM or EPUB mostly does?


Paste raw text into the comments (Normal view tab) , then switch to the HTML tab, and that will be wrapped in HTML tags (maybe not all what you want)
Remember, sometimes it is way easier to break the task, int discrete processes. Make it HTMP. Parce it into 'fields'. Arrange (beautify) the fields
theducks is offline   Reply With Quote
Old 05-13-2019, 12:09 PM   #4
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 3,867
Karma: 9099999
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, iPad 9.7, iPad 12.9
I expect the data was extracted from ebooks (maybe using MultiColumnSearch Full TXT search feature) that didn't have the actual metadata embedded (e.g. book has jacket/title page with the info but not in the OPF file).

It's not just converting to HTML. The id tags is the important part as it tells the FanFicFare plugin which data should go to specific custom columns. There's no way to automate that without writing your own function (or a very complicated regex) and without the ids, converting to HTML is pointless.

Alas, manual editing to HTML might be doable for a few books. Not so much when you have to deal with hundreds or even thousands.

@Tanjamuse
Just a thought, extract just the StoryURL and let FanFicFare redownload. If any have been deleted, then just work on those separately.

Code:
Search field:
#your_source_metadata_column

Search for:
Story URL: (http[^\n]+)

Replace with:
\1

Destination field:
#storyUrl
ilovejedd is offline   Reply With Quote
Old 05-13-2019, 12:34 PM   #5
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,158
Karma: 5306
Join Date: Jan 2014
Device: none
All of them has been deleted, which is why I haven't got the saved metadata column that FFF creates.
Tanjamuse is offline   Reply With Quote
Old 05-13-2019, 05:52 PM   #6
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 13,024
Karma: 10793226
Join Date: Mar 2012
Location: Sydney Australia
Device: none
There are HTML/Text Editors that support saved searches, regular expressions, and/or macro/plugin facility. They might not do what you want in bulk, but you might be able to fashion a 'Couple-of-Clicks' solution and do them one at time.

NoteTab is pretty good (sort of Sigil on Steroids). There comparison lists on Wikipedia.

BR
BetterRed is offline   Reply With Quote
Old 05-13-2019, 06:10 PM   #7
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 3,867
Karma: 9099999
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, iPad 9.7, iPad 12.9
Quote:
Originally Posted by BetterRed View Post
There are HTML/Text Editors that support saved searches, regular expressions, and/or macro/plugin facility. They might not do what you want in bulk, but you might be able to fashion a 'Couple-of-Clicks' solution and do them one at time.

NoteTab is pretty good (sort of Sigil on Steroids). There comparison lists on Wikipedia.

BR
The end goal is not the HTML itself. It's to move the data into individual custom columns.

Personally, I think it's simpler to run some Calibre saved search/replace than to do a whole lot of copy/paste to/from external programs in order to convert the text to something FanFicFare compatible, just so one can use the update metadata feature of FFF.
ilovejedd is offline   Reply With Quote
Old 05-13-2019, 06:26 PM   #8
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 13,024
Karma: 10793226
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by ilovejedd View Post
The end goal is not the HTML itself. It's to move the data into individual custom columns.
Maybe the text Tanjamuse has in the long text column can be tin-bashed into the format that calibre uses for its book list metadata copy and paste, visually it looks like this.

Code:
Title               : Quick Start Guide
Title sort          : Quick Start Guide
Author(s)           : John Schember [Schember, John]
Languages           : eng
Timestamp           : 2018-12-21T09:05:24+00:00
Published           : 0101-01-01T00:00:00+00:00
Comments            : calibre Quick Start Guide
Read                : Yes
That looks quite close to what she has. Maybe a plugin, that can operate on multiple books, that tin-bashes the long text into metadata copy shape and invokes the existing metadata paste function.

Added : Calibre's metadata paste will only operate on data created by calibre's metadata copy, but a calibre plugin should able to imitate that.

BR

Last edited by BetterRed; 05-13-2019 at 06:57 PM.
BetterRed is offline   Reply With Quote
Old 05-14-2019, 04:18 AM   #9
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,158
Karma: 5306
Join Date: Jan 2014
Device: none
It's 500+ stories that I need to do it with, which is why I had hoped for another solution than doing it manually. I ilovejedd's solution:

Code:
Search field:
#your_source_metadata_column

Search for:
Category: ([^\n]+)

Replace with:
\1

Destination field:
#fandom
But the result was not what I had expected:

Spoiler:
<div><div><font face="Segoe UI, 023</font></div><div><font face="Segoe UI, F/M</font></div><div><font face="Segoe UI, sans-serif" size="2"> &lt;/blockquote&gt;</font></div></div>, sans-serif" size="2"> &lt;p&gt;&lt;b&gt;Spoilery:&lt;/b&gt; Do 1x13 &lt;i&gt;Le Morte d'Arthur&lt;/i&gt;.&lt;/p&gt;</font></div><div><font face="Segoe UI, sans-serif" size="2"><br></font></div><div><font face="Segoe UI, sans-serif" size="2">Author URL: https://archiveofourown.org/users/idrilka/pseuds/idrilka</font></div><div><font face="Segoe UI, sans-serif" size="2">by idrilka</font></div><div><font face="Segoe UI, sans-serif" size="2">Chapters: 1</font></div><div><font face="Segoe UI, sans-serif" size="2">Genre: AU, sans-serif" size="2">Language: Polski</font></div><div><font face="Segoe UI, sans-serif" size="2">Le Fay</font></div><div><font face="Segoe UI, sans-serif" size="2">Merlin (BBC)</font></div><div><font face="Segoe UI, sans-serif" size="2">Packaged: 2017-10-09 11:59:51</font></div><div><font face="Segoe UI, sans-serif" size="2">Published: 2010-05-16</font></div><div><font face="Segoe UI, sans-serif" size="2">Publisher: archiveofourown.org</font></div><div><font face="Segoe UI, sans-serif" size="2">Rating: General Audiences</font></div><div><font face="Segoe UI, sans-serif" size="2">Series: Morgan le Fay [1]</font></div><div><font face="Segoe UI, sans-serif" size="2">Status: Completed</font></div><div><font face="Segoe UI, sans-serif" size="2">Story URL: https://archiveofourown.org/works/87083</font></div><div><font face="Segoe UI, sans-serif" size="2">Summary: &lt;blockquote class="userstuff"&gt;</font></div><div><font face="Segoe UI, sans-serif" size="2">Updated: 2010-05-16</font></div><div><font face="Segoe UI, sans-serif" size="2">Warnings: No Archive Warnings Apply</font></div><div><font face="Segoe UI, sans-serif" size="2">Words: 2
Tanjamuse is offline   Reply With Quote
Old 05-14-2019, 10:26 AM   #10
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 3,867
Karma: 9099999
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, iPad 9.7, iPad 12.9
Quote:
Originally Posted by Tanjamuse View Post
It's 500+ stories that I need to do it with, which is why I had hoped for another solution than doing it manually. I ilovejedd's solution:

Spoiler:
Code:
Search field:
#your_source_metadata_column

Search for:
Category: ([^\n]+)

Replace with:
\1

Destination field:
#fandom


But the result was not what I had expected:

Spoiler:
<div><div><font face="Segoe UI, 023</font></div><div><font face="Segoe UI, F/M</font></div><div><font face="Segoe UI, sans-serif" size="2"> &lt;/blockquote&gt;</font></div></div>, sans-serif" size="2"> &lt;p&gt;&lt;b&gt;Spoilery:&lt;/b&gt; Do 1x13 &lt;i&gt;Le Morte d'Arthur&lt;/i&gt;.&lt;/p&gt;</font></div><div><font face="Segoe UI, sans-serif" size="2"><br></font></div><div><font face="Segoe UI, sans-serif" size="2">Author URL: https://archiveofourown.org/users/idrilka/pseuds/idrilka</font></div><div><font face="Segoe UI, sans-serif" size="2">by idrilka</font></div><div><font face="Segoe UI, sans-serif" size="2">Chapters: 1</font></div><div><font face="Segoe UI, sans-serif" size="2">Genre: AU, sans-serif" size="2">Language: Polski</font></div><div><font face="Segoe UI, sans-serif" size="2">Le Fay</font></div><div><font face="Segoe UI, sans-serif" size="2">Merlin (BBC)</font></div><div><font face="Segoe UI, sans-serif" size="2">Packaged: 2017-10-09 11:59:51</font></div><div><font face="Segoe UI, sans-serif" size="2">Published: 2010-05-16</font></div><div><font face="Segoe UI, sans-serif" size="2">Publisher: archiveofourown.org</font></div><div><font face="Segoe UI, sans-serif" size="2">Rating: General Audiences</font></div><div><font face="Segoe UI, sans-serif" size="2">Series: Morgan le Fay [1]</font></div><div><font face="Segoe UI, sans-serif" size="2">Status: Completed</font></div><div><font face="Segoe UI, sans-serif" size="2">Story URL: https://archiveofourown.org/works/87083</font></div><div><font face="Segoe UI, sans-serif" size="2">Summary: &lt;blockquote class="userstuff"&gt;</font></div><div><font face="Segoe UI, sans-serif" size="2">Updated: 2010-05-16</font></div><div><font face="Segoe UI, sans-serif" size="2">Warnings: No Archive Warnings Apply</font></div><div><font face="Segoe UI, sans-serif" size="2">Words: 2
Try replacing search for with this:
Code:
[\w\W]*Category: ([^\n<>]+)[\w\W]*
Mind you, there's no "Category: ..." line in that blurb you posted. I see a div with Le Fay and Merlin (BBC) but it's not preceded by Category:. I don't think there's code that would automatically catch those unless you specifically list and search for all the possible fandom names in your library.

For the above example, try the search code using Series: or Story URL: because it's not gonna find anything for Category:.
ilovejedd is offline   Reply With Quote
Old 05-14-2019, 10:35 AM   #11
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 23,063
Karma: 24012262
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab A, Kobo Aura2
Regex has an OR Catagor([ies|y]) <done off the top o me head, I am traveling and my cheat sheets are home
theducks is offline   Reply With Quote
Old 05-14-2019, 10:44 AM   #12
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 3,867
Karma: 9099999
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, iPad 9.7, iPad 12.9
Quote:
Originally Posted by theducks View Post
Regex has an OR Catagor([ies|y]) <done off the top o me head, I am traveling and my cheat sheets are home
Regex does but the lines are:
Code:
Language: Polski
Le Fay
Merlin (BBC)
Packaged: 2017-10-09 11:59:51
Unless one lists all fandoms in the regex, I don't think it's possible to identify that Le Fay and Merlin (BBC) are categories/fandoms. If the order the metadata is listed in is always the same, it could work but that seems to vary as well (see first post where Category is listed first).
ilovejedd is offline   Reply With Quote
Old 05-14-2019, 10:47 AM   #13
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,158
Karma: 5306
Join Date: Jan 2014
Device: none
I don't know what has happened with that column. I added the information from my txt-file to the metadata column (Long text, not shown in browser - like a comments column) and then tried the Regex ilovejedd posted earlier with the result posted above ending up in the fandom column. As far as I can see "Le Fay" is the author and not the fandom.
Tanjamuse is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Browser Viewer: Long-text Custom Column nqk Server 8 08-05-2018 08:25 AM
Custom column long text toolbar MerlinMama Calibre 2 03-01-2017 01:14 PM
Annoyance - Column Type Long Text BetterRed Calibre 4 08-28-2016 11:29 PM
Custom yes/no column built from long text column Philantrop Library Management 7 03-23-2013 07:44 PM
No search/replace on custom long text column? CWatkinsNash Library Management 2 06-20-2011 05:57 PM


All times are GMT -4. The time now is 12:33 PM.


MobileRead.com is a privately owned, operated and funded community.