in reply to Re: Processing CSV File
in thread Processing CSV File
Thank you all, you have been extremely helpful!!
I have found another problem, and that is with the CSV file..
The CSV will need to be a spreadsheet maintained in MS Excel.. The problem with that is, that when the CSV is saved in excel, it adds a hidden CR at the end of each line, so when the script runs, it fails after reading the first line..
Is it possible to amend the script above to ignore that CR?, or I am better off doing some pre processing to the CSV file to remove the CR?