I am dumping data that I would like to import into Excel. Unfortunately, there are many newlines in the text fiels, so I am restoreing to the -r switch to change the record separator, so that the embedded newlines can be distinguished.
This makes is hard to import into Excel.
So far I have tried using regex replacement, but cannot so far get the right combination.
To solve this, I either need a way to escape the newlines as they are exported, or a set to regex replacements that I can do to get the data into excel. It would be ok to have the newlines replaced by some character while in Excel. Unfortunately every combination I have tried so far, evenb including muilti-character sequences, leads to some conflict somewhere along the lines.