in reply to Re^3: Remove $
in thread Remove $

it turns the $/ into a return

Z:\Scripts>perl -w $.txt
db1
SQL/GEMINI/StoredProcs/pboValidateClientRefNo_ClientID.sql
db1
SQL/GEMINI/StoredProcs/pboValidateClientRefNo_ClientID.sql

Z:\Scripts>

Replies are listed 'Best First'.
Re^5: Remove $
by FunkyMonk (Chancellor) on Aug 27, 2007 at 17:36 UTC
    It isn't the print that's doing the interpolation of $/, it's happening inside $Sheet->Cells($rownum,"B")->{'Value'};

    In which case I'd just hack it back to what it should be with (something like) $cellval = s!\n!/!g;

[reply]
[d/l]
[select]
      DANG!! It was that simple? Pheww. Looks like my issue is solved. Thank you to everyone for all your help!
[reply]

In Section Seekers of Perl Wisdom