comment on

Hello

I have a text file that looks like this:

Nancy Drew!6168!KP!RP!3!0!1824!4950.00
Mark L. Andrews!2488!NG!RP!1!0!1825!1330.00
Sandra C. Brawn!4342!CA!RP!1!0!1826!1330.00
Lucy K. Brown!5424!KP!RP!1!0!1827!1330.00
Susan N. Waterman!3882!UZ!RP!1!631594!1828!1250.00
Naomi Matthews!5390!GA!RP!1!0!1831!1330.00
Lou Nathan Day!7448!UL!RP!3!0!1832!4800.00
Annabel Cadbury!4154!ZR!RP!3!0!1833!4950.00
Bobby Black!7818!GA!NS!1!0!1834!1330.00
Stephen I. Peters!5198!ZR!RP!3!0!1835!4950.00
John Drew!10033!GA!RP!1!0!1839!1250.00
Alfred Berenger!6267!CA!RP!1!0!1840!1330.00  
Laila B. Montgomery!1844!NG!NS!1!0!1841!1330.00
Monica Nathan!1843!NG!NS!1!0!1842!1330.00
Melissa Bayworth!1845!NG!NS!1!0!1843!1330.00
Rupert C. Kissinger!3983!BA!RP!1!0!1845!1330.00
Tory Chapman!7944!BA!RP!3!0!1846!4950.00  
Peter C. Bradman!4430!BA!RP!3!0!1847!4950.00
Dawn Davids!3812!NG!RP!1!0!1848!1330.00
Peter Dwight!0!NG!NS!1!0!1849!1330.00
Yanna Green!1156!CA!RP!3!0!1850!4950.00
Some Person!1856!NG!NS!1!0!1851!1330.00
David Something!2530!KP!RP!1!0!1852!1250.00
Tessa Barry3291!KP!RP!3!0!1853!4800.00
B.N. Stinger!2343!GA!NS!1!0!1854!1330.00 
Lisa Mary Smith!9099!BA!RP!1!0!1856!1330.00
Jonathan Carey!10943!BA!RP!3!756585!1857!4950.00
Samantha Jayworth!7438!NG!RP!1!0!1858!1330.00
Xavier White!10034!GA!RP!3!0!1856!4950.00
[download]

I need to generate a report that looks like this from the above data:

        Daily Meter Works Report         Pg 1
   Date  Tue Apr 13 13:44:18 2010



                                       LOCATION:GA

  RP 1 phase
  __________

 Consumer name      CN.   Sub. TOW  Ph. Chq.no. RN   Amt.

  Naomi Matthews    5390  GA    RP  1    0      1831 1330.00
  John Drew        10033 GA     RP  1    0      1839 1250.00
____________________________________________________________          
+                                                                     
+                                  ####.##

  RP 3 phase
  __________

 Consumer name     CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

 Xavier White      10034 GA   RP   3    0       1856 4950.00
____________________________________________________________
                                                                      
+   ####.##


 NS 1 phase
 __________

 Consumer name    CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

 Bobby Black      7818  GA    NS  1     0      1834 1330.00
 B.N. Stinger     2343  GA    NS  1     0      1854 1330.00 
____________________________________________________________          
+                   ####.##

 NS 3 phase
 __________

 Consumer name   CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

 Some Thing      2346  GA    NS   3    0        1865 4800.00
___________________________________________________________
                                                                      
+   ####.##
############################################################

                                                                      
+ Pg 2


                                  LOCATION:CA

  RP 1 phase
  __________

  Consumer name    CN.   Sub. TOW  Ph. Chq.no. RN   Amt.

  Alfred Berenger  6267  CA   RP   1   0      1840 1330.00  
  Sandra C. Brawn  4342  CA   RP   1   0      1826 1330.00
____________________________________________________________
                                                   ####.##            
+                                              

  RP 3 phase
  __________

 Consumer name   CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

 Yanna Green     1156  CA   RP   3    0       1850 4950.00  
____________________________________________________________
                                                                      
+     ####.##

 NS 1 phase
 __________

 Consumer name      CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

___________________________________________________________
                                                                      
+      ####.##

 NS 3 phase
 __________

 Consumer name   CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 
___________________________________________________________
                                                                      
+    ####.##
############################################################
                                
                                                                      
+ Pg 3


                                LOCATION:UZ

  RP 1 phase
  __________

  Consumer name     CN.  Sub. TOW  Ph. Chq.no.   RN   Amt.

  Susan N. Waterman 3882 UZ   RP   1   631594   1828 1250.00

____________________________________________________________          
+                   ####.##                                           
+                      

  RP 3 phase
  __________

 Consumer name      CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 
____________________________________________________________
                                                                      
+      ####.##


 NS 1 phase
 __________

 Consumer name      CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

____________________________________________________________
                                                                      
+       ####.##

 NS 3 phase
 __________

 Consumer name      CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 
____________________________________________________________
                                                                      
