CR10 csv output format unsuppressing records

[farside11]

We are running CE10 on a unix platform and need to produce monthly stat files. These can be VERY large and the output needs to be to pipe delimited txt files. However, due to the ongoing bug in crystal, of csv exports not doing the suppression, this a real headache for me. I cannot export to excel as too many records, nor can we eliminate records at record selection time to get around the suppression. The only other format left to me is 'tab separated text', which then does not contain a new line char for each new record. The data fields are in a group footer and run down the page as there are 83 columns, so just can't fit in across the width....not a problem to csv, but a problem to text! I've tried text manipulation software, but not getting anywhere fast. Any ideas at all most welcome - thanks in advance!

 

[DallasAggie]

I've exported into Excel (data only) and Crystal automatically creates a new worksheet to carry the data over.

If you don't want the seperated worksheets, then (if you have CE10) I would recommend exporting to XML...That's what we've done for exports that we needed to import into some other medium.

I'm not to sure what other avenue you can take. You can also develop a little VB/.NET app to take that (or any other) report to perform that task (export to XML)...just a thought.

Sorry, not much help.