Got it working now.

 grep { /Country/ && /City1/ && /Street1/ && ! /name1/ }

Still wondering why my first grep (all most similar as above) in perl was not working the first time. But with the provided grep all was working to an sertain extend. Detected during the loop output that not all in _DATA_ was always correct (massive flat file) ...lol..., causing in some occations the array to be empty with the exclude. Therefore added an additional step in the grep options within the foreach loop.

@dataset4 = grep ( !/$name/, @dataset3);
if (@dataset4 eq '' || @dataset4 eq '0') {
    $outputmove = 'NONE';
    last;
}
@dataset5 = split ( / +/, $dataset4[0] );
$outputmove = $dataset5[0];

[download]

Will move my data coming weekend to MySQL... thx to all whom replied.

In reply to Re: Need to multi grep and grep exclude in perl. by Anonymous Monk
in thread Need to multi grep and grep exclude in perl. by Frits

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.