Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Reorder the sequence of line groupings/QIF export

Login to Discuss or Reply to this Discussion in Our Community

 
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

LEARN ABOUT DEBIAN

grisbi

GRISBI(1)						      General Commands Manual							 GRISBI(1)

NAME

       grisbi - Personal finance tracking program based on GTK

SYNOPSIS

       grisbi [options] file...

DESCRIPTION

       This  manual  page  documents  briefly  the grisbi command.  This manual page was written for the Debian GNU/Linux distribution because the
       original program does not have a manual page.

       grisbi is a personal finance tracking program with a lot of features:
	* bank, cash and passive accounts
	* several accounts at the same time
	* several currencies, including euro
	* arbitrary currency for every operation
	* money interchange fees
	* switch to euro account per account
	* describe operations with relatives, categories, sub-categories, notes
	* transfers between accounts, even for accounts of different currencies
	* reconciled balances
	* automatic and manual expiries
	* automatic recall of last operation for every relatives
	* nice and easy user interface
	* online user manual
	* QIF import/export

OPTIONS

       These programs follow the usual GNU command line syntax, with long options starting with  two  dashes  (`-').   A  summary  of  options	is
       included below.

       -?, --help
	      Show summary of options.

       --version
	      Show version of program.

AUTHOR

       This manual page was written by Benjamin Drieu <benj@debian.org>, for the Debian GNU/Linux system (but may be used by others).

								  August 22, 2002							 GRISBI(1)