Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
it seems to be the ascii code 0D (carriage return) so end of line
How to you load your excel file ?
May be try like this:
Replace( Field, '_x000D_' ,'')
Replace that field value where it's having '_x000D_' by empty string.
Normal load, but when loading and working on any of the table object, these codes are displayed
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....