Hello,
I have a Perl script that reads in an Excel spread sheet and formats the values into a text file. I am having trouble with one column that can have numbers or letters. Excel left justifies the values that start with a letter and right justifies the values that contain only a number(s). I thought this bit of code would get rid of spaces, but it is not working:

my $hrbc_empdoe=uc(@$ref_array[2]);
my $hrbc_empdoe =~ s/\s//gi;
print "$hrbc_empdoe \n";

$s1 =  "  92";
$s1 =~ s/\s+//;
print "$s1\n";

The problem would seem to be the repeated my declaration -- you are creating a new temporary variable which masks the previous value (... I guess).

Lesson: use strict; use warnings; -- always.

Hi era,
You are correct. Once I removed that the problem was solved. Thank you for your response and the tip.