I am looking for some advice on the best method to use to make changes to a csv file. An few example lines of the source:
I will need to enter the file (which may be quite big) and check, say, the fourth, fifth and sixth field in each line. Then if they match certain values, replace them with other values.
I am not looking for any code just advice on the best way to go about it. For example, I think I could easily ready each line into an array, run an if block and then use a regex to replace the values on a line by line basis. I am concerned that this may not be the best approach.