Need Distinct Values

[Bob Stockler]

Top Post . . .

Use GAWK instead ? ? ?

Bob

Walter Vaughan wrote (on Tue, Jan 16, 2007 at 05:23:24PM -0500):

| I cannot believe I cannot figure this out.
| 
| I need unique distinct values. I've done this a million times, but with a 
| smaller number of items, using a dummy field to determine and toss out 
| dupes.
| 
| I have about 17K records with two fields, one 10 characters and one 2.
| I need to create an xml export with unique values.
| 
| Of course as you can see from the following code snippit, it's only good 
| for 2,666 values and I need seven times that.
| 
|   1  -------   -   -   -   -   -   -   -   -
|        . If:
|        Then: export ascii dec=/tmp/test3.xml
|   2  -------   -   -   -   -   -   -   -   -
|        . If: 6 eq ""
|        Then: end
|   3  -------   -   -   -   -   -   -   -   -
|        . If: 'combine fields ala MK12-2345-89
|        Then: pm=mid(1,"1","2"){6
|   4  -------   -   -   -   -   -   -   -   -
|        . If: zm co pm
|        Then: end
|   5  -------   -   -   -   -   -   -   -   -
|        . If:
|        Then: zm(32000,*,g)=zm{pm{"";
|   6  -------   -   -   -   -   -   -   -   -
| xmlmake. If: 'start building the export
| 
| And as expected I am getting duplicate keys in my xml export since "ZM" 
| can't be made larger than 32K. The XML records are way wider than 255 
| characters so I can't use a report format.
| 
| How else can you remove duplicate output data at runtime?
| --
| Walter
| _______________________________________________
| Filepro-list mailing list
| Filepro-list at lists.celestial.com
| http://mailman.celestial.com/mailman/listinfo/filepro-list

-- 
Bob Stockler  +-+  bob at trebor.iglou.com  +-+  http://members.iglou.com/trebor