Remove Excel CR+LF Errors

Scans all Code and Textfields of your database in every company.
In this Ready-to-use version also the writeprotected Ledgertables 17,21,25,32,379,380,5802 (permissions set to Modify allowed).

The CU automatic skips tables you haven't rights to read or write.

It checks every field for containing one ore more codes of 00 0D 0A.
If found, the codes whill be removed from the field, and the record is stored (only in this case). You can search for all (forbiden) chars you want, just change the String ForbiddenChars.

You get this codes (0D 0A) if you copy and paste a cell from Excel (all versions) in a text- or codefield of Navision (all Versions).

This CU uses the RecordRef and Fieldref, so it will run only from Navision 3.70 up.
It is written in 4 SP3HF69, but should be importable to any version from 4 up, maybe also on 3.70.

You can run this CU in Automationmodus (guiallowed).
If you want to change the tables to scan, you need
-to remove all permissions if you don't have AL-Licence
-change the "CheckThisTable" as you want. Some Examples are included.

There might be more to done, e.g.
-use a record filled in the ChangeLog, so only wrong Entries are to scan and to correct
-use a Table or Form to configure the Tables to check
-....

As usual: Use at your own risk, test it befor real-use in a test-enviroment, check the results, love your mom and Dad, and leave the first line of this documentation. Feel free to copy, modify and upload this CU to any sources/HP you want.