Find and replace from a lists (in bulk)

Question

Hi all
As I was cleaning up some of the old projects in Paratext, I find some lists of things used which I need to find and replace in bulk
for example.
‘MAT’ > ‘मत्ती’
‘MRK’ > ‘मरकुस’
‘LUK’ > ‘लूका’
‘JHN’ > ‘योहन’
‘ACT’ > ‘परेरितहुंण’
‘1CO’ > ‘1 कुरिन्थिहुंण’
‘2CO’ > ‘2 कुरिन्‍थिहुंण’
etc.
Earlier I used CCTable for finding a lists like MAT, MRK etc in \fig (picture) and replace the found item with respective change only in the \fig.
I am curious to know whether there is already something similar to this in Paratext / RegEx Pal to find a list of item to replace to the respective item in the lists

thanks for the advice in advance…

I found out that Notepad ++ and 2problems can do the same (but not in a particular field like only in \fig…

Answer 1

You can use RegexPal to read a file with multiple search/replace phrases, here is an explanation:

All Cap text and undocumented RegEx Questions

Hi Kent & anon719148 You can have multiple find/replaces stored in a file and run an expression that points to that file in RegExPal. The syntax is to use "–>"and then point to the filename with the replaces in the find box. Similar to the following: –>\Users\HastyDR\Desktop\smallcaps.txt Note: I don’t think it works if the path name contains any spaces, which is why I chose to place the file on my desktop. In that file place statements similar to the following for all lower to uppercase co…

Comments

Thank you anon719148 for pointing the link… I tried it with Roman Script and it is working. But it is not working with Devanagiri Script (Non Roman Script)

for example
(?<=\xt\s[^\]?)यूह–>यूहन्‌ना
(?<=\xt\s[^\]?)baba–>BABA

It skips the first search but maches only the second one from the lists

---

I’m sorry, it seems like only ANSI-characters are possible to use. This is an older encoding only for roman script, not Unicode/UTF-8. (cf. Using a list for replacing in RegEx Pal - #4 by phil_leckrone).
Currently, I see three options to go ahead in this case:

1. Use CCTable again
2. file a feature request for RegexPal to read UTF-8 files properly
3. find and adapt a script from there: A new place to let people know about your custom python scripts for Paratext