I'm exporting from Excel and importing into jBASE. DCOUNTing on the
header line is an excellent idea. I'll give that a try. Since I'm using
a convert routine, if that fixes the problem, it will be fixed for any
spreadsheet I import.
It may very well be someone hitting Enter when typing, because some
links in the descriptions don't cause this problem. If I could just
detect it in the spreadsheet itself, I could let my distributor know
what's causing it and which rows need fixing on their end. They are
usually pretty good about fixing things, if they know what to do.
Charlie
On 02-09-2012 10:26 AM, George Gallen wrote:
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: [email protected]
[mailto:[email protected]] 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: [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
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
