Jump to content

JerrySeville

Member Since 03 Mar 2015
Offline Last Active Feb 15 2024 05:45 PM
-----

Posts I've Made

In Topic: Creating a bblx file for an older version of e-Sword

09 September 2023 - 08:52 AM

I actually found out that I needed a space after writing the changes and checking the Bible in eSword. Thanks again, Katoog!


In Topic: Creating a bblx file for an older version of e-Sword

09 September 2023 - 08:08 AM

The code for the search and replace of the HTML tags for a red-letter RTF-based version (for e-Sword version 10.4.0) is as follows:
 

UPDATE Bible
SET Scripture=replace(Scripture,'<red>','\cf6')

 

and
 

UPDATE Bible
SET Scripture=replace(Scripture,'</red>','\cf0')

In Topic: Creating a bblx file for an older version of e-Sword

09 September 2023 - 08:00 AM

APsit190, ElderB, and Katoog, you guys are fantastic! I have been wanting to do something like this for months and, with your good help, it has come to fruition!

I've figured out how to do black-letter and red-letter versions of a RTF-based BBLX file with SQL. Thanks again and God bless :)


In Topic: Creating a bblx file for an older version of e-Sword

09 September 2023 - 07:40 AM

Wow! Thanks!
 

I just used DB Browser for SQLite for the first time in my life and managed to eliminate the html tags and produce an entirely black-letter version of the bblx with the following code:
 

UPDATE Bible
SET Scripture=replace(Scripture,'<red>','')

 

and
 

UPDATE Bible
SET Scripture=replace(Scripture,'</red>','')

 

Hope I can figure out how to do a red-letter version using your code above :)


In Topic: Creating a bblx file for an older version of e-Sword

09 September 2023 - 06:45 AM

My thanks to you both for the detailed and informative responses! I am completely ignorant about RTF code. Would it be simply a matter of find (the HTML tags) and replace with SQLite?