exact match

Nancy Palmquist nlp at vss3.com
Tue Mar 23 14:09:00 PST 2004


Steve Waters wrote:
> 
> Hello,
> 
> I have a field that is (20,ALLUP).
> If P/N 705-7v9-34-S comes in house the processing below still runs
> telling the user that this P/N needs a mod.
> How do I get an exact match @wlf1 ?
> 
> 

Make sure field 1 and the literal are the same length and then do the
following:

> @WLF1 If: 1&"|~" eq "705-7v9|~"

Append with & one or two characters in my example I used |~   (pipe
tilde) and do the same to the string you are matching.  It will always
match exactly even if longer and shorter strings are used.


"10~"  ne "10   ~"

But 

"10" is equal to "10   "  

in filePro language.

Whenever I am looking at a code field that could have data of varying
lengths, I append a character when testing and requiring an exact match
of data.

Nancy
Hope that helps.
>       Then: beep; msgbox "P/N 705-7v9 needs Mod kit 34-S!"
> 
> Thanks,
> Steve
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list


-- 
Nancy Palmquist 
Virtual Software Systems
PHONE: (412) 835-9417			Web site:  http://www.vss3.com



More information about the Filepro-list mailing list