Guest User

Untitled

a guest
Nov 23rd, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. my $te = HTML::TableExtract->new( count => $anal_table );
  2. $te->parse($$html);
  3. foreach my $ts ( $te->tables ) {
  4. my @rows = @{ $ts->rows };
  5. my @headings = @{ $rows[0] };
  6.  
  7. for ( my $i = 1 ; $i < scalar @rows ; $i++ ) {
  8. my @row = @{ $rows[$i] };
  9. my $date;
  10. if ( $row[0] =~ /(SALES|earnings)/i ) {
  11. for ( my $j = 1 ; $j < scalar @headings ; $j++ ) {
  12. push( @headerRow, $1 . ' ' . $headings[$j] );
  13. }
  14. while ( @{ $rows[ $i + 1 ] }[0] =~ /ending/i ) {
  15. @row = @{ $rows[ ++$i ] };
  16. $date = $row[0];
  17. $date =~ s/^.*?Ending\s//g;
  18.  
  19. # Now call sub to convert date using date hash
  20. my $iso_date = $self->date_conv($date);
  21. $date = $iso_date;
  22. for ( my $j = 1 ; $j < scalar @row ; $j++ ) {
  23. push( @{ $data{$date} }, $row[$j] );
  24. }
  25. }
  26. }
  27. }
  28. }
Add Comment
Please, Sign In to add comment