Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!
It means that the extraction of the timestamp from the text worked but the convertion from this string into a timestamp failed. This could for example happens if there is any difference between the applied format-string of 'D MMMM YYYY hh:mm' to the string or if your main-variables (from beginning of your script) are set different to this format-string (long month-names missing or contain april instead of avril or something similar).
- Marcus
thanks again. is there any solution can i apply?
we are too close here . thank you so much for your support
Are respectively could the variables for the monthnames not properly specified then you could use the mapsubstring-approach from your example above. Further you need to be sure which chars are in your origin field - the copy & paste here to the community website and from there into an editor might change the output (changing the chars for linebreaks, removing multiple spaces and probably some more potential issues). And only with this knowledge you could apply the right formattings / cleaning measures.
Also possible but more expensive would be to cut with something like:
mid(replace(TextBetween(DescriptionStart,'Date :','Objet :' ), 'à', ''), n, n)
each relevant part from the string and creating with it a makedate() + maketime() and format it like you want.
- Marcus