Are you have trouble importing into UV, or importing it into Excel? If UV, what I do is while looping through the data to be imported, do a dcount on the fields If the dcount is not the same as the dcount on the header line, then concatenate the following to it And skip the following line. You could go the route of keep checking the dcount until it's equal just In case you find a cell or cells that have more than one embedded cr on that row.
The problem is in UV, there is no way to distinguish the embedded cr (sorry not lf) from an @AM, however, Usually, excel sees it usually fine, if it's still in the .xls format, but when it exports it to .csv That embedded cr causes it to break it to new line, so you wind up getting the beginning on one line And the end of the row on the next line. -----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:22 AM To: U2 Users List Subject: Re: [U2] Building an Excel File It's certainly possible, although I can't detect it. Do you know how I would see it in the spreadsheet itself? Charlie On 02-09-2012 10:11 AM, George Gallen 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 > _______________________________________________ > 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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
