Como remover acentos da coluna MUNICIPIOS

Maia_Marcello · September 10, 2021, 6:43pm

Não estou sabendo como retirar acentos da coluna MUNICIPIO
removeDiacritic("$$")???

Como devo fazer ai?

bruno29a · September 10, 2021, 7:45pm

Hi @Maia_Marcello , you can use the string Normalizer to do this. Unfortunately, I don’t know how to import the library in the Column Expressions.

Consequently, I did it in Java via the Java Snippet:

Just need to import the java.text.Normalizer:
import java.text.Normalizer;

And the code is just this:

String normalized = Normalizer.normalize(c_column1, Normalizer.Form.NFD);
out_removedaccent = normalized.replaceAll("[^\\p{ASCII}]", "");

EDIT: Here’s the test workflow in case you need it: Remove accents.knwf (6.6 KB)

ipazin · September 10, 2021, 9:16pm

there is function removeDiacritic() in String Manipulation node.

Br,
Ivan

bruno29a · September 10, 2021, 11:33pm

Hi @ipazin , oh there is? I did not notice it. I was about to suggest that we have some sort of function like this lol.

Thanks for the info

serafimromao · March 14, 2023, 3:58pm

Boa tarde caríssimos.
Estou com dificuldade de eliminar alguns atributos de uma coluna.

serafimromao · March 14, 2023, 4:03pm

Boa tarde caríssimos.
Estou com dificuldade de remover alguns conteudo na coluna data. Pretendo apenas a data que esta no fim.