I had made a similiar post last year and received a great tool to accomplish the task at hand. I have the same request except the CSV data i'm running the script against has changed slightly. The original post was:
I have several csv files that sometimes contain a value of say 65000 in the very last column and the only acceptable value is less than that.
whether it be a solution or suggested source for custom scripting i am looking for guidance on how to accomplish the following:
scan all csv files for values greater than 65000 (in the last column) and replace it with the average of the previous 2 values. sort of like an estimation find and replace where data is missing.
Attached is a sample CSV file. The original post was answered by billprew...if you're out there bill please check out my posting.