On 16/05/12 19:10, Wjhonson wrote:
Reality flavor must use the *stuff it all into the end* logic.
Don't have any Reality flavor accounts here.
I wonder if when you MATWRITE it, if it will truncate the trailing attributes?
Read up on the different types of arrays.
Pick does NOT have an
On 16/05/12 19:09, Wjhonson wrote:
You missed the last sub-part where the *size* of the array actually affects
your below.
In Information flavor
IF the DIM is smaller than the record, it will write all the trailing
attributes back out
However, IF the DIM is larger than the record, it
-users@listserver.u2ug.org
Sent: Wednesday, 16 May 2012, 2:51
Subject: Re: [U2] Trim trailing attributes off records
Sure but then *that* will not trim the trailing attributes.
If you dim it to hold every element, and then write it back you just get the
exact same problem with which you started
@listserver.u2ug.org
Sent: Wed, May 16, 2012 12:34 am
Subject: Re: [U2] Trim trailing attributes off records
The manual states :-
escription
se the MATWRITE statement to write data from the elements of a dimensioned
rray to a record in a UniVerse file. The elements of array replace any data
tored
F.VOC,DOG THEN
0013: PRINT CONVERT(@AM,!,C)
0014: END
Result:
DOG
DOG
DOG
-Original Message-
From: andy baumandyb...@yahoo.co.uk
To: U2 Users Listu2-users@listserver.u2ug.org
Sent: Wed, May 16, 2012 12:34 am
Subject: Re: [U2] Trim trailing attributes off records
Oh
The DIM has to be *larger* than the attribute size.
How curious.
-Original Message-
From: Dianne Ackerman dia...@aptron.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, May 16, 2012 10:36 am
Subject: Re: [U2] Trim trailing attributes off records
-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, May 16, 2012 12:40 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Trim trailing attributes off records
Oh
The DIM has to be *larger* than the attribute size.
How curious
?)
-Original Message-
From: David L. Wasylenko d...@pickpro.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, May 16, 2012 10:41 am
Subject: Re: [U2] Trim trailing attributes off records
Not if I remember correctly
o prevent lost data, attributes above the DIM size
What system are you running?
-Original Message-
From: David L. Wasylenko d...@pickpro.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, May 16, 2012 10:56 am
Subject: Re: [U2] Trim trailing attributes off records
I've just run a test...
OPEN FILE...
IM REC(100)
ATREAD REC
] On Behalf Of Wjhonson
Sent: Wednesday, May 16, 2012 1:05 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Trim trailing attributes off records
What system are you running?
-Original Message-
From: David L. Wasylenko d...@pickpro.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent
...@ladybridge.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Wed, May 16, 2012 10:58 am
Subject: Re: [U2] Trim trailing attributes off records
Hi all,
I have missed much of this thread so please ignore my response if it has all
een said before.
UV supports two types of dimensioned arrays which
@listserver.u2ug.org
Sent: Wed, May 16, 2012 11:05 am
Subject: Re: [U2] Trim trailing attributes off records
RELLEVEL
01 X
02 10.1.23
03 REALITY
04 REALITY.FORMAT
05 10.1.23
... david ...
David L. Wasylenko
resident, Pick Professionals, Inc
) 314 558 1482
l...@pickpro.com
Original Message
the trailing attributes?
-Original Message-
From: David L. Wasylenkod...@pickpro.com
To: U2 Users Listu2-users@listserver.u2ug.org
Sent: Wed, May 16, 2012 11:05 am
Subject: Re: [U2] Trim trailing attributes off records
RELLEVEL
01 X
02 10.1.23
03 REALITY
04 REALITY.FORMAT
05
attributes as it writes the data away
heers,
Andy
From: Wjhonson wjhon...@aol.com
o: u2-users@listserver.u2ug.org
ent: Thursday, 10 May 2012, 23:13
ubject: [U2] Trim trailing attributes off records
iven that you have a file with thousands of records, each with dozens of
railing
attributes as it writes the data away
heers,
Andy
From: Wjhonson wjhon...@aol.com
o: u2-users@listserver.u2ug.org
ent: Thursday, 10 May 2012, 23:13
ubject: [U2] Trim trailing attributes off records
iven that you have a file with thousands of records, each with dozens of
railing
: Fri, May 11, 2012 6:30 am
Subject: Re: [U2] Trim trailing attributes off records
How about :-
OPEN 'FILENAME' TO FILEVAR ELSE
STOPM 'Cannot open FILENAME'
END
IM REC(500)
ELECT FILEVAR
LOOP
WHILE READNEXT ID
MATREADU REC FROM FILEVAR,ID THEN
MATWRITE REC
...@sneakemail.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Tue, May 15, 2012 8:39 pm
Subject: Re: [U2] Trim trailing attributes off records
I know functional code was posted last week so I'm amazed that this
thread is still alive. I'll just add that in D3 we can do this:
matread dimrec from fv,key
the data away
Cheers,
Andy
From: Wjhonson wjhon...@aol.com
To: u2-users@listserver.u2ug.org
Sent: Thursday, 10 May 2012, 23:13
Subject: [U2] Trim trailing attributes off records
Given that you have a file with thousands of records, each with dozens of
trailing attributes which are empty
@listserver.u2ug.org
Sent: Fri, May 11, 2012 6:30 am
Subject: Re: [U2] Trim trailing attributes off records
How about :-
OPEN 'FILENAME' TO FILEVAR ELSE
STOPM 'Cannot open FILENAME'
END
IM REC(500)
ELECT FILEVAR
LOOP
WHILE READNEXT ID
MATREADU REC FROM FILEVAR,ID THEN
MATWRITE REC TO FILEVAR,ID
Given that you have a file with thousands of records, each with dozens of
trailing attributes which are empty.
How can you pick up the file and drop it back down with all those empties
trimmed off?
___
U2-Users mailing list
Subject: [U2] Trim trailing attributes off records
Given that you have a file with thousands of records, each with dozens of
trailing attributes which are empty.
How can you pick up the file and drop it back down with all those empties
trimmed off
those other fields were blank!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Thursday, May 10, 2012 5:21 PM
To: U2 Users List
Subject: Re: [U2] Trim trailing attributes off records
I would write
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Thursday, May 10, 2012 5:21 PM
To: U2 Users List
Subject: Re: [U2] Trim trailing attributes off records
I would write a little uniBasic program... to cleanse, purify, and rehydrate...
testing it first in a sandbox
I think there must be a trick way to do it.
-Original Message-
From: Bill Brutzman bi...@hkmetalcraft.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, May 10, 2012 3:22 pm
Subject: Re: [U2] Trim trailing attributes off records
I would write a little uniBasic program
Oh I see TRIM with a T
I never would have thought of that solution.
Thanks
-Original Message-
From: David L. Wasylenko d...@pickpro.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, May 10, 2012 3:27 pm
Subject: Re: [U2] Trim trailing attributes off records
25 matches
Mail list logo