topic Re: EBCDIC file having Hex value in a field - Talend Data Mapper in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 09:50:13 GMT

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.

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

Anonymous — Wed, 10 May 2017 07:57:08 GMT

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

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

Anonymous — Fri, 19 May 2017 08:10:58 GMT

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.