<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Stanley,<br>
<br>
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.<br>
<br>
Bruce<br>
<br>
<br>
On 10/21/19 10:25 AM, Stan-Lyn, Stanley Barnett via Filepro-list
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:b13e8321c0a2459a8f68d5d42c798676@stanlyn.com">
<pre class="moz-quote-pre" wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:don@donstacklehawaii.com"><don@donstacklehawaii.com></a>
Sent: Sunday, October 20, 2019 2:30 AM
To: Stan-Lyn, Stanley Barnett <a class="moz-txt-link-rfc2396E" href="mailto:stanley@stanlyn.com"><stanley@stanlyn.com></a>
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: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20191021/bdd327b3/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20191021/bdd327b3/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<br /><br />
<hr style='border:none; color:#909090; background-color:#B0B0B0; height: 1px; width: 99%;' />
<table style='border-collapse:collapse;border:none;'>
<tr>
<td style='border:none;padding:0px 15px 0px 8px'>
<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">
<img border=0 src="https://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo" />
</a>
</td>
<td>
<p style='color:#3d4d5a; font-family:"Calibri","Verdana","Arial","Helvetica"; font-size:12pt;'>
This email has been checked for viruses by Avast antivirus software.
<br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a>
</p>
</td>
</tr>
</table>
<br />
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body>
</html>