Skip to Content
avatar image
Former Member

Handling Characters

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 03, 2017 at 04:55 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2017 at 05:16 PM

    solved using UDF.

    Add comment
    10|10000 characters needed characters exceeded