Just thought I would ask here as well.. forgot we had a programming forum.
So..... I have two HUGE excel files with rows of numbers and text. One is complete and one is incomplete, and I have to find the errors in the incomplete file and fill them in with corresponding data from the complete file. Now, I'm totally new to programming, and I'm slowly trudging my way through MatLab. I'm told MatLab can perform this type of repetitive data crunching. And I would much rather spend my time learning MatLab, which could be helpful in the future, than going through and crunching data by hand.
Anyways, my question was whether or not MatLab would be the best program for this. One problem I've already run into is that MatLab isn't all that flexible with text, and my files are composed of both numbers and text. Any other methods you would like to propose?
So..... I have two HUGE excel files with rows of numbers and text. One is complete and one is incomplete, and I have to find the errors in the incomplete file and fill them in with corresponding data from the complete file. Now, I'm totally new to programming, and I'm slowly trudging my way through MatLab. I'm told MatLab can perform this type of repetitive data crunching. And I would much rather spend my time learning MatLab, which could be helpful in the future, than going through and crunching data by hand.
Anyways, my question was whether or not MatLab would be the best program for this. One problem I've already run into is that MatLab isn't all that flexible with text, and my files are composed of both numbers and text. Any other methods you would like to propose?