Skip to Content
0

Handling Characters

Feb 03, 2017 at 02:16 PM

63

avatar image

Hi Experts,

I have a source .csv File which has employee Details but some of them are local German names and i want them to be converted to equivalent English Names. For Eg

Stefan Jörg should be Stefan Joerg
Stefan Järg should be Stefan Jaerg
Stefan Jürg should be Stefan Juerg
Stefan Jßrg should be Stefan Jussrg

In simple if any name contains these alphabets they should be replaced as below

ä-ae, ö-oe, ü-ue,ß-ss

Suggestions are welcome.

Regards,

Prasad.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Evgeniy Kolmakov Feb 03, 2017 at 04:55 PM
0

Hi Prasad!

You could use java code in message mapping or adapter module to read payload using original encoding (if it's not UTF-8) and replace these symbols with desired ones.

Regards, Evgeniy.

Share
10 |10000 characters needed characters left characters exceeded
Prasad P Feb 13, 2017 at 05:16 PM
0

solved using UDF.

Share
10 |10000 characters needed characters left characters exceeded