Hide HTML Line Breaks

[#1]

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?

[#2]

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

[#3]

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

[Anonymous]

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,

[rwunderlich]

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