I am viewing a report in an application with the string as “Associate Director Quality Value Stream Lead - Bul”. But when I export that data to report and download it as a csv file (default downloading as csv file) I am seeing the string as “Associate Director Quality Value Stream Lead â€“ Bul”.
I am trying to replace the special characters " â€“ " with “”. But I am unable to do so.
I am unable to replace that single double quote available in the string. If you observe closely that single double quote is not similar to keyboard double quote.
I tried with string.replace(“â€“”,"-") , it gave me an error saying double quote has to be provided.
So I tried replacing individually, i.e first string.replace(“â€”,"") and then string.replace(chr(34),"-").
Still no Luck. Any thoughts?
Thanks in advance,