0 - 2 of 2 tags for hex strings

We have a HEX value and we need to parse it to a binary string.
I was looking at GETBIT and TO_NUMBER and FROM_BYTES, but I don't seem to be able to figure this out.  One of the errors I get is Conversion from BYTE and other data types is illegal.

does anyone know how to remove some non-printable characters from a string in a column?
I imported data via OLE-LOAD from a MS SQL server. At least one column contains '0D0A'XB or '0A'XB. This delivers undesired results when exporting via Parallel transporter. So I have to remove those hex Strings, but