1

I need to replace several encoding errors in just one task.

I have this:

enter image description here

If I change the encoding to UTF8, the "Label" field is correct, but the error passes to the other field, "name".

Instead of using this expressão several times, how to assemble the expression to do it all at once?

  • replace( "name" , 'ó','ó')
  • replace( "name" , 'é', 'é')
  • replace( "name" , 'â', 'â')
  • replace( "name" , 'ú', 'ú')
  • replace( "name" , 'á', 'á')
  • replace( "name" , 'ã', 'ã')
  • replace( "name" , 'ç', 'ç')
  • replace( "name" , 'õ', 'õ')
  • replace( "name" , 'Ã?', 'Á')
  • replace( "name" , 'í­', 'í')
  • replace( "name" , 'ê', 'ê')
  • replace( "name" , 'º', 'º')
3

You can simply nest the replace calls, using an expression like:

replace( replace( replace( "name" , 'â', 'â') , 'é', 'é') , 'ó','ó')

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.