I
ixara
Dear all,
I have a CSV file contain many fields and all fields have valu
(positive & negative values). I have 2 questions here:
1) This file is created on Friday. So the date in Field1 is Friday'
date. I want to change the date to Saturday date. How can i change i
using macro?
2) I want to set the value for fields 24 until 26 to 0. I want th
script to force the field value to be 0. How can i do that by usin
macro?..and fyi, my CSV file have header in the first row. Below
illustrate my original csv file and the expected output.
3) How can i automate the macro to run every Friday afternoon? Thanks i
advance for any help.
Original csv
Field1, Field2,....,Field24, Field25, Field26, Field27
"20120803","ABC",...,9.032,24.52,-6.325,21.12
"20120803","ABC",...,5.242,-1.53,7.005,21.12
Expected output csv
Field1, Field2,....,Field24, Field25, Field26, Field27
"20120804","ABC",...,0,0,0,21.12
"20120804","ABC",...,0,0,0,21.1
I have a CSV file contain many fields and all fields have valu
(positive & negative values). I have 2 questions here:
1) This file is created on Friday. So the date in Field1 is Friday'
date. I want to change the date to Saturday date. How can i change i
using macro?
2) I want to set the value for fields 24 until 26 to 0. I want th
script to force the field value to be 0. How can i do that by usin
macro?..and fyi, my CSV file have header in the first row. Below
illustrate my original csv file and the expected output.
3) How can i automate the macro to run every Friday afternoon? Thanks i
advance for any help.
Original csv
Field1, Field2,....,Field24, Field25, Field26, Field27
"20120803","ABC",...,9.032,24.52,-6.325,21.12
"20120803","ABC",...,5.242,-1.53,7.005,21.12
Expected output csv
Field1, Field2,....,Field24, Field25, Field26, Field27
"20120804","ABC",...,0,0,0,21.12
"20120804","ABC",...,0,0,0,21.1