Question Re: Need Blob to text conversion in Data Sphere in Technology Q&A

Need Blob to text conversion in Data Sphere

gireesh0909 — Thu, 18 Jul 2024 08:59:40 GMT

Hi folks,

I have table in S/4 hana STXl to store the long text for all other tables which i am using it in Data sphere to get text but i am failing to convert the clustd value TO_CHAR(TO_NCLOB(TO_BINARY('FF06020102028000343130330000000063010000121F9D0232663E060606461E20C1C0CA80058430F8307832F831B832AC85A85C05166601538C1CEB2082FBA0', 'HEX'))) text but it was giving an error for conversion.

Could anyone please help me here to convert this in data sphere or any suggestion would be helpful.

Re: Need Blob to text conversion in Data Sphere

Simon_Ye — Fri, 19 Jul 2024 06:03:42 GMT

what's the data type of column "clustd", what's the target data type? if you want to convert binary to string, try function BINTOSTR

Re: Need Blob to text conversion in Data Sphere

gireesh0909 — Fri, 19 Jul 2024 08:45:33 GMT

Source data type of clustd from STXl table is large binary with data shown earlier like FF017FF like that and target data type is string with text like repaying the amount like that.

I tried with bintostr but it was giving only FF017FF same as what ever we have.

Could you please anyone can help