my %doc = %{ $doc }; foreach my $sheet (keys %{ $doc{'_source'}{'sheets'} }) { foreach my $columns (@{ $doc{'_source'}{'sheets'}{$sheet}{'formulates'} }) { my %columns = %{ $columns }; foreach my $one (keys %{ $columns }) { #print $doc{'_source'}{'sheets'}{$sheet}{'formulates'}{$columns}->{$one}{'formula'},$/; #print $doc{'_source'}{'sheets'}{$sheet}{'formulates'}{$columns}{$one}{'formula'},$/; ### I want to replace the formula variable here### } } }