+       ####.##

############################################################

                                                                      
+                                             Pg 4

                                LOCATION:UL

  RP 1 phase
  __________
 Consumer name     CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
  
____________________________________________________________
                                   ####.##                            
+                                   

  RP 3 phase
  __________

 Consumer name    CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 Lou Nathan Day   7448  UL   RP   3    0        1832 4800.00
 ___________________________________________________________
                                                                      
+  ####.##


 NS 1 phase
 __________

 Consumer name    CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

____________________________________________________________
                                                                      
+     ####.##

 NS 3 phase
 __________

 Consumer name   CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 
____________________________________________________________
                                                                      
+     ####.##

############################################################

                                                                      
+                                           Pg 5

                              LOCATION:ZR

  RP 1 phase
  __________

  Consumer name     CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
  
____________________________________________________________          
+                           ####.##                                   
+                            

  RP 3 phase
  __________

 Consumer name     CN.   Sub. TOW  Ph.  Chq.no. RN   Amt.

 Annabel Cadbury   4154  ZR   RP   3    0      1833 4950.00
 Stephen I. Peters 5198  ZR   RP   3    0      1835 4950.00
___________________________________________________________
                                ####.##


 NS 1 phase
 __________

 Consumer name     CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

____________________________________________________________          
+                                                                  ###
+#.##

 NS 3 phase
 __________

 Consumer name      CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 
____________________________________________________________
                                                                      
+       ####.##

############################################################


                                                                      
+                                            Pg 6


                             LOCATION:KP

  RP 1 phase
  __________

  Consumer name   CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

  Lucy K. Brown   5424  KP   RP   1    0       1827 1330.00
  David Something 2530  KP   RP   1    0       1852 1250.00
___________________________________________________________
                                   ####.##                            
+                       

  RP 3 phase
  __________

 Consumer name  CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

 Tessa Barry    3291  KP   RP   3    0       1853 4800.00
 Nancy Drew     6168  KP   RP   3    0       1824 4950.00
____________________________________________________________
                                                                      
+     ####.##


 NS 1 phase
 __________

 Consumer name     CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

___________________________________________________________
                                                                      
+      ####.##

 NS 3 phase
 __________

 Consumer name    CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 
____________________________________________________________
                                                                      
+      ####.##
############################################################


                                                                      
+                                             Pg 7

                             LOCATION:NG

  RP 1 phase
  __________

  Consumer name    CN.   Sub. TOW  Ph.  Chq.no. RN   Amt.

  Mark L. Andrews  2488  NG   RP   1    0      1825 1330.00
  Dawn Davids      3812  NG   RP   1    0      1848 1330.00
 Samantha Jayworth 7438  NG   RP   1    0      1858 1330.00
____________________________________________________________
                                    ####.##                           
+                                     

  RP 3 phase
  __________

 Consumer name     CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 
____________________________________________________________
                                                                      
+      ####.##
    

 NS 1 phase
 __________

 Consumer name      CN.   Sub. TOW  Ph. Chq.no. RN   Amt.

Laila B. Montgomery 1844  NG   NS   1    0     1841 1330.00
 Monica Nathan      1843  NG   NS   1    0     1842 1330.00 
 Melissa Bayworth   1845  NG   NS   1    0     1843 1330.00
 Peter Dwight       0     NG   NS   1    0     1849 1330.00
 Some Person        1856  NG   NS   1    0     1851 1330.00
____________________________________________________________
                                                                      
+      ####.##

 NS 3 phase
 __________

 Consumer name    CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.
 
___________________________________________________________
                                                                      
+      ####.##

############################################################

                                                                      
+                                             Pg 8

                              LOCATION:BA

  RP 1 phase
  __________

  Consumer name     CN.   Sub. TOW  Ph.  Chq.no. RN   Amt.

Rupert C. Kissinger 3983  BA   RP   1    0      1845 1330.00
  Lisa Mary Smith   9099  BA   RP   1    0      1856 1330.00
____________________________________________________________
                                      ####.##                         
+                                      

  RP 3 phase
  __________

 Consumer name    CN.   Sub. TOW  Ph.  Chq.no. RN   Amt.

 Tory Chapman     7944  BA   RP   3     0     1846 4950.00  
 Peter C. Bradman 4430  BA   RP   3     0     1847 4950.00
 Jonathan Carey  10943  BA   RP   3 756585    1857 4950.00
____________________________________________________________
                                                                      
+     ####.##


 NS 1 phase
 __________

 Consumer name    CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

____________________________________________________________
                                                                      
+      ####.##

 NS 3 phase
 __________

 Consumer name      CN.   Sub. TOW  Ph.  Chq.no.   RN   Amt.

____________________________________________________________
                                                                      
+      ####.##

############################################################
                           
                     Grand total             ######.##      


                                                                      
+                                   Signature
[download]

In reply to Complex reports using format statement by perl_seeker

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.