|I have a text file that need to clean up. For the most part it is CSV format, however there are several instances where a little cleanup is required. I have several strings similar to this|
That I would like to look like this
There are two patterns that I need to find and replace the first is the combination of a # followed by a return. I need to replace this with a ,
The second pattern is a return followed by a [. I need to replace this with a space.
I am assuming that I can do this with some sort of FOR command, I'm just not sure how to go about setting it up.