Decode hex format data

[Anonymous]

Hi,
Anyone know how to decode the hex format to unicode string?
regards,
Ommie

[Anonymous]

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

[Anonymous]

Hi Sabrina,
Yes, but what type of encoding i should select if i want to encoding to string?
Regards,
Ommie

[Anonymous]

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

[Anonymous]

Hi Sabrina,
Did you mean Talend does not support hexadecimal converter to ascii only???or to any format hexa cannot be decoded by Talend?

Regards,
Ommie

[Anonymous]

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

[janhess]

We need to know what you want to convert the hex to. Is it base64 encoded or ebcdic or assci? Is it just text or a mixture of text and numbers?

[Anonymous]

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

[janhess]

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.

[Anonymous]

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