You can modify the flat file using shell scripting in unix ( awk, grep, sed ).

Hope this helps.