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