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 > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] 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" <ggal...@wyanokegroup.com> 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: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users