For any CSV processing, you must process character by character. Use OSBREAD to get a block of characters and start parsing. Strings like 1,ABC,"2"" adapter",, can only be correctly parsed by looking at each character and applying the simple CSV rules. Using CONVERT statements only makes the process more complex and inaccurate.
rex On Thu, May 26, 2011 at 8:14 AM, George Gallen <[email protected]> wrote: > In your subroutine, if you first convert @FM -> char(250) > Then do your line scan, when your inside a quote , if you encounter a > char(250) > convert it to a char(253) > once your done, convert char(250) back to @FM > > If when your scanning, everytime you encounter a ", you flip the quoteon value > from 0 -> 1 -> 0 it shouldn't matter if you encounter double quotes _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
