On 11/02/12 15:38, Israel, John R. wrote: > Windows uses a CR LF where UNIX uses just one (I forget which as I sit at > home). The other is converted to a FM. Stripping off the offending > character from Windows will still leave the file in a traditional FM > delimited structure that is easy to manipulate. We do this all the time with > imports. > But that's the point - the problem character is NOT the CR, it's the LF or FM, whichever one UV cares to present to you. Strip out the FMs, and you won't be able to process it row by row because you won't have row*s* to process.
> As always, there are exceptions to any thing. Yes. In this case it's the FM that is the problem ... > > John Israel > Cheers, Wol > Sent from my iPhone > > On Feb 11, 2012, at 6:22 AM, "Wols Lists" <[email protected]> wrote: > >> On 09/02/12 17:03, Israel, John R. wrote: >>> I always read in the file and convert known "problem characters" to null >>> then process the file row by row. >> >> Except if you do that *here* you won't be able to convert it row by row >> ... you'll have all the data in just one row !!! >> >> Cheers, >> Wol >>> _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
