Hi,
You have to find the "greater" match, as example, tch is a single
letter, in Cyrillic, so you can't translate the t, then the c, then the h.
So, basically, the process could be iterative:
latinSequence cyrillic weight ' fields name
tch 'tch' 3
t 't' 1 ... data sample
SELECT TOP 1 *
FROM myTable
WHERE "Schostakovitch" LIKE "*", latinSequence , "*"
ORDER BY weight DESC;
will supply you with the best match found, tch, that you substitue and
replace by a blank. It would be preferable to use a recordset, with
decreasing order of weight, and, for each entry in the recordset, see if
there is a match in a substring of the word to "translate".
Schostakovitch --- find tch -- > 'tch' position 12
Schostakovi... -- find sch --> 'sch' position 1
....ostakov... -- find o , position 4,
etc.
Sure, nothing would have been found in position 2, and 3, since in cyrillic,
the word would have less letters than in Latin, so you can replace the
unmodified initial "null" in the result by empty string ( Replace(
myResult, chr(0), "" ) , as example. )
Cyrillic to Latin should be easier, since you can transform each Cyrillic
letter to its Latin "string", one cyrillic letter at a time, making a
concatenation of the strings you get while looping.
If that was not enough, remember that VBA is NOT UNICODE at all. Michael
Kaplan wrote a book that may help somehow: "Internalization with Visual
Basic"
Finally, as for "Schostakovitch", the "Latin" spelling is not uniform. In
English, you are more likely to see "Shostakovich" and in French,
"Chostakovitch"... (the start and the end is not the same). I don't know in
Dutch...but clearly, you have an interesting case here.
Hoping it may help,
Vanderghast, Access MVP
