Cognos changes data when it uploads a file

[dougp]

...I think.

I'm using Cognos Analytics 11.2.4.2 and I am having trouble with an uploaded file for a new report I am building.

This topic involves an uploaded file, a data module, and a report.  It's all report development work, so I'm dropping it into the Reporting area.

My user has a need to add narrative to a nicely-formatted report that is mostly data from our data warehouse.  The narrative text includes paragraphs -- so, line feeds.  It looks like somewhere between uploading the file and viewing it in the grid view in the data module, the line feeds are being changed into spaces.

When I copy the value from the Excel cell into Notepad++, I see CR LF.  (Could be Windows "helping" me?)
When I use VBA to write the value to the immediate pane, changing CR and LF to something readable along the way, I see LF, but not CR.

I created a simple report and tried to view the data, noticing that it's all one one line.  That could be HTML rendering, so I did...

Code Select Expand

replace([Query Item], chr(10), '|||')

...but there's no ||| in the output.

Is there a way to verify this?  I don't see any indication in the Content Store of where the data from an uploaded file is stored.  I think uploaded files end up in the data folder.  Searching by date, I think I found the parquet files.  It looks like it went to two files because there are two worksheets in the workbook.  But I can't read the contents, so I can't tell for sure.  I don't see a straightforward way to open a parquet file (.data in Cognos) in a human-readable format.  I'd love to see what data Cognos stored.

Any help is appreciated.