tag a record

Steven Waters steven at abiederman.com
Wed Apr 27 15:21:00 PDT 2005


Jeff
Yes that is right. I want to tag the first instance
and the following ones. Also, It is index A eq field 1.
I will give it a try
This is the result that I want
P/N		mark
123-0		X
123-0		X
123-0		X
123-1
123-2
123-3		X
123-3		X
123-4

thanks
--------------------------

I don't think it will.  From what I understand of
Steve's description he wants the first instance of a
given value to be flagged if there are others
instances of that same value in the file.  This
technique will not flag the first instance.

Here is one way to do that.
(assumes field 1 is the key and index a is built on
this field)  BTW, this is untested.

::lookup sam = filename k=1 i=a -nx:
loop:::
:not sam:end:
:sam(@rn) eq @rn:getnext sam; goto loop:
:sam(1) ne 1:end
::12="X":
::end:

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest way to generate code for filePro exports and
imports.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list


More information about the Filepro-list mailing list