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 recor

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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Dianne Ackerman
e the trailing attributes? -Original Message- From: David L. Wasylenko To: U2 Users List 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. Wasy

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
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- rom: u2-users-boun...@listserver.u2u

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
Users List' 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, for the purpose of this iscussi

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 To: U2 Users List Sent: Wed, May 16, 2012 10:56 am Subject: Re

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
What system are you running? -Original Message- From: David L. Wasylenko To: U2 Users List 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 FROM FILE... RT REC(1) RT

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Martin Phillips
Hi all, I have missed much of this thread so please ignore my response if it has all been said before. UV supports two types of dimensioned arrays which, for the purpose of this discussion, I will call "Information style" and "Pick style" because of their origins. Which one you get is flavour d

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread David L. Wasylenko
I've just run a test... OPEN "FILE"... DIM REC(100) MATREAD REC FROM FILE... CRT REC(1) CRT REC(100) END ALL extra attributes are in REC(100) ... David... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinf

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
?) -Original Message- From: David L. Wasylenko To: U2 Users List 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 are stuffed as dynamic array lements within the

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
Oh The DIM has to be *larger* than the attribute size. How curious. -Original Message- From: Dianne Ackerman To: U2 Users List Sent: Wed, May 16, 2012 10:36 am Subject: Re: [U2] Trim trailing attributes off records Will, your code gets the results you're seeing w

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Dianne Ackerman
quot;DOG" THEN 0010: MATWRITE R.DOG ON F.VOC,"DOG" 0011: END 0012: READ C FROM F.VOC,"DOG" THEN 0013: PRINT CONVERT(@AM,"!",C) 0014: END Result: DOG DOG DOG!!!! -----Original Message----- From: andy baum To: U2 Use

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread Wjhonson
: DOG DOG DOG -----Original Message- From: andy baum To: U2 Users List 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

Re: [U2] Trim trailing attributes off records

2012-05-16 Thread andy baum
__ From: Wjhonson To: u2-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 ju

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wjhonson
ony Gravagno <3xk547...@sneakemail.com> To: u2-users 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 fr

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread David L. Wasylenko
to:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, May 15, 2012 10:39 PM To: u2-users@listserver.u2ug.org 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

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Tony Gravagno
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 else null dynrec = dimrec write dynrec on fv,key Perhaps non-intuitively, the assignment of a dimensioned array to a non-dimensioned vari

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wjhonson
. -Original Message- From: Wols Lists To: u2-users Sent: Tue, May 15, 2012 5:59 pm Subject: Re: [U2] Trim trailing attributes off records On 15/05/12 20:50, Wjhonson wrote: Information Flavor No spaces in the fields, nothing in them at all, just a line of attribute arks with

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wols Lists
aces ...) > You can pull the same stunt for PICK mode, just remember the extra > ntries will end up in the last element of the array. > Cheers, > ol >> > > > -Original Message- > From: andy baum > To: U2 Users List > Sent: Fri, May 11, 2012 6:30 am &

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wjhonson
that Andy's trick of just matreading and then matwriting didn't work. You have to set Rec(0) to nothing in between -Original Message- From: Wols Lists To: u2-users Sent: Tue, May 15, 2012 12:40 pm Subject: Re: [U2] Trim trailing attributes off records On 11/05/12 17:36,

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wols Lists
REC(500) > > ELECT FILEVAR > LOOP > WHILE READNEXT ID >MATREADU REC FROM FILEVAR,ID THEN > MATWRITE REC TO FILEVAR,ID >END > REPEAT > > ND > > ATWRITE trims trailing blank attributes as it writes the data away > > heers, > Andy >

Re: [U2] Trim trailing attributes off records

2012-05-11 Thread Wjhonson
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 END REPEAT ND

Re: [U2] Trim trailing attributes off records

2012-05-11 Thread andy baum
tes as it writes the data away Cheers, Andy From: Wjhonson 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 empt

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 To: U2 Users List Sent: Thu, May 10, 2012 3:27 pm Subject: Re: [U2] Trim trailing attributes off records FILE.LIST="CUSTOMER" ILE.LIST<-1>=&

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 To: U2 Users List Sent: Thu, May 10, 2012 3:22 pm Subject: Re: [U2] Trim trailing attributes off records I would write a little uniBasic program... to cleanse, purify, and rehydrate... esting it

Re: [U2] Trim trailing attributes off records

2012-05-10 Thread David L. Wasylenko
resident, Pick Professionals, Inc -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 a litt

Re: [U2] Trim trailing attributes off records

2012-05-10 Thread David Wolverton
but the record stops at 185 because 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 attr

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

[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 U2-Users@listserver.u2ug.or