I have an csv file that i would like to add another column (R) to. I need it to be dependent on the value in the 6th column (F).
If F=1 I need R = 1
If F=2 I need R = 2
If F= (anything else) I need R = the value in column E
I am attaching an example of the kind of CSV i am working with.
Normally i would have focused on trying to find an VBS that would do this, however my last question was answered with a batch file that worked perfectly. However I am not sure which way is best in this instance.
I am hoping someone can steer me towards a solution or example of something working with csv files in a similar manner.