topic _x000D_ in QlikView

_x000D_

carlosban — Mon, 26 Jan 2026 18:19:17 GMT

Good afternoon, I hope for your support

I have a file in excel, but when doing the recharge in the table object the following code is transcribed at the end of the report text : Code _x000D_ that I can, the file does not present that code, I only see it in the Qlik View.

Thank you

Re: _x000D_

olivierrobin — Fri, 13 Jul 2018 07:04:44 GMT

it seems to be the ascii code 0D (carriage return) so end of line

How to you load your excel file ?

Re: _x000D_

BalaBhaskar_Qlik — Fri, 13 Jul 2018 13:12:38 GMT

May be try like this:

Replace( Field, '_x000D_' ,'')

Re: _x000D_

BalaBhaskar_Qlik — Fri, 13 Jul 2018 13:14:33 GMT

Replace that field value where it's having '_x000D_' by empty string.

Re: _x000D_

carlosban — Sat, 21 Jul 2018 22:26:21 GMT

Normal load, but when loading and working on any of the table object, these codes are displayed

Re: _x000D_

mikesz99 — Mon, 06 Aug 2018 21:40:46 GMT

That replace command will remove the "_x000D_" from the file. But that also removed the formatting from the data, so that when the data is displayed in my table, there is no line break.

How can I replace that string with something that QS tables will interpret as a line break?

What is particularly odd is that my mouseover text DOES have the line breaks. Only the text in the table is jammed together as one long line.

Thanks for any help....