Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fuzzy searching with the Fox
Message
From
23/09/2009 09:54:20
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
22/09/2009 16:06:49
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01425615
Message ID:
01425730
Views:
73
>>>Any way to do fuzzy searching in VFP.
>>>
>>>Preferably in french ;-)
>>>
>>>If you can provide some code then I guess I can adapt for french.
>>
>>What exactly are you trying to do? For indexed searches there is GOTO RECNO( 0 ) / SET NEAR. For character strings there is SOUNDEX() / DIFFERENCE().
>
>I'm trying to do the following;
>
>If user enters he's looking for "Rene" I want to find "Rene" and "René" for example.

Check whether they are equal or not in different collation sequences. Set Collate to {apply one at a time}, and check whether "Rene" = "René". In some of them string comparison may be case blind.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform