Issue with double quotes when export as text file.
I came across issue when i add " double quotes around column it display the report correct column contents in double quotes. When I export as Text format it export the contents with three times double quotes around column contents.
I have added calculated field '"'+Incident Number+'"' and in display it shows the results "INC000000000123" and when i export the report to test format it exports as """INC000000000123"""
I am wondering why the exports adding extra double quotes.
It also includes extra quotes in column heading as well, if i change the column heading from Incident Number to "Incident Number" or ''Incident Number'' it also export as """Incident Number""".
How can we achieve this or this is defect.
We are using 7.1 (BMC version).
Thanks In Advance