When exporting data from Explorer to Excel, some data lines are incorrectly formatted and lines are truncated and restarted at the begining of the next line.

Solution: This is caused by Carriage Return Line Feed characters (Char(10) and Char(13)) in the data. We found this in Inventory, AP/AR and GL.

The script below will remove this, but be careful as this will also remove the formatting on the descriptions of Inventory items.

declare @desc varchar(100)

set @desc = '%' + char(10) + '%'

update inventory set [description] = replace(description, char(10), ' ') where [description] like @desc

update apinpcdt set line_desc = replace(line_desc, char(10), ' ') where line_desc like @desc

update apvodet set line_desc = replace(line_desc, char(10), ' ') where line_desc like @desc

update gltrxdet set [description] = replace([description], char(10), ' ') where [description] like @desc

set @desc = '%' + char(13) + '%'

update inventory set [description] = replace(description, char(13), ' ') where [description] like @desc

update apinpcdt set line_desc = replace(line_desc, char(13), ' ') where line_desc like @desc

update apvodet set line_desc = replace(line_desc, char(13), ' ') where line_desc like @desc

update gltrxdet set [description] = replace([description], char(10), ' ') where [description] like @desc