Retrieving information from lookup file

Nancy Palmquist nancy.palmquist at vss3.com
Mon Oct 21 09:50:51 PDT 2019


Stanley,

It is best when you can match exactly or make it close to the item but 
"contains" might be anywhere in the description so it will have to 
search from beginning to end.  Fuzzy does that and presents the best 
matches at the beginning.  If what they provided to match is specific, 
it does great.  If what they provide is vague, you will be unlikely to 
get anything useful.

For example, if I have a description that says "20 ft fishing pole" and 
I just provide "pole" or "20 ft" depending on what is in your list you 
could get all kinds of things other than a fishing pole.

Try it - that is the only way to know if it will work for your problem.

Nancy

On 10/21/2019 10:54 AM, Bruce Easton via Filepro-list wrote:
> Stanley,
>
> I believe the fuzzy should be reliable, but may present the user with 
> more matches than you wish them to see.  I can't remember if I've 
> tried this, but you may be able to use a fuzzy browse that also 
> incorporates "drop" processing (specified within the browse lookup 
> command) to drop records from showing in the browse that don't match 
> the desired pattern exactly. I think this method would not be any 
> slower than using processing to parse each record to determine if the 
> desired pattern is present - it would likely be faster.  I think it's 
> worth exploring.
>
> Bruce
>
> On 10/21/19 10:25 AM, Stan-Lyn, Stanley Barnett via Filepro-list wrote:
>> Hi Don,
>>
>> Its been over 20 years since I’ve tried using a fuzzy search. Not 
>> sure why I abandoned yet.  Have you found it to be reliable, meaning 
>> you will always get the correct matches?  Would it return records 
>> containing a string reliably, as I have never expected it to do that 
>> at all.  In the meantime, I will look at it again.  Speed is going to 
>> be very important for this use case.  Image a clerk entering a 20 
>> line item invoice where they would be doing a search in each line 
>> item…  I feel a lot of user pain…   What has been your experience?
>>
>> Thanks,
>> Stanley
>>
>>
>>
>> From: Don Becker <don at donstacklehawaii.com>
>> Sent: Sunday, October 20, 2019 2:30 AM
>> To: Stan-Lyn, Stanley Barnett <stanley at stanlyn.com>
>> Subject: Retrieving information from lookup file
>>
>> Hi Stanley,
>>
>> Regarding your need to retrieve data from a long field, have you 
>> tried doing a fuzzy browse look up?
>> You can specify the number of records to list in the browse.
>>
>> The draw back is that if your file is large, it may take a few 
>> seconds to display your information.
>>
>> Don Becker
>>
>> (808) 554-8565
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: 
>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20191021/bdd327b3/attachment.html>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-- 
Nancy Palmquist         MOS & filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20191021/b1d45dd1/attachment.html>


More information about the Filepro-list mailing list