Re: Unable to update correct corrosponding values in excel.

> my @array1 - qw{99999991,99999992,99999993,99999994,99999995};

What is that supposed to mean?

See also previous "your code makes no sense" comment from choroba

Additionally, did you ever bother to show indented code?

update

this is even more cryptic

my @array3 - qw{my emp id,my emp id,my emp id,Not my empployee,Not my empployee,Not my empployee,Not my empployee};

the RHS is not splitted on commas but whitespace

Cheers Rolf
_{(addicted to the Perl Programming Language :)

Wikisyntax for the Monastery}

PS: @All: IMHO this smells like trolling, there is no lazy involuntary way to provide that amount of syntax errors.

Comment on Re: Unable to update correct corrosponding values in excel. Select or Download Code

Replies are listed 'Best First'.
Re^2: Unable to update correct corrosponding values in excel. by GrandFather (Saint) on Feb 11, 2021 at 21:45 UTC
"PS: @All: IMHO this smells like trolling, there is no lazy involuntary way to provide that amount of syntax errors." Nah, I don't think it is trolling. I think it is just someone who has a poor grasp of Perl and no understanding of the quote operators. I'm sure what was intended was: `my @array1 = (99999991, 99999992, 99999993 99999994, 99999995);` [download] If that were the only mistake in the OP's post and if there hadn't been a whole string of posts from the same OP with similar lack of effort shown I'd overlook such obvious errors, provide some help and call it a win. As it is - meh. Optimising for fewest key strokes only makes sense transmitting to Pluto or beyond	[reply] [d/l]
Re^3: Unable to update correct corrosponding values in excel. by LanX (Saint) on Feb 11, 2021 at 21:52 UTC
for the records: I was focused on the `'-'` for assignment, not on the qw problem. update you don't even need strictures to notice that compilation error `DB<295> my $$no1 Can't declare scalar dereference in "my" at` [download] Ż\_(ツ)_/Ż Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery}	[reply] [d/l] [select]
Re^4: Unable to update correct corrosponding values in excel. by chandantul (Scribe) on Feb 16, 2021 at 16:09 UTC
I have fixed this issue by decalring %HASH which will contain 2 values as Key value pair. In order to compare against other.	[reply]


Just another Perl shrine
	PerlMonks