In one column I have a bitstring encoded as a string type. In a different column I wish to have the same bits (potentially starting with a leading 0), but as a binary value type. Ultimately, I want to have it in hex representation (string or hex type, doesn't matter) in a third column.
How is this done? Do I have to program something for it or is there a faster way?
Input cell contains the following string: 00000100100011000100100011
I wish to obtain the string: 0123123