wmfiske Posted June 14, 2016 Report Share Posted June 14, 2016 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 comment Share on other sites More sharing options...
Chris Posted June 15, 2016 Report Share Posted June 15, 2016 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 comment Share on other sites More sharing options...
pmow Posted June 22, 2016 Report Share Posted June 22, 2016 I just did this with a DAT load file with single backslashes, not double. It worked great. Link to comment Share on other sites More sharing options...
Recommended Posts