Home All Groups Group Topic Archive Search About
Author
9 Mar 2006 10:08 PM
lyudmilal
I have a list of last names that can be in different languages:
chinese, english, russian, german, etc.  Different format need to be
applied only for last names in chinese.  For this purpose, I need to
check if last name contains chinese characters.  Any ideas how to do it
(it should be data related check)?

Thank you,
Ludmila

Author
10 Mar 2006 1:04 PM
Tony Proctor
I would suggest looking at the Unicode standard and seeing which bands are
reserved for those characters. Then compare the Unicode character codes to
see if they're in those bands. NB: Use ChrW$(), not Chr$(). The former
returns the Unicode character code whereas the latter returns the ANSI
character code

    Tony Proctor

<lyudmi***@ungerboeck.com> wrote in message
Show quoteHide quote
news:1141942103.473323.80280@e56g2000cwe.googlegroups.com...
> I have a list of last names that can be in different languages:
> chinese, english, russian, german, etc.  Different format need to be
> applied only for last names in chinese.  For this purpose, I need to
> check if last name contains chinese characters.  Any ideas how to do it
> (it should be data related check)?
>
> Thank you,
> Ludmila
>