How to remove empty values from the multi dimensional array

Question

I have array structure like this,

Array
(
    [1] => Array
        (
            [1] => 
            [2] => 
            [3] => 
            [4] => Product
            [5] => Product Name
            ..
            [59] => Color
        )

    [2] => Array
        (
            [1] => 
            [2] => 
            [3] => 1
            [4] => 9155
            ....
            [59] => 
        )

    [3] => Array
        (
            [1] => 
            [2] => 
            [3] => 1
            [4] => 9165
            ...
            [59] => Green
        )

    [4] => Array
        (
            [1] => 
            [2] => 
            [3] => 
            [4] => 
           ...
            [58] => 
            [59] => 
        )
        )

Its reading data from Excel sheets , the issue is when i read data from excel sheet it reads empty rows too, I already tried to ignore empty rows from the excel sheet some how its working (when the excel is created from MSexcel ) but from Google Drive its reading empty rows. So I would like to remove those rows with 1- 59 are blanks. in the above example array with index 4 .

Note that some index have missing values in many sub index but I don't want to remove those, only all sub indexes from 1-59 are blank then that main index (here its 4) needs to remove.

Is there any smart way to remove those array index that have empty values. I not like to iterate all the array and store to another.

possible duplicate. stackoverflow.com/questions/9895130/…

Panama Jack
– Panama Jack

2014-01-23 07:37:32 +00:00
Commented Jan 23, 2014 at 7:37 — Panama Jack
– Panama Jack, Commented Jan 23, 2014 at 7:37

Andreea · Accepted Answer · 2014-01-23 08:09:58Z

2

if you want to remove the index 4 that is an empty array :

array_filter(array_map('array_filter', $array));

answered Jan 23, 2014 at 8:09

Andreea

1391 silver badge13 bronze badges

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

Comments

Linga · Accepted Answer · 2014-01-23 07:39:45Z

2

Use array_map

$array = array_map('array_filter', $array);

answered Jan 23, 2014 at 7:39

Linga

10.6k10 gold badges57 silver badges109 bronze badges

1 Comment

Jobin Over a year ago

its not removing the index 4 its self just removing sub indexes ?

zerokavn · Accepted Answer · 2014-01-23 07:37:54Z

1

let try with array_filter

$entry = array(
             0 => 'foo',
             1 => false,
             2 => -1,
             3 => null,
             4 => ''
          );

print_r(array_filter($entry));

Array
(
    [0] => foo
    [2] => -1
)

answered Jan 23, 2014 at 7:37

zerokavn

1,3331 gold badge9 silver badges10 bronze badges

Comments

Vikas Arora · Accepted Answer · 2014-01-23 07:37:34Z

0

Use array_filter..It will remove all empty values..

array_filter($array);

answered Jan 23, 2014 at 7:37

Vikas Arora

1,6602 gold badges17 silver badges39 bronze badges

Collectives™ on Stack Overflow

How to remove empty values from the multi dimensional array

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related