Reorder the sequence of line groupings/QIF export


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Reorder the sequence of line groupings/QIF export
# 1  
Old 05-20-2008
Reorder the sequence of line groupings/QIF export

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
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Print Line as per the dependent sequence in shell script.

Hi i have a file like this as shown below: DA PROCESS_ID IDENTIFIER DA_FILE STATUS WAITING_FOR SCOPED_DEPENDENT 1836 21000 01052019 BH90P.TEMP.DA1836.FTP W NULL ... (6 Replies)
Discussion started by: krishnaswarnkar
6 Replies

2. Shell Programming and Scripting

Creating a sequence of numbers in a line for 1000 files

Hi, I try to explain my problem , I have a file like this: aasdsaffsc23 scdsfsddvf46567 mionome0001.pdb asdsdvcxvds dsfdvcvc2324w What I need to do is to create 1000 files in which myname line listing a sequence of numbers from 0001 to 1000. So I want to have : nomefile0001.txt that must... (10 Replies)
Discussion started by: danyz84
10 Replies

3. Shell Programming and Scripting

find common entries and match the number with long sequence and cut that sequence in output

Hi all, I have a file like this ID 3BP5L_HUMAN Reviewed; 393 AA. AC Q7L8J4; Q96FI5; Q9BQH8; Q9C0E3; DT 05-FEB-2008, integrated into UniProtKB/Swiss-Prot. DT 05-JUL-2004, sequence version 1. DT 05-SEP-2012, entry version 71. FT COILED 59 140 ... (1 Reply)
Discussion started by: manigrover
1 Replies

4. Shell Programming and Scripting

How to get line after occurence of sequence of patterns

In the past I needed a help with the problem how to search for pattern after the occurence of another pattern which is described in this thread: https://www.unix.com/shell-programmin...-pattern1.html Now I would need something quite similar, only the pattern which is to be searched must be... (3 Replies)
Discussion started by: sameucho
3 Replies

5. Shell Programming and Scripting

filter out a sequence from multiple lines line

Hi, I have an unwanted string at random lines of my verilog (*.v) file. (* abccddee *) input A; (* xyz *) input B; (* 1234 *) output C; I want a clean file like this: input A; input B; output C; the unwanted string begins with "(*" and ends with "*)" at multiple lines. Any help... (2 Replies)
Discussion started by: return_user
2 Replies

6. Shell Programming and Scripting

printing sequence of line no. with comma separated

Kindly i want to concatenate every 12 lines ina file, using a comma separator between fields (each line)? can anyone help please? thanks a lot in advance. (5 Replies)
Discussion started by: m_wassal
5 Replies

7. Shell Programming and Scripting

Sequence in one single line

My file looks like this (60 characters per line): But I need something like this (the entire sequence in one line): The sequences are of different lengths. Any help will be very much appreciated! (21 Replies)
Discussion started by: Xterra
21 Replies

8. Shell Programming and Scripting

How to remove those sequence with same amino acid?What command line I should type?

My input is listed as: giNumber RefAminoAcid VarAminoAcid 10190711 P P 10190711 D D 109255248 I A 110349771 A ... (4 Replies)
Discussion started by: patrick chia
4 Replies

9. UNIX for Dummies Questions & Answers

to make groupings of object using unix command

suppose u have a file 1 2 2 -3 2 2 -3 4 5 -2 -3 -4 -4 -2 1 1 1 so output should be lie that one for groupings... (1 Reply)
Discussion started by: cdfd123
1 Replies

10. Shell Programming and Scripting

Splitting a file into groupings of 20 entries

I have a file that is dynamic in length, and I need to parse the second field out of it, then split that into groupings of 20 entries and echo a variable above each grouping of 20. The script is written in bash. I am sure there is a way to use awk, but my awk book is at home, and I am out of town.... (1 Reply)
Discussion started by: 98_1LE
1 Replies
Login or Register to Ask a Question
Export(3pm)						User Contributed Perl Documentation					       Export(3pm)

NAME
Perl6::Export - Implements the Perl 6 'is export(...)' trait SYNOPSIS
# Perl 5 code... package Some::Module; use Perl6::Export; # Export &foo by default, when explicitly requested, # or when the ':ALL' export set is requested... sub foo is export(:DEFAULT) { print "phooo!"; } # Export &var by default, when explicitly requested, # or when the ':bees', ':pubs', or ':ALL' export set is requested... # the parens after 'is export' are like the parens of a qw(...) sub bar is export(:DEFAULT :bees :pubs) { print "baaa!"; } # Export &baz when explicitly requested # or when the ':bees' or ':ALL' export set is requested... sub baz is export(:bees) { print "baassss!"; } # Always export &qux # (no matter what else is explicitly or implicitly requested) sub qux is export(:MANDATORY) { print "quuuuuuuuux!"; } sub import { # This subroutine is called when the module is used (as usual), # but it is called after any export requests have been handled. # Those requests will have been stripped from its argument list } DESCRIPTION
Implements what I hope the Perl 6 symbol export mechanism might look like. It's very straightforward: o If you want a subroutine to be capable of being exported (when explicitly requested in the "use" arguments), you mark it with the "is export" trait. o If you want a subroutine to be automatically exported when the module is used (without specific overriding arguments), you mark it with the "is export(:DEFAULT)" trait. o If you want a subroutine to be automatically exported when the module is used (even if the user specifies overriding arguments), you mark it with the "is export(:MANDATORY)" trait. o If the subroutine should also be exported when particular export groups are requested, you add the names of those export groups to the trait's argument list. That's it. WARNING
The syntax and semantics of Perl 6 is still being finalized and consequently is at any time subject to change. That means the same caveat applies to this module. DEPENDENCIES
Requires Filter::Simple AUTHOR
Damian Conway (damian@conway.org) BUGS AND IRRITATIONS
Does not yet handle the export of variables. Comments, suggestions, and patches welcome. COPYRIGHT
Copyright (c) 2003, Damian Conway. All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself. perl v5.8.8 2008-03-12 Export(3pm)