locked
Removing accents from names RRS feed

  • Question

  • firstname

    = dbo.dsi_fnRemoveChars('''.,/-#''',replace(Upper(pnamefirst) ,' ', '')),

    How do I add in to remove accents as well from letters?

    Wednesday, June 11, 2014 5:00 PM

Answers

  • dsi_fnRemoveChars(...

    That's not a system function and as long as we don't know the code of this UDF "dsi_fnRemoveChars", no one can tell you what you have to modify to get the expected result.

    Please have a look at this solved post; may it works for you, too: Accented Words Mapping to English Alphabet


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Naomi N Wednesday, June 11, 2014 5:52 PM
    • Marked as answer by Fanny Liu Thursday, June 19, 2014 9:58 AM
    Wednesday, June 11, 2014 5:18 PM