Shell Programming and Scripting

Should be something like:

Code:

awk '/TITLE OF ACCOUNT :/{s=$0;getline; s=s RS $0;next}
/A\/C NO. TYPE\/CCY :/{f=$(NF-1)}f{print s > f;print > f}' file

Another solution (assumes formfeed as data delimitor) :

Code:

awk '
FNR==1 || /\f/{ 
   memo = 1
}
/A\/C NO\. TYPE\/CCY/ {
   filename = $(NF-1);
   $0 = Text ORS $0;
   memo = 0;
   Text = "";
}
 memo { 
   Text = Text (memo ? ORS : "") $0 ;
}
! memo { 
  print > filename;
 }
' input_file

Jean-Pierre.

Thru this the first 2 lines are printing after every line. i.e.


aigles code is generating right output.

Regards,

Hassan

Franklin52 code is true but need to be modified to the below to give the correct result.


Code:

Code:

gawk '/TITLE OF ACCOUNT :/{s=$0;getline; s=s RS $0;next}
/A\/C NO. TYPE\/CCY :/{f=$(NF-1) ; print s > f}f{print >> f}' file

you can use nawk gawk or /usr/xpg4/bin/awk

BR

Thanks Ahmad for your correction. I did not mean that it was wrong, how can I say bcz he is the first one who replied me.

Any I make changes as per your suggestion i.e.

Code:

awk '/TITLE OF ACCOUNT :/{s=$0;getline; s=s RS $0;next}/A\/C NO. TYPE\/CCY :/{f=$(NF-1) ; print s > f}f{print >> f}' abc4.txt

and found correct result.

I also noticed that while using the code suggested by aigles is making little strange output, Put first 2 lines of a the single text file in every newly created file, and the original data of that account no is displaying in the end of every file. i.e.

==================1st New File =======================
TITLE OF ACCOUNT : MUHAMMAD NASIM STATEMENT DATE : 18/11/2009 00:18:07
MUHAMMAD NASIM STATEMENT PERIOD : 01-NOV-09 - 30-NOV-09
501 EMAN ANENUE SHAHRA-E-FARMA N A/C NO. TYPE/CCY : 01311111111182 010/USD
WEHARI PAGE : 1
091-495, 5130, 082318



OPENING BALANCE AS OF Nov 01, 2009 480.990
-----------------------------------------------------------------------------------------------------------------------------------------------------------
TRAN DT EFF DT TRAN BR TRANSACTION DESCRIPTION CHEQUE/VOUCHER/ATM NO. WITHDRAWAL DEPOSIT BALANCE

----------------------------------------------------------------------------------------------------------------------------------------------------------

ENDING BALANCE AS OF Nov 30, 2009 480.990
AVAILABLE BALANCE AS OF Nov 30, 2009 480.990

TRANSACTION SUMMARY
NUMBER OF TRANSACTIONS 0







*** AS PER SBP MANDATE PLEASE
SUBMIT AN ATTESTED COPY OF YOUR
CNIC IMMEDIATELY **
** FOR BANK'S PROFILE PLEASE
VISIT OUR WEBSITE
"WWW.MYBANK.COM"

==================2nd New File =======================
TITLE OF ACCOUNT : MUHAMMAD NASIM STATEMENT DATE : 18/11/2009 00:18:07
MUHAMMAD NASIM STATEMENT PERIOD : 01-NOV-09 - 30-NOV-09
H #39,B-1BAZ PH-9999996 BAHARAN A/C NO. TYPE/CCY : 01241111111143 010/USD
SIALKOT PAGE : 1
091-27 / 08878



OPENING BALANCE AS OF Nov 01, 2009 3,737.000
-----------------------------------------------------------------------------------------------------------------------------------------------------------
TRAN DT EFF DT TRAN BR TRANSACTION DESCRIPTION CHEQUE/VOUCHER/ATM NO. WITHDRAWAL DEPOSIT BALANCE

----------------------------------------------------------------------------------------------------------------------------------------------------------

ENDING BALANCE AS OF Nov 30, 2009 3,737.000
AVAILABLE BALANCE AS OF Nov 30, 2009 910.000

TRANSACTION SUMMARY
NUMBER OF TRANSACTIONS 0







*** AS PER SBP MANDATE PLEASE
SUBMIT AN ATTESTED COPY OF YOUR
CNIC IMMEDIATELY **
** FOR BANK'S PROFILE PLEASE
VISIT OUR WEBSITE
"WWW.MYBANK.COM"






TITLE OF ACCOUNT : MUHAMMAD KHAN STATEMENT DATE : 18/11/2009 00:18:07
MOHAMMAD KHAN STATEMENT PERIOD : 01-NOV-09 - 30-NOV-09


The red color text of 2nd new file must appeared in the start of this file but starting two lines of every new file displaying the first files' two lines.

Regards,

Hassan