Search and replace individual letters
I imported a file into RM from Family Tree Maker 2005. Some of my data was originally entered using the Hebrew alphabet. When imported, the Hebrew characters were converted to Corsican characters (all accented vowels). I was able to work out a chart matching each Corsican character with it's Hebrew equivalent, so what I want to do is search and replace each character globally, which would entail a total of 27 replacements (one for each letter of the relevant alphabet). Using search, I was able to find all of any particular character, but the "search and replace" function only works on specific fields. Is there a fix that will help? I have no SQL experience, so if there is something that can be done, I need very specific instructions. Thanks in advance
You could do this using the REPLACE() function in an UPDATE for each character for each column of each table in which they are likely to be found.
Given your skills in SQLite, an easier solution might be to export the database and use a text editor to search and replace across the entire GEDCOM, provided you can live with the losses attending such a transfer into a new RM database.
I have MSAccess 2010 on my computer. Since that program has built-in "find & replace" would linking the RM database to MSAccess (following your very clear instructions on the "Learn" page), and then making the replacements there, work more comfortably than GEDCOM export and import?
Maybe someone else can answer your question. It depends on whether Access has a global s&r. If not, then it's 27 s&r ops per text column. The GEDCOM would require just one set of 27 ops.
I haven't used Access in over a decade and never with a SQLite database.
Thanks Tom for you very rapid and helpful reply. I haven't used Access in even longer - I got the idea from your "learn" page. I'll try the gedcom method and hopefully all will be well.