Hi All, I am new to Perl Hashes. could you please help me on this? I have data like below: Input: <INPUT>

Summary     Detial_Summary  EMC CHECK  abcdefghi AZ_checker 1 20.32
Summary     Detial_Summary  EMC CHECK  abcdefghi AZ_checker 1 24.00
Summary1 Detial_Summary1 EMC CHECK1 abcdefghi AZ_checker 1 20.59
Summary1 Detial_Summary1 EMC CHECK1 abcdefghi AZ_checker 1 24.00
[download]

</INPUT> <OUTPUT> : Expected

Summary
      Detial_Summary
        EMC CHECK  abcdefghi AZ_checker 1 44.32
Summary1
      Detial_Summary1
        EMC CHECK1 abcdefghi AZ_checker 1 24.59
[download]

</OUTPUT> My code:

$fulllookupKey = $field[19].'    '.  $field[20].'    '. $field[17].'  
+  '.$field[10].'    '.$field[23];

    
if (exists($output{$fulllookupKey}))        
    {
       $output{$fulllookupKey}->[0] += $field[4];
           $output{$fulllookupKey}->[1] += $field[21];           
     }
     else
     {
           $output{$fulllookupKey}->[0] = $field[4];
       $output{$fulllookupKey}->[1] = $field[21];
       }     

    }   
    

    for my $key (sort keys %output)
    {        
            my $Summry = substr($key,0,7);
        my $Summary;

        
        if ($load_data{$Summary}) {
        $Summary; = $load_data{$Summary};
        }

        my $Summry1 = substr($key,8,7);
        my $Detial_Summary;

        my $Source = substr($key,16,100);

    
        if ($load_data1{$Detial_Summary}) {
        $Detial_Summary = $load_data1{$Detial_Summary};
        }
         
                print Out $Summary;." \t" . " \t" . " \t". "\t" ."\t" 
+."\t" ."\n";
        print Out " \t" . $Detial_Summary." \t" . " \t" . " \t". "\t" 
+."\t" ."\t" . "\t" ."\n";
        print Out " \t" . " \t" . $Source."\t".sprintf("%.2f", $output
+{$key}->[0])."\t".sprintf("%.2f", $output{$key}->[1])."\n";
        
    }
[download]

<OUTPUT>: (what i got)

Summary
        Detial_Summary
                EMC CHECK  abcdefghi AZ_checker 1 20.32
Summary
        Detial_Summary
                EMC CHECK  abcdefghi AZ_checker 1 24.32
Summary1
        Detial_Summary1
                EMC CHECK1 abcdefghi AZ_checker 1 20.59
Summary1
        Detial_Summary1
                EMC CHECK1 abcdefghi AZ_checker 1 24.00
[download]

</OUTPUT>

---

---

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! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

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:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

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

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