I always read in the file and convert known "problem characters" to null then process the file row by row.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Joshua Gallant Sent: Thursday, February 09, 2012 11:44 AM To: U2 Users List Subject: Re: [U2] Building an Excel File I was going to ask the same question about embedded line feeds. I've been dealing with a lot of outside companies the last few months transferring data and found a lot have embedded line feeds all over. - Josh On 2/9/12 11:11 AM, "George Gallen" <[email protected]> wrote: Is it possible that the URL has an embedded lf at the end from entry on the source side? I've created csv files comma/quoted that contained URLs and were quite long and didn't have any issues importing Them into excel as a .csv , at least not as breaking into two lines. George -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:06 AM To: U2 Users List Subject: Re: [U2] Building an Excel File Thanks George. I changed the tabs to pipes just to display them here. Normally I save as tab delimited with no surrounding character. Since the cell contents copies and pastes as 2 lines, I'm not sure whether these suggestions would solve my problem. Thanks again, Charlie On 02-09-2012 8:54 AM, George Gallen wrote: > Not sure if this helps... > > I noticed that you were showing pipe delimited lines... > If you rename your file from .csv to .txt > > Then from excel, you use the "Open" option, and then you can set the >delimiter to | > And also change the column types before it imports it, or have it >skip a column as well. > > George > > -----Original Message----- > From: [email protected] >[mailto:[email protected]] On Behalf Of Charlie Noah > Sent: Thursday, February 09, 2012 9:46 AM > To: U2 Users List > Subject: Re: [U2] Building an Excel File > > While everyone is thinking about CSV and Excel, maybe I can get a > solution to a problem that's been plaguing me for a long time. > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
