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 Conversion Standard?
To my knowledge, no. Not in Universe anyway. I *think* (from the docs,
I've never played
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
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?
You expect delimiters? When I started
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 files
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 \{ contains a
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
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 DOES
-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. I *think* (from
the docs,
I've never played
:[EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 8:34 AM
To: [EMAIL PROTECTED]
Subject: UV to Text Conversion Standard?
I am hopeful someone can offer me some guidance.
I have to move data off of my Universe system and send it to a PC for
inclusion in a Excel Spreadsheet.
Some background:
Source
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
[EMAIL PROTECTED]
http://www.oliver.com
I am hopeful someone can offer me some guidance.
I have to move data off of my Universe system and send it to a PC for
inclusion in a Excel Spreadsheet.
Some background:
Source data is alpha/ numeric and contains VM's, SVMs and TM
Source data fields are variable lengths
Requirements:
Output
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
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 turns
]
Sent: Wednesday, April 14, 2004 7:34 AM
To: [EMAIL PROTECTED]
Subject: UV to Text Conversion Standard?
I am hopeful someone can offer me some guidance.
I have to move data off of my Universe system and send it to a PC for
inclusion in a Excel Spreadsheet.
Some background:
Source data is alpha
2003.
Or - blatant plug - if you are doing this repeatedly, you might want to take
a look at mvQuery.
Brian
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: 14 April 2004 15:34
To: [EMAIL PROTECTED]
Subject: UV to Text Conversion
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.
Brian,
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 br tag. It requires a few lines of
code,
but it is pretty trivial.
Has anyone ever tried using the SYLK
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
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 into an XML
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
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 8:34 AM
To: [EMAIL PROTECTED]
Subject: UV to Text Conversion Standard?
I am hopeful someone can offer me some guidance.
I have to move data off of my Universe system and send it to a PC for
inclusion
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 will catch up
22 matches
Mail list logo