Hi, Can you take a look at the tChangeFileEncode component? It is used to change the file encode, please try and let me know if it fixes your need. Best regards Sabrina
Hi, If your input is hex format the hexadecimal ASCII data which cannot be supported by Talend. So far, we only support Octal ASCII. Best regards Sabrina
Hi, We don't support to decode hexadecimal ASCII data in talend. If we read the hexadecimal ASCII data using talend, it might be garbled . Best regards Sabrina
Hi,
From my understanding of Omie's requirement, she have data set that has been encoded as hex format. What she wants to do is to decoded it to ASCII so that she able to read the data.
She has built the ETL job to decode hex to ascii but the output after decoding was garbled. That's why she asked why that issue happen. Since Sabrina said that Talend was not supported for hex to be decoded into ascii, she asked again whether Talend was not supported hex to be decoded into all kind of format(ascii, ebcdic...etc) or only to ascii? I'm sure the data is mixture of text and number.
Rgds,
Kal
If we don't know what sort of hex it is we can't decode it. If it's hex from ascii that's different from hex from ebcdic and is a problem if there's not a schema to identify where number fields start and stop.
Hi Janhess,
I believe it is hex from ascii. That's why we need to decode it to ascii. We tried to used the data and convert it via online converter and it is worked. I really don't get what do you mean by field start and stop. its only one field and contained of a lot of row data that has been encoded to hex.
rgds,
Kal
