I have a lot of lines of text. I can put them into a text file or into an Excel spreadsheet. They need many changes. Here's an example of a before and after:
Input: I'm buying one! Only $39 ..... Output: I'm buying one - Only USD 39
In other words, the HTML code got converted to an apostrophe, the exclamation mark became a space-hyphen, duplicate spaces were stripped out,
USD, and ending
spaces were removed until none were left.
I am guessing two different processes may be needed -- first, a simple character substitution for all occurrences, and then a looping procedure that keeps reducing multiple instances (e.g., converting two spaces to one until there are no more two-space combinations).
Ideally, I would have a readily editable list, as in an Excel spreadsheet, with one cell for the "before" and an adjacent cell for the "after." Or at least I would ideally have that for the simple substitution part of the operation.
I've seen a bunch of macros and scripts, in various posts, but most of them aren't quite on target and some of them I don't understand. Any suggestions?