compare and filter values in array in php

Question

i have a csv file containing telephone numbers.

There is about 15 numbers with the area code +44 and 20 numbers beginning with +64 (there are about 40 area codes). i need to echo one number of each set and drop the remains.

i loaded all the content using fgetcsv(). but i cant find a way to do the filtering part. can some please give me an idea how to sort this out in php?

What about area codes that have one or three letters?

hakre
– hakre

2011-06-09 12:59:05 +00:00
Commented Jun 9, 2011 at 12:59 — hakre
– hakre, Commented Jun 9, 2011 at 12:59

Andrei Sfat · Accepted Answer · 2011-06-09 15:41:41Z

1

Try this replace $numbers with your csv file content.

$numbers = array('+1134124', '+11412421', '+41125125','+41125124','+41125144','+41155124','+44125124','+44155124');                          

$final = array();

$received = array();

foreach($numbers as $snKey => $snValue )
{

    $snCode = substr($snValue,0,3);

    if(in_array($snCode,$received))
        continue;
    else
    {
        $received[] = $snCode;
        $final[] = $snValue;
    }
}
print_r($final);

edited Jun 9, 2011 at 15:41

Andrei Sfat

8,6265 gold badges56 silver badges71 bronze badges

answered Jun 9, 2011 at 13:13

Shashank Patel

4593 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

deceze · Accepted Answer · 2011-06-09 12:49:15Z

1

$numbers = array('+1134124', '+11412421', '+41125125', …);

$filtered = array_reduce($numbers, function ($f, $num) {
    return $f + array(substr($num, 0, 3) => $num);
}, array());

answered Jun 9, 2011 at 12:49

deceze♦

525k89 gold badges806 silver badges954 bronze badges

Comments

Haim Evgi · Accepted Answer · 2011-06-09 12:51:19Z

0

you can filter them while read line from the file

like:

 $array = array(); 
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            $prefix = substr($data, 0, 3);
            if(in_array($prefix, $array))
               continue;
            else{
               $array[] = prefix;
               # save the line or echo
            } 

     }

answered Jun 9, 2011 at 12:51

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Collectives™ on Stack Overflow

compare and filter values in array in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related