Excel Special Character Issue

[Anonymous]

Hi All,

All new lines entries in Excel are appended with a special character "_x000D_". Is there a way to get rid of this in qlikview.

Thanks,

Abhay Sudhakaran

[JonnyPoole]

how about the replace function to replace the value with an empty string ?

Replace( Field, '_x000D_'  ,'')