|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
|
[x]
The Solution Rating System
|
|
| With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating. - The Grade of the Solution
- The Zone Rank of the Expert Providing the Solution
- The Number of Author and Expert Comments
- The Number of Experts Contributing
- The Feedback of the Community
Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site. If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
|
|
|
|
Asked by ShadowIT in MS SQL Server, Microsoft Access Database, Databases Miscellaneous
Hello Experts,
I am mining data from an ERP system. The users of this system are not using the ERP's part number field and are instead entering the part numbers, along with other data (model, part description), in a free form text description field within the ERP's PO line items. As a result I have a ton of user embellishments occurring within the data set (ex. part # 12345-AB, P/N#1234AB...sometimes the part numbers are in the middle or at the end of the string) etc. So I need a way to extract the part numbers from this string of data. I've considered SoundEx but just cant seem to wrap my mind around a design approach. What I could do is have each supplier provide me a valid list of part numbers and then attempt to use SoundEx to perform the comparison. Then, and this is just conceptual, construct some sort of UI to allow users to review/improve the accuracy of the results by overriding the automated weighing results when appropriate. Please understand that I am contending with legacy/existing data...it is what it is. Please, comments like, "why don't they just use the part number field?" aren't helpful. The path forward to resolve this issue going forward is being addressed, but I still need some way to contend with the existing data...such as it is. Thank you
p.s. It should be noted that the part numbers are numeric, alpha and alpha-numeric. We're talking ~15 thousand suppliers.
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625
