Post reply

Finding accented characters

  • May 22, 2006 at 11:51 am

    #67437

    I need to find accented characters in words. 

    An example is Shell España Sa.  I would need to go through a column and find words that have accented characters like the ñ.

    I do not want to have to go character by character and was wondering if there is a way you can find words that have accented characters in them.
     
    I was thinking of something that would convert the word to an latin character set (Shell Espana Sa) and then compare it to the existing character set (Shell España Sa) and if it was different then it is accented.
     
    I really appreciate your time,
     
    Thanks,
    Ivan

  • May 23, 2006 at 2:49 am

    #639433

    Your approach seems right....the hard part though is finding a "an english-style collation" that will match up your accented characters.

    The alternative is to 'attempt' top remove all possible known accented characters, and replace with null....if the string shrinks you had accented characters...if it stays the same length...then you had none....crude...but maybe good enough for your requirements.

  • May 23, 2006 at 2:49 am

    #639432

    Your approach seems right....the hard part though is finding a "an english-style collation" that will match up your accented characters.

    The alternative is to 'attempt' top remove all possible known accented characters, and replace with null....if the string shrinks you had accented characters...if it stays the same length...then you had none....crude...but maybe good enough for your requirements.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply