VERIFIED SOLUTION i
X

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

UPDATED: April 20, 2017


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.
 

Environment Details

Product Feature: Job Costing
 

Downloads

  • No Downloads