Discussion Locked

Reports from ASCII files

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
From an ASCII file I need to View/Sort/Filter/Print data into Reports. ASCII file could be 30MB. Want simple inexpensive user friendly software that anyone would be able to run. May want to copy filtered data into Excel.

3 replies

by aaron_wurthmann

I'm not sure what the size limit on Wordpad is but that is a possibility. Notepad as I am sure you are aware will have issues with a file that size.

Typically what I do is. I install TextPad http://www.textpad.com/ TextPad allows you to edit an ascii file faster than any other text editor from what I have seen, so replacing a tab with a , is easy. You can also use macro and you can also use regular expressions. So anyway, what I do is use TextPad to add commas and save the file as a CSV thenopen the CSV in Excel. (the default associated application for a CSV is Excel).

Hope that helps.

This discussion is closed to new replies.