use HTML::Entities qw( encode_entities ); use URI::Escape qw( uri_escape ); my %seen_users; my %seen_numbers; for my $rec (@$sqlinfo){ next if $seen_users{ $rec->{user} }++ || $seen_numbers{ $rec->{number} }++; $userfinal .= sprintf( '