Delete - Line Feed (New Line)/ Tab / Special Character from Excel

Dear All,

We have many time face the issue of import (CSV,TAB) file using XMLPort in NAV because of New Line (Carriage Return) /TAB/Special Invisible Character in files.

It is difficult to identify and remove that.

I have search one add-in tool on internet which is help us to remove this invalid character easily.

ASAP Utilities:

Following file has contain the new line character in data and it is giving me error while import using XMLPort.

Step to remove new line character

In the Beyond compare image you can  see that new line character is now removed from file.

It is very easy to do.

Keep sharing...Keep Growing !!!!