What I have :I have CSV file with several columns and rows.
What I need: I need some sort of script or macros to dynamicly add another column to the CSV file that would contain values based on the value of the given (first or second or third) column and row.
Example: I have A,B,C and D columns and 7 rows. I need to convert this CSV that after conversion is done every row that has value of 407 in position d would have column I added with value 2,every row that has 1037 in position D would have value of 30 added to column H and so on.
The macros should be fully ajustable based on what I need.
In example file that I attached to this ad I need macros to create column I values based on column [url removed, login to view] every row that has 437 in D i need have row value of 10(or whatever) in column I and so on.
I will have to process csv files that has 500 or 600 lines so macros should be able to process huge ammount of information.
AND I need macros to save newly created file in CSV.
Also I need macros to save my parameters for conversions,say today I have above requirements,tomorrow I will have another requirements(different values or different columns ).I want to be able to save requirements for later load and use.
31 freelancers are bidding on average $63 for this job
HI; i m the best expert in VB6 and office VBA. i have done similar tasks on XLS. u can check my profile here: [url removed, login to view] Best Regards; Hussien Sharaf
We are a team of PHP professionals. All the follows have 2-3 years experience in our team members. Our team can handle any type of projects and are ready to work immidiately.