I use a posh manufacturing mr4 keyboard decoder to connect scales to a thin
client running a terminal emulator. it functions as a keyboard wedge. We
have used them for 10 years with no problems.
Bill
George Hammerle wrote:
Hello,
Has anyone used a Serial to Ethernet Device
Does anyone know a trick to achieve the equivalent of
SELECT filename SAVING UNIQUE fieldname
When fieldname is the name of a multivalued field, and I want a list of all
the unique values for that field?
The syntax above does not explode the values, but just looks at the whole field.
I
QSELECT ...SAVING... evidently does not allow UNIQUE... (Universe)
Still, it looked hopeful.
-Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 12:56 PM
To:
You have two issues.
One is to create a list from an exploded multi-value
The other issue, is to dedupe that list.
Without using something like REFORMAT I don't think you can get the two issues
resolved at once.
Qselect does not allow Unique
So
QSELECT MYFILE SAVING 2
will explode the
I usually get my exploded list and then DEDUPE using the following:
LOCATE VALUE.TO.FIND IN UNIQUE.LIST BY AL SETTING POS ELSE
UNIQUE.LIST = INSERT(UNIQUE.LIST,1,POS,0,VALUE.TO.FIND)
END
This puts everything in a nice ARRAY called UNIQUE.LIST, I then can use a FOR
loop to loop through as
This does present a challenge,
The following (non-portable solution works)
:ED VOC MUNIQUE
5 lines long.
What's the syntax to use MUNIQUE below in a SELECT?
The following (non-portable solution works)
:ED VOC MUNIQUE
5 lines long.
What about ...
: P
0001: PA
0002: QSELECT C2,file * SAVING C3,field number
0003: SAVE.LIST UNIQUE
0004: GET.LIST UNIQUE
That works beautifully George, thanks for the tip! I've never used the
MERGE.LIST command before, I assume the line you have
0005: MERGE.LIST 1 UNION 1
basically take the list #1 and shakes out the unique values?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
MERGE.LIST Sorts automatically,
The UNION does the DEDUPING
The 1 union 1 - says to union of list#1 with list#1 (itself)
Otherwise:
MERGE.LIST # ACTION # TO #
Where ACTION = (UNION, INTERSECT or DIFF)
And the TO # will save the results to that list# (if it's not specified, the
default list
Now thinking about it, I think MERGE.LIST always does sort and deduping
regardless of which ACTION you use.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, May 17, 2012 5:05 PM
To: U2
UNION would definely be an alternative, but doing it against a needlessly long
second list offends my Scotch genes. It is possible to create an active, zero
length, selectlist programmatically, so perhaps I should write a little command
to do that and and a MERGE.LIST UNION against it.
The description of UNION is a bit confusing with regards to the way this works:
UNION - list3 contains all elements from list1 and all elements from list2
that are not in list1.
From the HELP description I would think it wouldn't work, for example:
list 1 = 1,1,2,2,3,4,5
list 2 = 1,4,6,8
To be honest, it's fast, really fast. It would probably take you longer to
create the zero length list than
It would save in any processing time.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick
Rick,
I'm not following you.. There isn't a 'second list'.. it's one list that is
being manipulated (George's example only uses 1 list) which he calls 1 and
UNIQUE (interchangeably) .
Perhaps you can show us what you're referring to so we can see an example.. I
thought George's solution was
I may have confused you when I said the UNION does the deduping - Sorry.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, May 17, 2012 5:15 PM
To: U2 Users List
Subject: Re: [U2] SAVING
No worries, it all makes perfect sense now ;)
Thanks!
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Thu, 17 May 2012 16:16:25 -0500
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
I may have confused you when I said the UNION does the deduping - Sorry.
I do not know the guts of the MERGE.LIST command, but it may well sort and
dedupe each list prior to performing the merge /union operation. But, for the
sake of argument, suppose that, for a union, MERGE.LIST creates a single
internal hashmap and makes an entry for each unique item in list1
Okay, I timed the difference with 1,400,000 or so record ids on a relatively
old SUN box.
Union against an identical list 64930 milliseconds of CPU
Union with a blank list 31890 ms.
The result is the same.
The timings were started after both lists were instantiated, and are for the
Deduping BASIC program, short version:
0001: SELECT '' TO 1
0002: EXECUTE 'MERGE.LIST 0 UNION 1'
0003:END
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
20 matches
Mail list logo