![]() ![]() Okay, the macro below was quickly written and is also very simple. Know now that I'm open to pretty much anything, what method do you suggest to meet the requirements I mention in the first paragraph in this reply? I briefly looked at the 3 posts you provided links for. To be honest I was hoping you'd reply with a reference to some feature built into UE/Studio that lets the user reference a source file (some kind of delimited txt based file) that contains a list of words to find and what to replace them with kind of like adding custom dictionary files. It doesn t matter if it's a tab delimited file or a CSV file or something else because I can export the list from Excel to a delimited txt file very easily each time I need to provide an update to the list of find & replace words. I'm open to any methods on doing this with the preference that it be something that add to the list or taking away from the list is as easy as adding and deleteing a line of text and that the items can be kept in a single file. ![]() Also important is to know if only a single replace or a replace all should be executed on the source file and also if the search strings are case sensitive or not.Ĭurrently the list of Find & Replace values are in an Excel spreadsheet. Possible would be also a tab character, a comma, a semicolon, a paragraph sign or something similar. The separator character should be a character which surely does never exist in any search and replace string. ![]() So the list file is a CSV file without specials like double quoted or multi-line fields. If you post how the list file looks, it can write in a few minutes the macro. I found this topics by searching with the advanced forum search in the Macro forum only for find replace loop copy. Iterate thru a list of files, each with its own find/replace criteria Replace text in file A with info from file B I have several macros written for such q task. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |