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.
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
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.
Retrieving data ...