Cobrix returning hexadecimal value in different format (qb)

Hi All,

When I am reading hexadecimal data from Cobol file using Cobrix, the output is in a different format. I have tried to cast it using Spark SQL and Pyspark. But there is no use.

The data type defined in copy book is PIC X(06). In most cases, it is getting converted to "qb" with one or 2 spaces after that. Can anyone please help me with this? Whereas Abinitio reads the same data as "qbXXX". Some characters after "QB". But in Abinitio they were able to cast that value to hexadecimal.

As the data we are reading is highly sensitive, we could not able to get it from our customer. So I couldn't able to share the file here.

Thanks in advance,
Narayana