Changing multiple characters in 1 word / cell

• SpeedSkaterFan

  SSCrazy

  Points: 2716

  More actions

  September 29, 2015 at 6:24 am

  #300993

  Hi all,

  I have a question that maybe is asked before. I have looked for the answer all over the place but I can’t find the exact 1 that solves my question.

  How can I replace more than 1, different character, in the same value / cell?

  e.g. ångermüller should become angermueller (å to a, and ü to ue)

  Multiple combinations of special characters are possible in 1 word: é and á, or ö and í etc etc

  Is there a way to do this?

  Thanks in advance

  Hein

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  September 29, 2015 at 6:56 am

  #1830126

  SpeedSkaterFan (9/29/2015)

  ---

  Hi all,

  I have a question that maybe is asked before. I have looked for the answer all over the place but I can’t find the exact 1 that solves my question.

  How can I replace more than 1, different character, in the same value / cell?

  e.g. ångermüller should become angermueller (å to a, and ü to ue)

  Multiple combinations of special characters are possible in 1 word: é and á, or ö and í etc etc

  Is there a way to do this?

  Thanks in advance

  Hein

  Use nested REPLACE:

  SELECT REPLACE(REPLACE(surname,'ü','ue'),'å','a')

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

• SpeedSkaterFan

  SSCrazy

  Points: 2716

  More actions

  September 29, 2015 at 7:16 am

  #1830137

  Hi Chris,

  Thank you for your reply.

  It works like a charm 🙂

  1 question if permitted: is there a limit to the number of replace functions you can use "in 1 go"?

  Anyway

  Thanks again

  Hein

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  September 29, 2015 at 7:46 am

  #1830146

  Don't know tbh - but I've used it a few times with 36.

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

• SpeedSkaterFan

  SSCrazy

  Points: 2716

  More actions

  September 29, 2015 at 7:54 am

  #1830151

  Sounds good,

  36 will do!

  Thanks again

  Hein