Re: Double-click emailed AS400-created file and open up in Excel,automagically

[Scott Klement <klemscot@xxxxxxxxxxxx>]

Perhaps you should simply create the CSV file in an RPG program, instead
of using IBM's routines to do it?   That would allow you to
programmatically double-up the quotes, and make CSV work properly.

If you're not familiar with writing to the IFS from an RPG program, I
wrote an e-book that explains it.  Take a look:

http://www.snap-ebooks.com/RPGIV%20and%20the%20Integrated%20File%20System.htm

So far, sales for this ebook haven't been that great, despite it being
only (US) $9.99.   I think not many people have heard about it yet.
Still... it might solve your problem..

On Sun, 19 Jan 2003, Dan wrote:

> That was me, Scott.
>
> Only problem with csv, with the double quotes used to enclose character
> fields, is that we'll get double quote characters as data, and that
> creates havoc with the data when Excel converts it.
>
> - Dan
>