AlexUldis
Experienced User
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: Export to Excel - Some fields contain line breaks
Hello Sai, I am not using Alt+Enter, or entering the data. The Line Break is added during the export process from MYOB to excel. I was just explaining how to replicate the problem, but the problem is generated during the export process. I have found a way to remove the Line Break during my further analysis in excel, but I don't think MYOB should be adding the line breaks to the exported data in the first place. The fact that it only affects "Item Numbers" and "Names" starting with a "0", at that it only started occuring in the last 4 or 5 weeks, suggests to me that there is a bug in the export process.108Views0likes2CommentsExport to Excel - Some fields contain line breaks
In the last month or two (since early Sept) I note that some fields exported to excel now contain 'line breaks' aka 'carriage returns'. My specific example is the Items Register [Detail] report, when exported to excel. Some exported "Item Number"s or "Name"s of Items have a line break in the cell. To replicate this manually, instead of typing "Item Number", you would type "Item Number + ALT ENTER" It seem to only affect Item Numbers and Names that begin with a '0'. So Item Number 12345 appears on one line in the cell, but item 01234 has a line break after it in the cell. It is playing havoc with spreadsheets I use to further analyse reports.158Views0likes4CommentsRe: CSV Error 4077
Hi Gavin, New items are manually added throughout the year. When rolling out a price rise all items are exported to a text file, the Selling Price is updated, and the existing products in MYOB are updated via the import process. The "Item Number' and " Selling Price" are matched during the import process, but the 'No. Items/Sell Unit' is not involved. I have been having this problem for many years, and as mentioned earlier, it does not affect items that were 'fixed' last time the scrpit was run, only products added manually since the last time the script was run.