in reply to Re^2: Read excel column and compare with array
in thread Read excel column and compare with array

Can you explain in English what this part of your code does?

$rowdata =~ s/EAR-AA-//;

Your input data as shown will not match the replacement.

Replies are listed 'Best First'.
Re^4: Read excel column and compare with array
by snehit.ar (Beadle) on Aug 08, 2017 at 08:53 UTC
    Sorry by mistake,I edited it .

      The return value of the s/// operator is the number of substitutions.

      Use the following instead:

      $variable =~ s/foo/bar/; say $variable;