Exporting data as a pure single text stream - challenge

[RobE]

I need to export a load of sheets for importing into an EDI system. I have tried with various text, tsv, csv files with various delimiters.
I can get each line of the sheet exported correctly but I actually need the whole file on a single continuous data stream (ie no line breaks)
There can be several hundred lines on the sheet.
I could happily put everything on a single line in the spreadsheet and then save as a csv however I doubt there are enough columns to support the size of the sheet
Does anyone know how to do this either with an export, macro/vba or even an external programme that takes my csv and converts the line breaks to commas

Thanks
Rob

 

[Legacy 98055]

Hi
There are size limitations to strings, however, this could easily be resolved with a binary write to a file.
Post a sample of your data.
Tom