Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use Purgechar to get rid of pesky string data.
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','#@$%^&')
Hi Rahul,
If the similar characters are occuring again and again then you can use:
Purgerchar('Your Fieldname', 'Unwanted charater')
Hope this helps!
Maybe it is a codepage issue.
You should be able to change the codepage in the load statement.
Regards
Marco