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.
First, let me say that it's been my experience that Excel (and Open
Office, which emulates Excel /so /well) has a problem with saving
spreadsheets with double quotes
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 w
Thanks Don! This is quite nice -- and well documented!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don
Sent: Wednesday, February 08, 2012 9:15 PM
To: 'U2 Users List'
Subject: Re: [U2] Building an Excel File [AD-F
This is standard and documented behaviour of a csv - if you have a cell with
a " in it, it is 'escaped' as ""
Anything that then reads a csv must unescape such characters.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behal
Funny how Word's mailmerge doesn't respect the quoted quotes that Excel
produces!
Even though they are cousins...I don't know about Word2010 however, that may
have
Been fixed, but I doubt it.
Although I suspect that the issue with the URL is unrelated to the quote issue.
-Original Message--
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 A
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
Hi Symeon,
I had forgotten that. Fortunately my convert routine hadn't. ;^)
My real problem, though, is URLs splitting lines, which George correctly
surmised was a separate situation.
Thanks,
Charlie
On 02-09-2012 9:54 AM, Symeon Breen wrote:
This is standard and documented behaviour of a c
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 tha
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.
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
formatt
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" wrote:
Is it possible that the URL has an em
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, becaus
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
-Ori
Hi Josh,
I'd be happy to share my routines with you, if they would be of any use.
I have a program I use to load a csv file, and a subroutine which
converts back and forth between csv, dynamic and fixed width, either a
line at a time or an entire flat file.
Charlie
On 02-09-2012 10:44 AM, J
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
Hmm. That might make for an interesting pre-processor to escape those pesky
embedded lf's first
Then run it through your normal parsing program (line by line parsing).
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
I always read in the file and convert known "problem characters" to null then
process the file row by row.
-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
What Symeon suggests should still work, since the break is inside the quotes
(assuming your using
Quoted csv and not tabs), so if you go byte by byte, if you encounter a cr that
is inside quotes
Escape it and keep reading, if you encounter a cr that is between quotes,
consider that the end of th
The trick is to NOT read up to a CR or LF, first, and process that as a line.
You have to read the file as a stream, literally byte-by-byte, and recognize
when you are processing quotes and handle that with different logic.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[
Hmmm... getting a bit complicated now. I think George's suggestion to
DCOUNT the header line and concat if the number of columns are less
might be simpler.
I really appreciate all the ideas, though. They give me something to
think about.
Charlie
"Make things as simple as possible, but not s
Until someone decides to skip trailing, empty columns... :o
YMMV
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: February-09-12 9:25 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Yikes! I've seen that, too.
On 02-09-2012 11:29 AM, Robert Houben wrote:
Until someone decides to skip trailing, empty columns... :o
YMMV
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Februar
I actually worked through it fine. If 10 programmers attempted this the
code would be written 10 different ways but below is what I use. This
works fine if the csv file is a "windows" version where lines end in a
LF:CR. I need to adapt this to work with files generated on other systems.
In my c
Since the discussion has shifted from building Excel to consuming
CSV, here's a reminder that I have a little utility on my
freeware page called ExcelExport, which exports multiple sheets
from a workbook into quoted CSV.
http://nebula-rnd.com/freeware/
There is also a page dedicated to CSV at Pick
Sorry to come in a bit late here. I have worked through a couple of
versions of NebulaXLite and must say I am very impressed, with
both the astounding results and the thoughtful improvements Tony
has made to this breakthrough tool. If you have a requirement to
"clone" an existing spreadsheet, but
Honestly -- back to my prior statement -- why is Rocket just not licensing
the logic and shipping it like DataVu??
I suspect it would be used WAY more!!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey
Hi All
I have a question about what key(s) to enter to insert a value mark when
entering into a field in a screen. The field should probably be changed to
multi-valued from single-valued but this is a generic field that is filled
with data from anywhere in the record to be updated. So, when the
m
It's not Ctrl-Rightbracket ?
-Original Message-
From: Lunt, Bruce
To: u2-users
Sent: Thu, Feb 9, 2012 4:57 pm
Subject: [U2] SB+ editing question
Hi All
have a question about what key(s) to enter to insert a value mark when
ntering into a field in a screen. The field should probably
If you mean: ] that doesn't seem to work.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, February 09, 2012 4:58 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SB+ editing question
It
I've never known it to be enter-able from the keyboard.
On Thu, Feb 9, 2012 at 6:02 PM, Lunt, Bruce wrote:
> If you mean: ] that doesn't seem to work.
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Is there another way?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Thursday, February 09, 2012 5:03 PM
To: U2 Users List
Subject: Re: [U2] SB+ editing question
I've never known it to be enter-abl
Use a Process After Screen Accept to change some other character to it.
On Thu, Feb 9, 2012 at 6:07 PM, Lunt, Bruce wrote:
> Is there another way?
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
>
Thanks, I will try that.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Thursday, February 09, 2012 5:09 PM
To: U2 Users List
Subject: Re: [U2] SB+ editing question
Use a Process After Screen Accep
David W. and others,
I also have a perl script that will parse a Excel worksheet from a workbook
(Excel 97-2003) if anyone is interested. It returns back a Variable in
SheetData automatically converts dates/times from the excel number
to the pick date time number. I haven't look at in years, beca
Yes, in SB+ editor the easiest way is to place your cursor on the character,
hit F6 for Find and replace, and as the replace character use @@VM
The help from the replace field gives the other values you can use:
The following symbols, if used, will be converted
prior to performing replacement:-
... and from a field on a screen just use the extend field key (Usually
Ctrl-End) twice to get into screen edit mode of the editor.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Friday, 10 Fe
37 matches
Mail list logo