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 SUNOS

asadmin-export

asadmin-export(1AS)						   User Commands					       asadmin-export(1AS)

NAME

       asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode

SYNOPSIS

       export  [ name=value  [ name=value]*]

       Marks  a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values
       as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable  name	is
       displayed.  If  the  export  command  is  used  without	any arguments, a list of all the exported variables and their values is displayed.
       Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and  set  as  exported  variables
       within asadmin. Unexported environment variables cannot be read by the asadmin utility.

OPERANDS

       name=value	       variable name and value for automatic export to the environment to be used by subsequent commands.

       Example 1: Using export to list the environment variables

       asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password
       asadmin> export AS_ADMIN_PREFIX=server1.jms-service
       asadmin> export //to list the environment variables that are set
       AS_ADMIN_HOST=bluestar
       AS_ADMIN_PORT=8000
       AS_ADMIN_USER=admin
       AS_ADMIN_PASSWORD=********
       AS_ADMIN_PREFIX=server1.jms-service

       Where:  the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host
       is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-unset(1AS), asadmin-multimode(1AS)

J2EE 1.4 SDK							    March 2004						       asadmin-export(1AS)