UTL_RAW.CAST_TO_VARCHAR2

[sifatnabil]

Hi all,

Oracle SQL has this function UTL_RAW.CAST_TO_VARCHAR2 which converts from RAW to varchar. Is there a function on the QV script side which can do the same for RAWs?

[PrashantSangle]

Hi,

Basically this function is used to converts RAW datatype to Varchar datatype.

So depend on your data present in that field you can use QlikView functions.

Can you share what kind of data present in that field?

If possible, also share some data of it.

Regards

[sifatnabil]

Hi dreamer4‌, the data consists of values with a comma delimiter like this:

EXEC_IDS

48:06001671363043A0,52:280016530006C576

70:0600167E363084A7,71:0600167E363084AA

I want to use QV's subfield function to extract the values in BOLD, but they are in RAW format. I want to convert them to varchar. The varchar equivalent looks like this 16 digit number: 32383030313635333030303643353736

I'm using subfield like this: trim(subfield(subfield(EXEC_IDS,','),':',2)) as EXEC_ID

[PrashantSangle]

Hi,

It is difficult to know what kind of alogorithm use behind that function.

But if you want that converted 16 digit number in your report.

then you can use that field using same function while fetching data from database.

and using evaluate() you can load that 16 digit number in QlikView Report

Regards,