When we do a copy to Excel from a dashboard, the Part Description field is getting cut off and added to the next Excel row. It looks correct in the dashboard but when doing a copy to excel, it is cutting it off in to a new row. I checked and the characters (with spaces) for this part description is 53. Is this a limitation with copying to excel with how many characters it can copy over within one cell or what else could be causing this issue.
Are you sure you don’t have a new line in your part description?
Not that I am aware of in the part description. When I reviewed the BAQ, I am able to export the ShipDtl_LineDesc that is being used as the part description and copy to Excel works from within the BAQ but not the dashboard.
This is almost certainly it. If you are getting your data from a BAQ, use a calculated field to replace char(10) and char(13) with a space or something. Those are the hidden new-line characters that can be present in your text fields.
1 Like
Odd that when I copy to Excel from the BAQ, it works fine but when I copy to Excel in the dashboard, it creates the new row.
You can always use a tool like notepad++, or free clipboard viewer to view the underlying data. For example, if you have a text field that contains line breaks, they will show up in the hex code as “0D 0A”. This way you can know for sure what hidden characters you are dealing with.
I copied the description field into Notepad++ and it also creates a second row line and I don’t see any special characters.
In Notepad++ go to View > Show Symbol > Show End of Line. You should see two black boxes with CR and LF inside. Those are your hidden line breaks.
You can also use the replace tool to find and replace those chars. Confusingly, you have to search for \n and \r (make sure to turn on that option in Replace tool under Search Mode).
1 Like
Sorry to open this really old post but I’m running into this same issue. An executive reported it, and I confirmed in our comments fields people use newline to format the comments. The reason I’m following up is if I tell an executive to use Notepad++ and then use regular expressions they are going to tell me to do better 
Any suggestions on a simpler solution I can give to an executive?
If helpful the comments are human readable and provide updates. So doing a search and replace on the fields in my DB are just going to upset users as now they can’t read their comments clearly. Seems like a catch 22…
Initials Date - Update 1 [CR][LF]
Initials Date - Update 2 [CR][LF]
Initials Date - Update 3
1 Like
We ran into this issue last year when copying from dashboard/rows to Excel where the description would break into a new line in Excel. Not sure if same situation. In our case, the issue was caused by new lines/carriage-returns in the part description. The new line is not visible in a dashboard/row but is visible in the description field in Part record if you click the symbol on the part description that displays the entire description in the slide-out panel.
We found that if you use the Copy function (Example Copy All Include Labels) option in Epicor instead of the Export to Excel function the new line does not occur. The Copy function drops the carriage return (blank line) and eliminates the need to fix the description in Excel.