COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: Snehalathaga on 10 Nov 2011 12:51:05 AM

Title: Double quotes in the text creating problem while downloading report in excel
Post by: Snehalathaga on 10 Nov 2011 12:51:05 AM
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