How to replace foreign characters

[JM39]

Hello everyone

I have some data with foreign characters and I need to try and replace those. Example:

ARMANDO BAUTISTA GARCÍA - this is what I have in my source data

ARMANDO BAUTISTA GARCIA - this is what I want in the output

Is there a way I can achieve this in the tmap? TIA

[gjeremy1617088143 · Accepted solution]

Hi, maybe you could use : TalendString.removeAccents(your String)

else you could import in a tJava advanced settings:

import java.text.Normalizer;

and use in a tmap :

Normalizer .normalize((your string), Normalizer.Form.NFD) .replaceAll("[^\\p{ASCII}]", "");

Send me love and kudos

[JM39]

Perfect, thank you!

TalendString.removeAccents(your String) - this worked 🙂