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

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
>