Welcome to mibuso.com

mibuso account = Forum account

To login to mibuso.com, you need a forum account. The same forum account is used through the site.

Don't have a forum account yet?

Please register yourself first in the forum: registration

Member Login

24 May 2013

Feedback

Become a sponsor

Our sponsors

Downloads

Name:	Remove Excel CR+LF Errors
Author:	Ren� Th�ne
Date:	04/09/2008
Size:	7.9 KB
Downloads:	1146
MD5 Digest:	62F0647130537CDF20B11EDB69C66D9A
On DVD-ROM:	Yes

Category:	General downloads

Description:	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.

Avg. rating:	(rated 2 times) Popularity:

Discuss this download in the forum (2 reactions)

Find all downloads from this author (7 downloads)

SMS this title to a friend

Mail this title to a friend

(report broken link)

Rate this download

- Please do not vote for the same download more than once.
- Please be objective, if everyone receives 1 or 5 stars, the ratings aren't very useful.
- Do not vote for your own resource or a competitor's.

mibuso.com is not in any way affiliated or associated with Microsoft Corporation or any of the companies in the Microsoft Corporation Group.