I'd appreciate someones help on this.
I'm pretty new to Unix and am still learning bits and bobs here and
I have a text file in Unix holding information.
Each field is separated by a semicolon
I want to create a excel file which uses these fields to create a proper
listing by Department. I can do the macro, but I need a way of
converting the file in Unix and outputting it, sorted by the Department
I saw a way of using Grep and will ideally like to use this to search
for a particular department and record all the details in a txt file and
so on until all the departments are accounted for. The txt file would be
updated, not replaced each time
This file can then be use as a basis for my excel macro
Does anyone know a quick and simple way to do this??