topic Re: How can I convert a RAW ( Or LRAW) into sting ? in Talend Studio

How can I convert a RAW ( Or LRAW) into sting ?

AndrewGuy — Tue, 30 Jan 2018 16:17:05 GMT

I want to read a SAP Table STXL which contains a RAW field and insert into a SQL Server table with type nvarchar.

The Schema suggested converting the RAW into byte[] but how can I convert this to nvarchar ?

Thank you in advance.

Andrew

Re: How can I convert a RAW ( Or LRAW) into sting ?

Anonymous — Wed, 31 Jan 2018 09:43:45 GMT

Have you tried this in your tMap? Create your String output column and use the code below (or similar) to convert the byte[] ....

new String(row1.yourRawByteArray, StandardCharsets.UTF_8)

Re: How can I convert a RAW ( Or LRAW) into sting ?

AndrewGuy — Wed, 31 Jan 2018 09:56:10 GMT

Hi Rhall_2_0 ,

Thanks for your input. When I tried adding what you've suggested , I get the error message "StandardCharSets cannot be resolved to a variable".

I enclose a picture of what I've attempted - is that what you meant ?

Screen Shot 2018-01-31 at 09.55.40.png

Re: How can I convert a RAW ( Or LRAW) into sting ?

Anonymous — Wed, 31 Jan 2018 10:10:12 GMT

My mistake. You need to give it's full path unless you have previously imported it. To make it easy, just replace with this...

new String(row1.yourRawByteArray, java.nio.charset.StandardCharsets.UTF_8)

Re: How can I convert a RAW ( Or LRAW) into sting ?

AndrewGuy — Wed, 31 Jan 2018 10:25:59 GMT

One Step further.... thank you.... but I still appears to me to be just raw data rather than the character text.

Screen Shot 2018-01-31 at 10.24.32.png

Re: How can I convert a RAW ( Or LRAW) into sting ?

Anonymous — Wed, 31 Jan 2018 10:37:24 GMT

I can't help you without knowing more about the Raw data. It could just be the wrong character set that is being used in the conversion. I guessed UTF-8. Do you know the original character set? Do you know what the data should look like? Do you know if maybe it has been converted or encrypted? The first thing I would do is look for the correct character set or just try others out if you cannot get the character set.

Re: How can I convert a RAW ( Or LRAW) into sting ?

AndrewGuy — Tue, 12 Feb 2019 14:23:20 GMT

The solution was not to attempt to read RAW but to use the RFC_READ_TEXT object which would then return the text in an XML DOC structure.

With thanks to Chetan!