topic Re: Junk characters while loading from qlikview in QlikView

Junk characters while loading from qlikview

Mon, 24 Mar 2014 10:35:08 GMT

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

Re: Junk characters while loading from qlikview

ThornOfCrowns — Mon, 24 Mar 2014 10:40:20 GMT

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

Re: Junk characters while loading from qlikview

arsal_90 — Mon, 24 Mar 2014 10:41:12 GMT

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

Re: Junk characters while loading from qlikview

arsal_90 — Mon, 24 Mar 2014 10:42:08 GMT

if still have problem then just provide the sample qvw

Re: Junk characters while loading from qlikview

Mon, 24 Mar 2014 10:42:28 GMT

Hi Rahul,

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

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

Hope this helps!

Re: Junk characters while loading from qlikview

MarcoWedel — Mon, 24 Mar 2014 10:43:54 GMT

Maybe it is a codepage issue.

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

Regards

Marco