?
.
The Instr function will return an incorrect substring position for
values containing some Japanese characters. While most Japanese
characters are fine, some characters such as ã‚°(GU - \u30b0) and
プ(PU \u30D7) will be counted as two characters by the Instr function
offsetting the returned position incorrectly. Most importantly, the
returned position is incorrect even when passed as an argument to the
Mid function. Most other Japanese characters function correctly when
passed to the Instr function.
For example,
Mid( ‘グab’, Instr(‘グab’, ‘a’), 1)
will incorrectly return ‘b’. With most other Japanese characters,
‘a’ would be correctly returned.
Is this a known problem? Is there some way to work around this?
thanks
mike
values containing some Japanese characters. While most Japanese
characters are fine, some characters such as ã‚°(GU - \u30b0) and
プ(PU \u30D7) will be counted as two characters by the Instr function
offsetting the returned position incorrectly. Most importantly, the
returned position is incorrect even when passed as an argument to the
Mid function. Most other Japanese characters function correctly when
passed to the Instr function.
For example,
Mid( ‘グab’, Instr(‘グab’, ‘a’), 1)
will incorrectly return ‘b’. With most other Japanese characters,
‘a’ would be correctly returned.
Is this a known problem? Is there some way to work around this?
thanks
mike