Converting hex to char

bonds · Post by **bonds** » Wed Jul 29, 2009 11:49 pm

Hi,

Need to write to a flat file where first two characters of each record should be char version of a hexadecimal value. i.e. '4F44' is should show as 'OD' in output file.

Could you please suggest how to convert Hex value to Char

regards,
Satish

ray.wurlod · Post by **ray.wurlod** » Thu Jul 30, 2009 12:14 am

BASIC Transformer, Iconv(string[1,2], "MX0C")

bonds · Post by **bonds** » Thu Jul 30, 2009 12:48 am

Anyway to do it in parallel 8.1?

ArndW · Post by **ArndW** » Thu Jul 30, 2009 12:49 am

One can do it in PX, but not as easily. Take a look at this thread

Network_CIS · Post by **Network_CIS** » Thu Jul 30, 2009 2:07 am

given link says its Premium content

is there any work around?

ArndW · Post by **ArndW** » Thu Jul 30, 2009 2:36 am

No, no work around from me, since I believe that the site is valuable and that membership pays to keep it running.

chulett · Post by **chulett** » Thu Jul 30, 2009 5:20 am

Well, you could always flex your C++ muscles to create a more 'parallel' solution.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 30, 2009 4:24 pm

You can see the entirety of my entry (it's short enough not to be affected by the premium size cutoff) and it IS a parallel solution.

Network_CIS · Post by **Network_CIS** » Thu Jul 30, 2009 6:50 pm

While my premium membership is still under review...
Found this solution in unix:

hexchar="FF"
octchar=$(echo "ibase=16;obase=8;$hexchar"|bc)
hexInChar=$(echo "\0$octchar")

Could you please suggest how to embed this code in DS job.

Via oracle char code could be found by:
select HEXTORAW(hex) as value from hextable;

bonds · Post by **bonds** » Sun Aug 02, 2009 11:50 pm

Thanks for all the suggestions.

Using server job was certainly a simple and good option; however, had issues with converting values like 8A, which are not standard ascii values. DS was generating '?' where unix was generating a wierd symbol sililar to 'g'

Workaround: running the unix script after the ds job to change hex to char codes

marbis · Post by **marbis** » Tue Aug 11, 2009 2:33 am

marbis · Post by **marbis** » Tue Aug 11, 2009 2:34 am

Hi ,
i must convert exadecimal values in char values in main frame job.
The function ICONV doesn't exist.
Cai i do?
Is difficult?
Bye

chulett · Post by **chulett** » Tue Aug 11, 2009 5:18 am

Marbis, please start your own post on this subject.

marbis · Post by **marbis** » Thu Aug 13, 2009 10:10 am

hi,
i convert the hexadecimal value 0D0A to charapter with the constant X'0D0A'.

Bye

ray.wurlod · Post by **ray.wurlod** » Thu Aug 13, 2009 4:57 pm

Carriage return line feed?

You probably did not need to convert those explicitly at all.