Re: [U2] Trim trailing attributes off records

2012-05-18 Thread Wols Lists
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

Re: [U2] Trim trailing attributes off records

2012-05-18 Thread Wols Lists
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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread andy baum
-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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
@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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Dianne Ackerman
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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread David L. Wasylenko
-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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
?) -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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread David L. Wasylenko
] 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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
...@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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
@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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Dianne Ackerman
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

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wols Lists
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

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wjhonson
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

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wols Lists
: 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

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wjhonson
...@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

Re: [U2] Trim trailing attributes off records

2012-05-11 Thread andy baum
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

Re: [U2] Trim trailing attributes off records

2012-05-11 Thread Wjhonson
@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

[U2] Trim trailing attributes off records

2012-05-10 Thread Wjhonson
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

Re: [U2] Trim trailing attributes off records

2012-05-10 Thread Bill Brutzman
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

Re: [U2] Trim trailing attributes off records

2012-05-10 Thread David Wolverton
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

Re: [U2] Trim trailing attributes off records

2012-05-10 Thread David L. Wasylenko
[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

Re: [U2] Trim trailing attributes off records

2012-05-10 Thread Wjhonson
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

Re: [U2] Trim trailing attributes off records

2012-05-10 Thread Wjhonson
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