Jump to content

CSV load file error - Extracted Text field


Recommended Posts

I am using 1.9.1 to read a CSV load file and it will not read the file properly when it comes to the Extracted Text field.

 

A sample Extracted Text field is "Images\001\001\00000001.txt"

 

During the Validation step, it says it cannot read the file. The example above shows [path]\Images00100100000001.txt

 

The backslashes in the CSV file are not being read and shows it as one long string.

 

 

Link to post
Share on other sites

Can you try replacing the back-slashes with a double pair of back-slashes? I would have to consult the load file experts in our team, but from the output that you are giving I presume these are being used to escape certain special characters. As "0" is not a special character, "\0" then simply becomes "0".

 

If this fails, can you show a screenshot of the complete settings?

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...