Iterate thru a list of files, each with its own find/replace criteria

[careya123]

I have a list of files, each with its own find/replace criteria. Here's what the list looks like:

Format:
folderX/sco.xml, findText, replaceText

folder1/sco.xml, Subtraction Sense, Addition Facts
folder2/sco.xml, Multiplying with Decimals, Adding with Decimals
folder3/sco.xml, Numeration, Permutations and Combinations

So for every file, I have a different find/replace scenario. Any ideas on how this might be handled in UltraEdit? I'm not familiar with this program, but it looks promising for this task.

Thanks,
Carey

[Mofi]

Best would be to do this with a script which can store strings in variables. That would make it possible to use the replace in files script command to do the replaces in the files without opening the files which is surely the fastest method.

But script developing needs time, much more time than recording a macro and modify it a little to do the same job on every line of the list. I don't know how big your list is and how often you will run this macro in future. If needed only once, the macro is good enough. Otherwise it would be better to develop the script using the method I have written above.

Here is the macro code without an explanation. You should not have any other file open in UltraEdit when you run this macro.

The macro property Continue if search string not found must be checked for this macro.

InsertMode
ColumnModeOff
HexOff
UnixReOff
Bottom
IfColNumGt 1
"
"
IfColNumGt 1
DeleteToStartofLine
EndIf
EndIf
Top
Loop
Find RegExp "%[~^r^n,]+"
IfNotFound
ExitLoop
EndIf
Clipboard 9
Copy
EndSelect
Key RIGHT ARROW
Key RIGHT ARROW
Find RegExp "[~^r^n,]+"
Clipboard 8
Copy
EndSelect
Key RIGHT ARROW
Key RIGHT ARROW
Find RegExp "[~^r^n]+"
Clipboard 7
Copy
EndSelect
Clipboard 9
Open "^c"
Clipboard 7
Paste
SelectToTop
Clipboard 8
Find MatchCase "^c"
Replace All "^s"
IfNotFound
CloseFile NoSave
Else
Delete
CloseFile Save
EndIf
EndLoop
Clipboard 9
ClearClipboard
Clipboard 8
ClearClipboard
Clipboard 7
ClearClipboard
Clipboard 0

Attention: If your list file has not exactly the format as you have written in your post, you will get many files damaged. The format required for the macro is:

name of the file with full path (without comma)commaspacesearch string (without comma)commaspacereplace string (without comma)end of line

[careya123]

Wow, thank you so much. I haven't had time to test it yet, but I am very grateful for your reply.

Carey