Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

momofiore
New Contributor III

how to delete strange character on qlikview like ​​

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 !!

1 Solution

Accepted Solutions

Re: how to delete strange character on qlikview like ​​

With your example the following should work:

timestamp(timestamp#(replace(textbetween('---------- Message transféré ----------

De : Dominique LATRECHE

Date : 6 avril 2018 à 11:46

Objet : site de lyon', 'Date : ', '

Objet : '), 'à', ''), 'D MMMM YYYY  hh:mm'))

Btw. the 'à' is chr(224)

- Marcus

22 Replies
MVP
MVP

Re: how to delete strange character on qlikview like ​​

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

eduardo_dimperi
Valued Contributor II

Re: how to delete strange character on qlikview like ​​

Could you change the encode on your Notepad++

vkish16161
Contributor III

Re: how to delete strange character on qlikview like ​​

Try this:

M1:

mapping load * inline [

Purge,Replace

​,#

];

Fact:

load * ,

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

From BlahBlahBlah.qvd;

MVP
MVP

Re: how to delete strange character on qlikview like ​​

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

MVP
MVP

Re: how to delete strange character on qlikview like ​​

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


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


momofiore
New Contributor III

Re: how to delete strange character on qlikview like ​​

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
New Contributor III

Re: how to delete strange character on qlikview like ​​

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

momofiore
New Contributor III

Re: how to delete strange character on qlikview like ​​

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
New Contributor III

Re: how to delete strange character on qlikview like ​​

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

i tried ur solution but the characters are always there.