EBCDIC file having Hex value in a field - Talend Data Mapper

[Anonymous]

Hi

I am having an EBCDIC file, which has a field in Hex value. I need help on how to handle this in the Talend Data Mapper

I have used IBM037 and UTF8 to convert into ASCII. The Hex value becomes un readable while doing this process.

[Anonymous]

Hello,

You cannot get the correct hex value in preview when use data mapper? Would you mind posting your setting screenshots on forum(data mapper setting screenshot, copybookxxx.txt, character_encoding.png)? Which will be preferred.

Best regards

Sabrina

[Anonymous · Accepted solution]

Created a java program to convert the EBCDIC to Hex and used the Java expression to convert the incoming EBCDIC value to hex. It is working.