PHP .txt to array tab delimited

Question

Hello. im having this code:

public function parse_reports($filename)
{    
    $result = array();
    $fp = fopen($filename, "r");
    if (($headers = fgetcsv($fp, 0, "\t")) !== FALSE)
      if ($headers)
        while (($line = fgetcsv($fp, 0, "\t")) !== FALSE) 
          if ($line)
            if (sizeof($line)==sizeof($headers))
              $result[] = array_combine($headers,$line);
    fclose($fp);
    return $result; //return result
}

and my array list its like:

Array
( //test array1
    [0] => Array
        ( //array 0
            [VNUM] => 1
            [LOCALE_NAME] => Yang
        )

    [1] => Array
        ( //array 1
            [VNUM] => 2
            [LOCALE_NAME] => Ελληνική Έκδοση
        )

    [2] => Array
        ( //array 2
            [VNUM] => 10
            [LOCALE_NAME] => Σπαθί+0
        )

    [3] => Array
        ( //array 3
            [VNUM] => 11
            [LOCALE_NAME] => Σπαθί+1
        )

what i need is for array numbers to take VNUM Number for example looks like this:

Array
(
    [1] => Array
        (
            [VNUM] => 1 //this take the value of VNUM
            [LOCALE_NAME] => Yang
        )

    [2] => Array
        (
            [VNUM] => 2 //this take the value of VNUM
            [LOCALE_NAME] => Ελληνική Έκδοση
        )

    [10] => Array //this take the value of VNUM
        (
            [VNUM] => 10 //this take the value of VNUM
            [LOCALE_NAME] => Σπαθί+0
        )

    [11] => Array
        (
            [VNUM] => 11 //this take the value of VNUM
            [LOCALE_NAME] => Σπαθί+1
        )

as you can see what i need is to change arrays id with the VNUM that my .txt header have...if someone could help me with this i would be very happy! thank you! if you need any more details feel free to ask me

Fixed thanks to Eddie

Answer 1

You can use array_reduce

Note: I have to use implode and explode for this since there are hidden/special characters on text file.

Like:

public function parse_reports($filename)
{    
    $result = array();
    $fp = fopen($filename, "r");
    if (($headers = fgetcsv($fp, 0, "\t")) !== FALSE)
      if ($headers)
        while (($line = fgetcsv($fp, 0, "\t")) !== FALSE) 
          if ($line)
            if (sizeof($line)==sizeof($headers))
              $result[] = array_combine($headers,$line);
    fclose($fp);

    //To use the VNUM as the key
    $result = array_reduce($result,function($c,$v){
        $val = explode( ",", implode( ",", $v ));
        $c[ $val[0] ] = $v;
        return $c;
    }, array());

    return $result;
}

---

Getting this result

Array
(
    [1] => Array
        (
            [VNUM] => 1
            [LOCALE_NAME] => Yang
        )

    [2] => Array
        (
            [VNUM] => 2
            [LOCALE_NAME] => Ελληνική Έκδοση
        )

    [10] => Array
        (
            [VNUM] => 10
            [LOCALE_NAME] => Σπαθί+0
        )

    [11] => Array
        (
            [VNUM] => 11
            [LOCALE_NAME] => Σπαθί+1
        )

    [12] => Array
        (
            [VNUM] => 12
            [LOCALE_NAME] => Σπαθί+2
        )

    [13] => Array
        (
            [VNUM] => 13
            [LOCALE_NAME] => Σπαθί+3
        )
......

Doc: http://php.net/manual/en/function.array-reduce.php

Answer 2

You could use array_column() like...

return array_column ($result, null, 'VNUM'); //return result

This uses the VNUM column as an index to the array.

Update: It's possible that your column headers may include whitespace and therefore array_column() won't work as it is, but if you try...

public function parse_reports($filename)
{    
    $result = array();
    $fp = fopen($filename, "r");
    if (($headers = fgetcsv($fp, 0, "\t")) !== FALSE)
      if ($headers)
        $headers = array_map("trim", $headers );
        while (($line = fgetcsv($fp, 0, "\t")) !== FALSE) 
          if ($line)
            if (sizeof($line)==sizeof($headers))
              $result[] = array_combine($headers,$line);
    fclose($fp);
    return array_column ($result, null, 'VNUM'); //return result
}

This will clean up any header value in the array_map() call.

Update (2):

Looks as though there is something odd with the headers - one last attempt...

return array_column($result, null, $headers[0]);

Sample data...

VNUM    LOCALE_NAME
1   Yang
2   Ελληνική Έκδοση
10  Σπαθί+0
11  Σπαθί+1
12  Σπαθί+2
13  Σπαθί+3
14  Σπαθί+4
15  Σπαθί+5
16  Σπαθί+6
17  Σπαθί+7
18  Σπαθί+8
19  Σπαθί+9