× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Dan, I think .txt works for tab-delimited - Excel understands this intrinsically, IIRC.

Tab in EBCDIC is x'05', in ASCII it's x'09'. So use x'05' on the 400 - it'll get translated properly.

HTH

Vern

At 08:11 AM 1/17/03 -0800, you wrote:
<Not interested in commercial products for this issue>

(This is NOT a question about how to email from the AS/400.  We are
already doing that.  This question is specific to determining the
requirements for an AS/400-created file that double-clicking on the
attachment will automagically open it up in Excel.)

Have a new application that will have the AS/400 sending an email with
an attachment.  The attachment will be a file created on the 400 and it
needs to be in a format that will cause Excel to open it when the
recipient clicks on it from the email.  It would appear that
tab-delimited format would be preferable to comma-separated values
format because of the potential for commas in the data.  Note, this
will be an email opened on both Windows and Mac clients (Yes, the Mac
clients have Microsoft Office installed).

The archives mentions CPYTOIMPF can create a CSV file, and I see that
you can specify the field delimiter, which defaults to a comma.  I saw
in the archives someone suggested using x'05' on this parameter to
create a tab-delimited file, although there was confusion on whether it
should be x'05' or x'09'.  FWIW, we're on v4r5.  Assuming that one of
these creates the tab-delimited file, what file extension should we use
in order to help Excel recognize it properly, without asking the user
to specify "what kind of file is this?" factoids?

TIA, Dan

P.S.  In my archive search, I came across a very funny thread about a
"table saw shake" that I remember from a few years ago.  If you need a
good laugh today, just start at
http://archive.midrange.com/midrange-l/199907/msg00978.html and follow
the thread.  Also, Pat's mea culpa starts at
http://archive.midrange.com/midrange-l/199907/msg01026.html .






As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.