I found myself needing to do this, and created a Regular Expression that allows me to change all of the Status fields from “todo” to “deleted” on a book by book basis. I noticed that the format/order of the fields in the XML file was always consistent:
![image](/?qa=blob&qa_blobid=8676796555756999050)
image1284×121 7.28 KB
So I was able to create an expression that finds a VerseRef in a particular book, ignores the rest of that line, then skips over any number of lines that begin with spaces and then a <S
or <C
, then looks for a line that starts with spaces and then <Status>todo
. It will change that “todo” to “deleted”. Here is the expression:
Find: (VerseRef="\dJN .+\r\n(\s+<[SC].+\r\n)*?\s+<Status>)todo
Replace: \1deleted
So in a text editor that can work with Regular Expressions (Notepad++ if you don’t have a favorite), use those find and replace strings to find all of the notes that are not resolved in 1JN, 2JN, 3JN, and change them to resolved.
The \dJN
in the find expression uses a further RegEx to find notes in all books that start with a digit and then JN. You can replace that string with another book code to find the notes in that book, e.g. MAT
, ISA
, or things like \dCO
for 1CO and 2CO.
Hope that helps someone out there (and might help me if I have to do it again…
)