Hi,
you should use Expand operation block and use carriage return as a separator.
It should be "\n" or you can try to copy/paste the character.
You can choose .CSV as output in your Data File Output block.

When you import cells from Excel with embedded line breaks, these should be preserved inside Omniscope cells, and if you export as CSV using default CSV options, the cells will be quoted, also preserving those linebreaks. If you then re-import, the linebreaks should *still* be preserved in Omniscope.

It could be that your CSV options aren't the default, and you aren't using a cell separator character (typically a double-quote character). Or perhaps you are importing the well-formed CSV produced by Omniscope in a 3rd party application that doesn't handle this kind of issue correctly.

I don't want to keep the returns, I want to remove them. The vendor to whom I'm sending the data can't handle the embedded returns in the CSV file. I've tried doing a global replace using MS Word but the file is very large and it gets updated weekly so that's not a long-term option.

Hi,
Not sure if you tried the Expand operation, as suggested earlier?
If that doesn't work for some reason, please try Search/Replace operation to replace the carriage return with space, other character or leave blank if you wish to simply remove it.

I had tried Search/Replace but that only removed some of them. I added a second, identical replace rule within the block and that took care of the problem.