The problem occurs before it ever gets to UV (or in my case jBASE). The
csv flat file already has the cell split into 2 lines.
On 02-09-2012 10:53 AM, Symeon Breen wrote:
It is entitrely possible and ok to have new lines inside a cell in excel and
inside a cell in a csv
The following
"col1",2,"col3 and
New line",col4
Is ok because the new line is inside the quotes of col3
The trick when parsing in u2 is to not do it line by line, but byte by byte
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 09 February 2012 16:31
To: U2 Users List
Subject: Re: [U2] Building an Excel File
BTW, this occurs usually, when a textbox is used for data entry, someone
pastes a URL, then hits the ENTER key And then types some more data. To the
original database/excel file it's one cell (.xls file), but when that Source
file is exported to the .csv (you know, that warning that some formatting
features will be lost?!?)
What would solve the problem would be if the .csv standard also included
escaping of cr and lf characters so That the export didn't get broken....
I get those frequently from clients, when they have address fields where the
client types the first line, Then hits enter and enters the second line,
instead of having two address line fields.
-----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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1424 / Virus Database: 2112/4797 - Release Date: 02/08/12
_______________________________________________
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
