Advanced search-method

elwin68
Member Posts: 153
Does anyone have any experience with search-methodes?
I'm importing customer-names within Navision. When for example the name ‘smith’ is imported, the following names should be found: smith, smyth, smit.
Is there a solution for this problem.
Thanks in advance,
Elwin van den Bergh
I'm importing customer-names within Navision. When for example the name ‘smith’ is imported, the following names should be found: smith, smyth, smit.
Is there a solution for this problem.
Thanks in advance,
Elwin van den Bergh
0
Answers
-
Look at this page: http://www.outfitters.com/genealogy/what-soundex.html
It describes the algorithm for the Soundex code.
<start quote>
The Soundex code is an indexing system which translates names into a 4 digit code consisting of 1 letter and 3 numbers. The most familiar application of Soundex is its use by the US Bureau of the Census to create an index for individuals listed in the US census records after 1880.
The advantage of Soundex is its ability to group names by sound rather than the exact spelling. Take, for example, the name Paine. A census recorder or a family might spell the name variously as Paine, Pain, Pane, Payn, Payne, etc. The Soundex code for all of these is P500.
<end quote>No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0 -
Thanks for the answer. It's working great.
I wonder if there is a possibility to find names with a mistype in it.
Example: The imported name is: davidson
The names searched for: davitson, davidon
I know it isn't possible for 100%.
Elwin van den Bergh0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions