If you are unable to create a new account, please email support@bspsoftware.com

 

Double quotes in the text creating problem while downloading report in excel

Started by Snehalathaga, 10 Nov 2011 12:51:05 AM

Previous topic - Next topic

Snehalathaga

I have a free text column where is data is entered in the contributor using double quotes. When I try to down load the same information from the analyst ( i.e after transforming the data to analyst using C to A link) into an excel file  data doesn't get downloaded correctly from the row which has a double quote. Is there any solution to this problem?

Can we identify and replace all the double quotes in the analyst and then export the data to excel?

PS : I am using cognos 8.4