Report output as pipe seperated text - Urgent

[beaconbiz82]

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...