RE: [U2] CSV output

2008-02-15 Thread Anthony Caufield 
Here are a couple of other examples I have seen float around.

Create dict item COMMA like this
>ED DICT POLI COMMA
COMMA
001:  I
002:  ","
003:
004:  ,
005:  1T

The use COMMA between every field listed:

>LIST file BUYER COMMA PO.DATE COMMA 1 COMMA 2 COMMA 

LIST file EVAL
"FIELD(@ID,"*",2):",":@RECORD<1>:",":@RECORD<2>:",":@RECORD<5>:",":@RECO
RD<6>" FMT "55L" COL.HDG "DATA" ID.SUPP

I got this courtesy of Mark over at AFS.


Tony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel
Sent: Monday, February 11, 2008 3:37 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] CSV output

If you want to make the DICT entry more readable, put CHAR(009) in field
2
of your TAB dictionary record.

Also, in field 4: if you put value marks between each tab then you can
have
three-line column headings (the UniVerse max) that will also be
correctly
tabbed:

CHAR(009)^253CHAR(009)^253CHAR(009)

Same methodology works for commas.  Just replace CHAR(009) with
CHAR(044).

-- Louie Bergsagel
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] CSV output

2008-02-14 Thread MAJ Programming 
An indirect answer would be to send an appropriate ESC sequence to the
screen's status row with the account/branch you are on.

I like accuterm where I can change the caption of the session. I usually put
the Account and Port number as many process use ported work files.

My 1 cent.
Mark Johnson
- Original Message -
From: "Dennis Bartlett" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, February 14, 2008 10:20 AM
Subject: RE: [U2] CSV output


> Hi
>
> Is there any way to change the > prompt to something like BR299>?
>
> It would really help to know where I am, whilst hopping from branch to
> branch.
>
> Thanks
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] CSV output

2008-02-14 Thread Ron Hutchings 
Are you remembering back to the "good old days" of Pr1me and Information when
that was user maintainable?



> From: [EMAIL PROTECTED]
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] CSV output
> Date: Thu, 14 Feb 2008 17:20:23 +0200
>
> Hi
>
> Is there any way to change the > prompt to something like BR299>?
>
> It would really help to know where I am, whilst hopping from branch to
> branch.
>
> Thanks
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/

_
Need to know the score, the latest news, or you need your Hotmail.-get your
"fix".
http://www.msnmobilefix.com/Default.aspx
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] CSV output

2008-02-14 Thread roy 
You can assign the prompt name to SYSTEM(4002) using basic and run it in the
Login paragraph.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Thursday, February 14, 2008 10:20 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] CSV output

Hi

Is there any way to change the > prompt to something like BR299>?

It would really help to know where I am, whilst hopping from branch to
branch.

Thanks
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] CSV output

2008-02-14 Thread Dennis Bartlett 
Hi

Is there any way to change the > prompt to something like BR299>?

It would really help to know where I am, whilst hopping from branch to
branch.

Thanks
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] CSV output

2008-02-11 Thread Louie Bergsagel 
If you want to make the DICT entry more readable, put CHAR(009) in field 2
of your TAB dictionary record.

Also, in field 4: if you put value marks between each tab then you can have
three-line column headings (the UniVerse max) that will also be correctly
tabbed:

CHAR(009)^253CHAR(009)^253CHAR(009)

Same methodology works for commas.  Just replace CHAR(009) with CHAR(044).

-- Louie Bergsagel
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] CSV output

2008-02-11 Thread Kevin Smith 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Thursday, February 07, 2008 1:55 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] CSV output

If you are into kewl, crazy short cuts (and other clever devices)

For those who are lazy to write fancy routines to create CSV files, I've
created two dict items, namely COMMA and QUOTE, as follows:


[snips]



For what it's worth,

I do something similar, but I use TAB.  My Dict item looks like:

0001: I

0002: " "

0003:

0004: TAB

0005: 1L

0006: S


Line two is actually "^009", but it shows " ".

Excel handles tab delimited well and I never worry about whether the
field is numeric.

My output line would be:

VAL1 TAB VAL2 TAB VAL3 TAB VAL4

Works well for me.

--Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/