Hi All,
I need to reorder the sequence of line groupings - specifically the output
from a bank QIF (Quicken Interchange Format) export.
Sample is like this:
!Type:Bank
D12/05/2008
T-10.00
N1
Details of Charge 1
^
D07/05/2008
T-20.00
N2
Details of Charge 2
^
D17/04/2008
T-30.00
N3
Details of Charge 3
^
What I need is the following with the oldest transaction as the first line:
!Type:Bank
D17/04/2008
T-30.00
N3
Details of Charge 3
^
D07/05/2008
T-20.00
N2
Details of Charge 2
^
D12/05/2008
T-10.00
N1
Details of Charge 1
^
Even better, would be the above but without the "N" Entries.
Any assistance with doing this is with sed/awk/perl, would be appreciated.
Thanks,
Mark