Junk characters while loading from qlikview

[#1]

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

[ThornOfCrowns]

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

[arsal_90]

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','#@$%^&')

[arsal_90]

if still have problem then just provide the sample qvw

[#5]

Hi Rahul,

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

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

Hope this helps!

[MarcoWedel]

Maybe it is a codepage issue.

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

Regards

Marco