topic Re: Hide HTML Line Breaks in QlikView

Hide HTML Line Breaks

Wed, 22 Aug 2012 17:05:08 GMT

Hi All,

I have an Excel document that is exported from the web and then loaded into my QlikView document. Once it is loaded in the QVW, the line breaks pull through as _x000D_ as follows (HTML):

John Smith (8/21/12 10:14 AM):_x000D_

Text. Text. Text._x000D_

================================_x000D_

Jane Duncan (8/21/12 10:18 AM):_x000D_

Text Reply. Text Reply. Text Reply._x000D_

Does anyone have any ideas as to how I can get these line breaks to pull through without the code attached?

Re: Hide HTML Line Breaks

Wed, 22 Aug 2012 17:40:00 GMT

It is a 'Notes' field, so that is why it is so long, by the way.

Re: Hide HTML Line Breaks

Wed, 08 Oct 2014 14:21:08 GMT

Sorry for digging this one out of the past but were you able to find a solution for this?

Re: Hide HTML Line Breaks

Anonymous — Wed, 04 Mar 2015 17:47:04 GMT

I am also facing a similar issue and am unable to get rid of the special characters after a new line in excel. It would be great, if some body has a solution.

Thanks,

Re: Hide HTML Line Breaks

rwunderlich — Thu, 05 Mar 2015 04:08:11 GMT

Take a look at purgechar() or keepchar(). I frequently find a chr(160) at the end of excel fields I need to get rid of.

-Rob