|
Posted by Andrew on December 28, 2006, 10:47 pm
Please log in for more thread options
Han wrote:
> I think a tab delimited txt file is very similar to a prn file. ...
Han, I was just scanning this post, not really following the discussion,
but you say "I think a tab delimited txt file is very similar to a prn file"
that leap out at me. A .prn file is, I think, very different from a 'tab
delimited txt file'. A prn file is a printer-formated file that contains
print codes, and other printer-specific items, often in binary data, not
just text....if you used a text editor to look at it, it is totally
gibberish.
Look at http://www.frogmorecs.com/arts/what-is-a-prn-file.html for a good
description of what it is, what it does, and how to ultimately use it.
--
-------------------------------------------------------------
Regards -
- Andrew
|
|
Posted by Han on December 29, 2006, 3:26 pm
Please log in for more thread options
> Han wrote:
>
>> I think a tab delimited txt file is very similar to a prn file. ...
>
> Han, I was just scanning this post, not really following the
> discussion, but you say "I think a tab delimited txt file is very
> similar to a prn file" that leap out at me. A .prn file is, I think,
> very different from a 'tab delimited txt file'. A prn file is a
> printer-formated file that contains print codes, and other
> printer-specific items, often in binary data, not just text....if you
> used a text editor to look at it, it is totally gibberish.
> Look at http://www.frogmorecs.com/arts/what-is-a-prn-file.html for a
> good description of what it is, what it does, and how to ultimately
> use it.
>
A prn file (print, then export, choose prn) can be opened with excel, and
properly gets into excel, if you choose comma as the delimiter. To me this
is very, very, VERY close to a csv file, or a txt file, similarly printed
via the print, then export options.
--
Best regards
Han
email address is invalid
|
|
Posted by Andrew on December 29, 2006, 4:38 pm
Please log in for more thread options Han wrote:
>
>> Han wrote:
>>
>>> I think a tab delimited txt file is very similar to a prn file. ...
>>
>> Han, I was just scanning this post, not really following the
>> discussion, but you say "I think a tab delimited txt file is very
>> similar to a prn file" that leap out at me. A .prn file is, I think,
>> very different from a 'tab delimited txt file'. A prn file is a
>> printer-formated file that contains print codes, and other
>> printer-specific items, often in binary data, not just text....if you
>> used a text editor to look at it, it is totally gibberish.
>> Look at http://www.frogmorecs.com/arts/what-is-a-prn-file.html for a
>> good description of what it is, what it does, and how to ultimately
>> use it.
>>
> A prn file (print, then export, choose prn) can be opened with excel,
> and properly gets into excel, if you choose comma as the delimiter.
> To me this is very, very, VERY close to a csv file, or a txt file,
> similarly printed via the print, then export options.
Oh, I see now. You're talking about Q's ".prn" file that is created by
FILE-->EXPORT (I did your command sequence). I was talking about a Windows
print .prn file (again, see my URL I cited above). The filetype '.prn' is
overloaded; differing data types using the same extension. In
http://en.wikipedia.org/wiki/List_of_file_extensions_by_alphabet#P, one sees
the following:
PRN Printer driver; Signature
PRN Text file; Lotus 1-2-3 - Symphony
PRN Usually printer output file;
I was talking about the 3rd in the list above that I am familiar with; you
were talking about the second.
Thanks - a little education for perhaps both of us!
--
-------------------------------------------------------------
Regards -
- Andrew
|
|
Posted by Han on December 29, 2006, 6:31 pm
Please log in for more thread options
> Oh, I see now. You're talking about Q's ".prn" file that is created
> by FILE-->EXPORT (I did your command sequence). I was talking about a
> Windows print .prn file (again, see my URL I cited above). The
> filetype '.prn' is overloaded; differing data types using the same
> extension. In
> http://en.wikipedia.org/wiki/List_of_file_extensions_by_alphabet#P,
> one sees the following:
>
> PRN Printer driver; Signature
> PRN Text file; Lotus 1-2-3 - Symphony
> PRN Usually printer output file;
>
>
> I was talking about the 3rd in the list above that I am familiar with;
> you were talking about the second.
>
> Thanks - a little education for perhaps both of us!
>
Now I see.
<jokingly>
I was familiar with the prn file as a printer output file (write it to an
8" floppy, go to the big office printer, get a really nice dot matrix
printout), but that was some time ago.
</jokingly>
More recently, I have used either the prn, txt, or csv file type from
several programs as an output destined to be able to be parsed by Excel. I
even now have a program that outputs data collected by an A/D converter for
use in Excel or other spreadsheet, but they call it a *.del file.
--
Best regards
Han
email address is invalid
|
|
Posted by DP on December 29, 2006, 2:19 am
Please log in for more thread options
>
> Have you successfully opened a file (in Excel) generated from the account
> overview tab?
Yes, if I choose the EXPORT option.
> Does not go to completion in the OP's case, and neither in
> my case. A shortcut gets generated, but no real file.
But neither of you chose to export, did you? You chose to "print to file"
instead, right?
|
| Similar Threads | Posted | | Re: Printing to Adobe pdf | April 20, 2006, 10:35 am |
| Re: Printing to Adobe pdf | April 20, 2006, 11:38 pm |
| Printing to Adobe pdf | April 20, 2006, 9:35 am |
| printing of reports screwed up | October 24, 2006, 3:26 pm |
| Attachment Printing Size | December 4, 2006, 7:00 pm |
| Check Printing Font | January 26, 2007, 8:40 am |
| Printing Reports from Q 2007 | February 3, 2007, 10:07 am |
| Printing with Quicken QIF alternatives | March 23, 2007, 4:27 pm |
| Tranaction Report Printing | June 12, 2007, 6:36 pm |
| Address Book not printing | June 24, 2007, 11:27 am |
|
|
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap