Accountright Import/Export Bug

The problem with HEX 0A in the data is that the data cannot be easily imported into a database as the continuation of the description is now at the beginning of the next text line (Which normally, in the case of ItemSales data, is the Company Name Field)

The importing of such raw data therefore becomes useless unless it is "cleaned up"

So that's what I have done - Read the export line by line and remove the lonely HEX 0A characters

You may well be correct that the operator may have pressed an enter while keying the description but I do not have HEX 0D0A other than at the end of the line, which I expected

SOLUTION

The trick is to read the file - Scan the file looking for HEX 0A0D together - replace the HEX 0A0D with HEX FFFF - Rescan the file looking for HEX 0A - Replace with a space - Rescan the file looking for HEX FFFF - replace the HEX FFFF with HEX  0A0D

Works for me - perfectly 

A little challenge but all good

Thank you so much for your interest !