in reply to incrementing a number

If your columns always match the regular expression [A-Z]+\d+, you can match and increment only the numeric portion:

$fields[12] =~ s/(\d+)/ $1 + 1 /e;

In Section Seekers of Perl Wisdom