Welcome to Emulationworld

Forum Index | FAQ | New User | Login | Search

Make a New PostPrevious ThreadView All ThreadsNext ThreadShow in Flat Mode*

SubjectRe: thanks both! Reply to this message
Posted bysmf
Posted on10/08/04 03:13 AM

So the code is made up entirely from the description? Yuck, it would be much better to replace the description with a lookup into another table. Or is this what you're trying to do?

If it were me, I'd have the correct descriptions in one table and generate the list of descriptions that weren't in the table & do replacements for eg. BK -> BOOK until the list of exceptions was empty.

If you don't have a list of codes/descriptions in a table then it makes it harder, soundex style searches can be useful but it depends on whether you have lots of words that sound alike.

How many codes are you talking about anyway?


Entire Thread
Subject  Posted byPosted On
*text pattern recognition  newsdee10/06/04 06:37 PM
.*Re: text pattern recognition  Terry Bogard10/07/04 05:49 AM
..*Re: text pattern recognition  smf10/07/04 03:11 PM
...*thanks both!  newsdee10/07/04 04:07 PM
.....Re: thanks both!  smf10/08/04 03:13 AM
.....*Re: mapping codes  newsdee10/09/04 11:36 AM
......*Re: mapping codes  Videoman10/16/04 03:54 PM