Need Distinct Values

Walter Vaughan wvaughan at steelerubber.com
Tue Jan 16 14:23:24 PST 2007


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


More information about the Filepro-list mailing list