In a message dated 4/17/2004 4:06:38 PM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> Another standard is that used by the UNLOAD.FILE.B program and its
> corresponding bulk loader utility loadfile.
> Here, a line beginning with other than a TAB character or one of "/}", "/]"
> or "\{" co
Another standard is that used by the UNLOAD.FILE.B program and its corresponding bulk
loader utility loadfile.
Here, a line beginning with other than a TAB character or one of "/}", "/]" or "\{"
contains a key value, a tab and the first element of the data dynamic array.
A line beginning with a t
In a message dated 4/17/2004 10:55:07 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> You expect delimiters? When I started in computers, our binary only had
> zeros - and we were glad to have them!
> The thing about MV or flat really comes down to a case-by-case to my way
> of think
In a message dated 4/17/2004 6:14:32 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> Perhaps we should all capitulate & start to use flat CSV files ?
>
> Ross Ferris
> Stamina Software
> Visage â an Evolution in Software Development
Having created a system on a MAC that does use flat CSV
Let's not forget the lower case L for 1 (one).
- Original Message -
From: "Larry Hiscock" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Saturday, April 17, 2004 2:08 PM
Subject: RE: UV to Text Conversion Standard?
>
Behalf Of Results
Sent: Saturday, April 17, 2004 10:54 AM
To: U2 Users Discussion List
Subject: Re: UV to Text Conversion Standard?
Ross,
>Perhaps we should all capitulate & start to use flat CSV files ?
You expect delimiters? When I started in computers, our binary only had
zer
Ross,
Perhaps we should all capitulate & start to use flat CSV files ?
You expect delimiters? When I started in computers, our binary only had zeros
- and we were glad to have them!
The thing about MV or flat really comes down to a case-by-case to my way of
thinking. I generally prog
oss Ferris
Stamina Software
Visage – an Evolution in Software Development
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Geoffrey Mitchell
>Sent: Saturday, 17 April 2004 4:06 AM
>To: U2 Users Discussion List
>Subject: Re: UV to Text Conv
27;t fix it"
Stu Pickles
>-Original Message-
>From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 16, 2004 12:06 PM
>To: U2 Users Discussion List
>Subject: Re: UV to Text Conversion Standard?
>
>
>To my knowledge, no. Not in Universe anyway.
in Alfke
> > Calgary, Alberta Canada
> >
> > "Just because something isn't broken doesn't mean that you can't fix it"
> >
> > Stu Pickles
> >
> >
> > >-Original Message-
> > >From: [EMAIL PROTEC
Message-
> >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> >Sent: Friday, April 16, 2004 9:26 AM
> >To: [EMAIL PROTECTED]
> >Subject: Re: UV to Text Conversion Standard?
> >
> >
> >In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time,
> &g
Colin Alfke
Calgary, Alberta Canada
"Just because something isn't broken doesn't mean that you can't fix it"
Stu Pickles
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 16, 2004 9:26 AM
>To: [EMAIL PROTECTED
In a message dated 4/15/2004 6:12:27 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> Will - your posting mentioned CONVERT(VM,"|", mydata) - my version of UV
> does not seem to like that.
Jim, Excel CAN read comma delimited data. Ask again why the requirement for
fixed length? Excel DO
In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> You can use the UniVerse ODBC Driver to pull the data from UniVerse to
> Excel, using correct dictionaries UniVerse will normalise the data and sort
> out the VM and SVM for you.
Jonathan can you give a
Try @VM instead of VM. It will work.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
[snip]
Will - your posting mentioned CONVERT(VM,"|", mydata) - my version of UV
does not seem to like that.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mail
Of [EMAIL PROTECTED]
Sent: Thursday, 15 April 2004 23:11
To: [EMAIL PROTECTED]
Subject: re: UV to Text Conversion Standard?
SNIP...
Will - your posting mentioned CONVERT(VM,"|", mydata) - my version of UV
does not seem to like that.
SNIP...
--
u2-users mailing list
[E
Thanks to all that replied to my posting. I read a few replies suggesting
that I use XML and not fixed length. As I stated in my original note,
fixed length was a requirement. I guess I should have supplied more
information.
Part of my company was recently sold. The buying company has asked that
April 14, 2004 11:14 AM
To: U2 Users Discussion List
Subject: Re: UV to Text Conversion Standard?
In a message dated 4/14/2004 12:08:04 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> But they all support Cedarville DOWNLOAD, which works better than the
> TOXML keyword anyway. It wi
In a message dated 4/14/2004 12:08:04 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> But they all support Cedarville DOWNLOAD, which works better than the
> TOXML keyword anyway. It will catch up, I'm sure, but for now, DOWNLOAD
> is more flexible. AFAIK neither of them lets you create X
Jim;
As you may have noticed from the replies: there are a number of ways to do
this. Depending on the number of files/fields and the frequency you want to
do this, and any connection options you currently have will affect your
final choice.
You may want something powerful like a data transformat
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Brian, not every implementation supports TOXML keyword
> Will
But they all support Cedarville DOWNLOAD, which works better than the
TOXML keyword anyway. It will catch up, I'm sure, but for now, DOWNLOAD
is
EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: 14 April 2004 16:34
To: [EMAIL PROTECTED]
Subject: Re: UV to Text Conversion Standard?
In a message dated 4/14/2004 8:29:24 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> If you are normalizing the data, you can dump the data int
I use it all the time using our inhouse utilities and it works well. I
do remember something strange in the totalling logic of sylk, something
about being relative to the current row I believe.
Rich
Chuck Mongiovi wrote:
The best way to importing multiline cells into Excel is to generate a HTM
> The best way to importing multiline cells into Excel is to generate a HTML
> file that represents the spreadsheet cells as an HTML table. You can then
> import line breaks using the HTML tag. It requires a few lines of
code,
> but it is pretty trivial.
Has anyone ever tried using the SYLK forma
In a message dated 4/14/2004 8:29:24 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> If you are normalizing the data, you can dump the data into an XML format
> using an exploded SORT with the TOXML keyword. You can then load that
> directly, at least if you are running Excel 2003.
>
Bri
Jim,
I don't see why on earth you want to use fixed length data with Excel.
Do you need to normalize the data or are you intending to use multi-line
cells?
The best way to importing multiline cells into Excel is to generate a HTML
file that represents the spreadsheet cells as an HTML table. You
You might look at Cedarville Download (ftp.cedarville.edu). Its a free
utility written in UD/UV Basic that will output CSV, HTML, XML, and DIF
files (all of which are directly readable by Excel) from command line
queries.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Jim the short answer is you can't.
You can however strip all non printable characters by passing the data
through OCONV(mydata, "MCP")
This turns all non printables into the period character "."
To seperate your fields, pass the data through a conversion like
CONVERT(VM,"|", mydata)
which will tu
First off, what are you planning to do with the data once you have it in
Excel? In most cases it won't be useful unless you explode/flatten the
data out. We have a few (UniData) solutions for turning LIST/SORT/CT
output into symbolic link/html(with or without table view)/csv files,
and use SB
29 matches
Mail list logo