Hi Folks -
I have a problem and I've been trying to figure out but have't been able to.
I get a huge file from my partners (roughly 400MB) and I'm trying to find an automated way of splitting that file up based upon the field contents of one column i.e. the column that has the states.
For example - I want to get every row from GA and split it out into excel, and then do that for every other state.
Historically I used a CSV splitter then filtered the file, but that just takes way too much time.
Any thoughts on how to do this?