If there's not so many data, awk and sed will do the job. Taking the story to extreme, modern day developer should take a Hadoop (despite the fact it would be

If there's not so many data, awk and sed will do the job. Taking the story to extreme, modern day developer should take a Hadoop (despite the fact it would be 235x time slower than awk - http://aadrake.com/command-line-tools-can-be-235x-faster-than-your-hadoop-cluster.html http://aadrake.com/command-line-tools-can-be-235x-faster-tha...) and old timer should take some APL descendant like Q with kdb+.