how to delete strange character on qlikview like ​​

[momofiore]

hello guys.

could somebody help me deleting  some strange characters "​" on qlikview files. they dont really appear in QVD but when i open the QVD file with Notepad ++ specifying encode in  AINSI and Language in VB, they appear.

i tried to delete them in with purgechar or keepchar. they always there.

for example:

On QlikView it appear like this

De : yassine darwich <moha@gmail.com

Date : 6 avril 2018 à​​ 11:46

Objet : site de casa

but when i open the QVD file with Notpad++ it appear like this

De : yassine darwich <moha@gmail.com

Date : 6 avril 2018 à ​​ 11:46

Objet : site casa

you can see the strange characters !!

[sunny_talwar]

You can play around with KeepChar() or PurgeChar()

[eduardo_dimperio]

Could you change the encode on your Notepad++

[vkish16161]

Try this:

M1:

mapping load * inline [

Purge,Replace

​,#

];

Fact:

load * ,

        replace(Mapsubstring('M1',Date),'#',null()) as Cleansed_Date

From BlahBlahBlah.qvd;

[stevedark]

QVDs are binary files (with a bit of an XML header to make it look like text).  You don't want to go messing with the content of these or you will corrupt your file.

If you want plain text store the data as a text file, not a QVD, just change the format specifier, like this;

STORE MyTable INTO [lib://mylibrary/MyData.csv] (txt);

The text file will then be good to go in Notepad++

Hope that helps.

Steve

[stevedark]

Sorry, just noticed the subject... in QlikView the store will be like this:

STORE MyTable INTO [.\MyData.csv] (txt);

[momofiore]

hey thanks for replay. yes we alraedy used but didnt work. in fact we use keepchar and purgechar when the characters are visible. here we are talking about something invisible on qlikview (i mean this ​​). i can just see them on notepad++.

did u get what i mean? thanks

[momofiore]

thanks. if i could find a way to change the encode on qlikview. that will be better

[momofiore]

thank you.  in fact we use keepchar and purgechar when the characters are visible. here we are talking about something invisible on qlikview (i mean this ​​). i can just see them on notepad++.

did u get what i mean? thanks

[momofiore]

hey thanks. yes exactly i tried messing them before,then got currupted file.

i tried ur solution but the characters are always there.