Find and replace link names

Ideas and suggestions about new features
User avatar
rdwray
Posts: 565
Joined: Mon Dec 26, 2011 3:06 pm

Re: Find and replace link names

Post by rdwray »

That works for me JG - so how did you do that or is it top secret?????
Take My yoke upon you and learn from Me, for I am gentle and lowly in heart, and you will find rest for your souls.
“For My yoke [is] easy and My burden is light.”
User avatar
JG
Posts: 4598
Joined: Wed Jun 04, 2008 8:34 pm

Re: Find and replace link names

Post by JG »

I used SQLite Regexer from Biblesupport.com

Made sure the module was all converted to rtf and not compressed. Checked that in theWord.
Made backup.
Closed theWord and loaded the module to SQLite Regexer
Right clicked on the content_search table and dropped it.
Selected Table, content
Selected column data
Clicked View Table button, and had a look at some of the content in rtf. Saw a simple search and replace strategy would probably work, which was [space]VN and Replace [space]NKJV ([space] just = a space, I just wanted to make that clear there was one there.)
Press Replace
Job done.

Things could have gone wrong with the search and perhaps I would in other cases needed to anchor it, but this was ok I think. Things can quickly go wrong, and that is why I can't stress too much the need of backup first.
Jon
the
Word 6 Bible Software
OS for testing; Windows 10
Beta Download ------Beta Setup Guide------On-line Manual------Tech doc's and Utilities------Copyright Factsheet
User avatar
rdwray
Posts: 565
Joined: Mon Dec 26, 2011 3:06 pm

Re: Find and replace link names

Post by rdwray »

I only have the free version of SQLite and it does not have search and replace capablilities. I had to export to .csv, do search and replace and import and it is possible that something changed in the operation that is not visible.

God bless JG and again thanks....
Take My yoke upon you and learn from Me, for I am gentle and lowly in heart, and you will find rest for your souls.
“For My yoke [is] easy and My burden is light.”
User avatar
JG
Posts: 4598
Joined: Wed Jun 04, 2008 8:34 pm

Re: Find and replace link names

Post by JG »

This is from Biblesupport.com there is no charge for it.
Put the contents of the zip into a folder and launch from there.
SQLite RegExer 2.3.zip
(1.69 MiB) Downloaded 283 times
Jon
the
Word 6 Bible Software
OS for testing; Windows 10
Beta Download ------Beta Setup Guide------On-line Manual------Tech doc's and Utilities------Copyright Factsheet
User avatar
rdwray
Posts: 565
Joined: Mon Dec 26, 2011 3:06 pm

Re: Find and replace link names

Post by rdwray »

That is a lot easier then what I was doing, thanks again... :D
Take My yoke upon you and learn from Me, for I am gentle and lowly in heart, and you will find rest for your souls.
“For My yoke [is] easy and My burden is light.”
Post Reply