COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: beaconbiz82 on 26 Aug 2010 11:48:54 AM

Title: Report output as pipe seperated text - Urgent
Post by: beaconbiz82 on 26 Aug 2010 11:48:54 AM
Hi everyone,

We have a few systems that get data import files from cognos as csv but this one system needs the file to be a pipe separated text file. I concatenated the data items with the pipe symbol and the i am able to get the csv file and open it in notepad to save the file. The issue with that is the paragraph marks hence we opened the csv file with MS Word to remove the paragraph marks. It works fine this way but its a manual process..Is there a more direct way to do this...