How to detect and remove spaces from an import file in Confirm

Product Feature: Job Costing
Steps to detect and remove spaces from Import file
  • Download and Install the utility or tool called “Notepad ++”
  • Now open the import file in Notepad++. It will look something like this:
User-added image
  • Now click on the top, click on View and Show Symbol and select “Show All Characters”:
 User-added image

  • Once you select this option, you can see the spaces, tab spaces, next line etc. See the screenshot below:
 User-added image
  • As we can see that there are unwanted spaces in between the fields which should be there. We will remove those spaces. Now the file looks like below:
 User-added image
  • Save it and try to re import again. It should get imported successfully.
UPDATED:  April 20, 2017