16 replies to this topic

[JerrySeville]

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

Edited by Zahara_Sierra, 09 September 2023 - 07:41 AM.

[JerrySeville]

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

Edited by Zahara_Sierra, 09 September 2023 - 08:03 AM.

[JerrySeville]

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')

[Katoog]

 

UPDATE Bible

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

 

Rather with a space:

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

 

 

[JerrySeville]

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

[APsit190]

(with a space after cf0)
<red>red</red>
\cf6 red\cf0
 
<i>italics</i>
In \cf15\i italics\i0\cf0  words added by the translation
 
<b>bold</b> are
In \b bold\b0  are

 
There is another method of doing rtf code, and that putting things in braces.
 
Using Katoog's code samples, in braces is looks like this:

• {\b bold}
• {\cf15\i need}

In example #1, the code outputs that word in bold.
In example #2, the code outputs that word in italics = need and etc.

 

This method is actually recommended by Microsoft, and of which they use in their examples.
 
Also, you might find this resource helpful:

Word2007RTFSpec9.pdf

Category: e-Sword Documentation

Last Updated Mar 22 2023 04:05 PM

 
Blessings,

Edited by APsit190, 10 September 2023 - 05:14 PM.

[Tj Higgins]

 

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')

 

When using Simple Bible Reader you can click settings from the programs menu at the top of program window . This will open the setting menu and from that menu select preferences, This will open the preferences settings box that has several options  One of the options is labeled "Add Red Text for Christ's Words" there is check box next to this option check the box and SBR will add the red text color