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.
As always, there are exceptions to any thing. John Israel Sent from my iPhone On Feb 11, 2012, at 6:22 AM, "Wols Lists" <antli...@youngman.org.uk> 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 >> >> -----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 > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
