Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Junk characters while loading from qlikview

Capture.PNG.png

Hi all,

when i am pulling the data from share point list , i am getting these type of junk characters as attached in the image .Could please help me in resolving the issue ASAP.

Thanks

5 Replies
Highlighted
thornofcrowns
Valued Contributor II

Re: Junk characters while loading from qlikview

You can use Purgechar to get rid of pesky string data.

Highlighted
arsal_90
Contributor III

Re: Junk characters while loading from qlikview

You should use purgechar function. It Returns the string s1 less all characters contained in string s2. What you have to do is just pass all special charaters in string2

=PurgeChar('DFF#$^@kl','#@$%^&')

Highlighted
arsal_90
Contributor III

Re: Junk characters while loading from qlikview

if still have problem then just provide the sample qvw
Highlighted
Not applicable

Re: Junk characters while loading from qlikview

Hi Rahul,

If the similar characters are occuring again and again then you can use:

Purgerchar('Your Fieldname', 'Unwanted charater')

Hope this helps!

Highlighted

Re: Junk characters while loading from qlikview

Maybe it is a codepage issue.

You should be able to change the codepage in the load statement.

Regards

Marco