in reply to Converting txt Reports (.prn file) in Excel with Perl

Hi admiraln,

Take a look at Spreadsheet::Write on CPAN. It won't help you remove the printer control characters, but it does give you a nice, easy interface to create spreadsheets (Excel, OpenOffice, CSV, etc.) as well as individual sheets within the spreadsheet document.

Does the final output have to be a spreadsheet? If not, it might be easier to convert .prn file you're already creating into a PDF for distribution. Just an idea.

HTH,

/Larry