topic Re: How to replace foreign characters in Talend Studio

How to replace foreign characters

JM39 — Fri, 15 Nov 2024 23:16:32 GMT

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 — Tue, 25 Jan 2022 10:12:34 GMT

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 — Tue, 25 Jan 2022 11:53:04 GMT

Perfect, thank you!

TalendString.removeAccents(your String) - this worked 🙂