I have a txt-file, containing lots of data from our HRM-system. I want to process this file (it is delimited with tabulators) to make a new file, only containing – lets say the second, third, fourth, twelvth and the twentifirst column. I want the file delimited by ‘,’ or ‘;’.

I also would like the new file to be sorted by the date-field from the twentifirst column,( formatted like dd.mm.yyyy) newest lines first. The file must only contain the lines with data from the current or last couple of weeks (maybe the last month).

Anybody got any good pointers to do this. Can it be done?

Edited by Curious (2015-03-17 10:42 AM)
_________________________
I was placed on earth to do a job. Right now I have so much to do, I will never die..