VarChar to Hex

vinaymanchinila · Post by **vinaymanchinila** » Tue Aug 29, 2006 12:07 pm

Hi,

I need to convert varchar to hex value. There are 2 parts to it, first convert from varchar to hex but take only 2 at a time from the below source column:

SrcCol=56243312....

Required Output value (if we just consider the first 2 i.e. 56)

outputCol=00011100

Did any one come across sucha situation. I look at some Oconv function (radix) but not sure if it takes 2 caharacters at a time.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Tue Aug 29, 2006 10:49 pm

You would need a BASIC Transformer to use Oconv() or Iconv() in a parallel job. But your output isn't hex - it appears to be binary. Oconv() can do that too. Please specify your exact requirements. Hex can be managed with "MX" or "MX0C" or "MY" conversion, binary with "MB" or "MB0C").

vinaymanchinila · Post by **vinaymanchinila** » Wed Aug 30, 2006 6:16 am

Hi Ray,

Sorry for the confusion, yes I need the binary output. I designed it with the basic transformer and got the output, how ever is there away to keep the leading zeros with any options:

56=11100 (Can we get 00011100)

Secondly, do we have any options we can mention in the function so that it takes 2 characters at a time, as the source is like
564286988989.....

thanks a lot.

ArndW · Post by **ArndW** » Wed Aug 30, 2006 6:22 am

Vinaymanchinila,
even though I'm not Ray you can right pad your binary to 8 places by using the FMT(In.Column,'8"0"R') conversion. I'm not sure what you are trying to do with the "take 2 characters at a time" part.

sauros73 · Post by **sauros73** » Wed Aug 30, 2006 7:38 am

Are you using the CFF stage in order to create your binary output ? What stage are you using ?

vinaymanchinila · Post by **vinaymanchinila** » Wed Aug 30, 2006 8:55 am

Hi ,
I used a basic transformer and Oconv(ToOconv.Src, "MB") function.

vinaymanchinila · Post by **vinaymanchinila** » Wed Aug 30, 2006 9:06 am

Hi,
Now I also have to convert a hex value to binary.

56e2 =0101 0110 ...

Looking to check if we have afunction for that.

Thanks,

ArndW · Post by **ArndW** » Wed Aug 30, 2006 9:12 am

With ICONV/OCONV use the MX format for hexadecimal, MB for binary.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 30, 2006 6:03 pm

Two characters at a time can be done simply in a server routine with a loop. Be sure to handle exceptions, such as argument not assigned, argument not null, argument contains odd number of digits, argument does not contain decimal numbers. You can invoke the server routine from any expression in your BASIC Transformer stage.

Or you could create parallel routines that you could invoke from a parallel Transformer stage. Or a BuildOp.