If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Comments field spanning cells in excel 2007

Started by Binway, 24 Jul 2016 10:50:58 PM

Previous topic - Next topic

Binway

Hello Legends,
I have a comments field in a report that spans multiple cells for a record when exported to excel 2007 that I assumed was occurring as a reuslt of a line break or paragraph mark in the source data, the stakeholder would prefer this to appear in one row.
I applied some replace code - replace([Comments_Orig], char(13) + char(10),', ') - seems to have fixed a large number of records but some are still spanning across cells for which I cannot determine the cause.
Some data returned in excel:
Comments
No Comments Available
, , Created a 2nd time with new SO 1234 as incorrect project type linked with SAP, , , Phase 1 – Internet Perimeter Penetration Test , Phas...for complete comments refer to Source System

No Comments Available
30/06/2016 : Milestone - Initial NW Commission and Test, delayed pending approval from Customer to split the milestones up.
No Comments Available
Negative variation approved by Stakeholders.  To be taken up in May 2016.  Reversal of  amt of Revenue., , Dispute - ABC ...for complete comments refer to Source System

No Comments Available

Whilst the above data may not be clear I have attached a image of the data being returned in xl.

Any thoughts appreciated.
Regards

Binway

Binway

Hello Team,
Found there were a couple of other fields with this sort of issue, they had a char(11) character which I have replaced with a comma.
For the comment field mentioned previously I found that setting the column width to 200mm and the length of the string to 100 characters met the users requirements.


Regards

Binway