如何将两个csvs / tab分隔成一个csv与php？

Assuming the column names are on the first line of your file this should work:

$txt = glob('files/*.txt*');
$csv = glob('files/*.csv*');
$test = array();
$headers = array();
if (($handle = fopen($csv[0], "r")) !== FALSE) {
  while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $num = count($data);
    if (empty($headers)) {
      for ($c=0; $c < $num; $c++) {
        $headers[$c] = $data[$c];
      }
    }
    else {
      $line = array();
      for ($c = 0; $c < $num; $c++) {
        $line[$headers[$c]] = $data[$c];
      }
      $test[] = $line;
    }
  }
}

if (($handle = fopen($csv[0], "r")) !== FALSE) {
  while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $num = count($data);
    $line = array();
    for ($c = 0; $c < $num; $c++) {
      $line[$headers[$c]] = $data[$c];
    }
    $test[] = $line;
  }
}

That should give you an array like

[0] => Array
(
       [Edit] => y
       [Event] => Carolina Panthers PSL
       [Venue] => Bank of America Stadium,
       ...
[1] => Array
(

       [Edit] => y
       [Event] => Florida
       [Venue] => Washington Mutual ,
...

Then you can use usort on the array to sort it by the Event key with a custom callback. See the docs page for that function for loads of examples, or try this:

function my_sort($a, $b) {
  return strcmp($a['Event'], $b['Event']);
}
usort($test, 'my_sort');

Something along the lines of the code below should work for you I believe.

<?php
// Opens files
$file1 = glob("files/*.txt");
$file1 = $file1[0];
$f1 = file("files/$file1");
$file2 = glob("files/*.csv");
$file2 = $file2[0];
$f2 = file("files/$file2");

// Creates counter and storage arrays for each column
$c = 0;
$col1 = array();
$col2 = array();
$col3 = array();

// goes through each of the first files lines
foreach ($f1 as $row => $data)
{
    // changes tabs for commas
    $data .= str_replace("\t",",",$data);
    // splits the string into the 3 columns in different arrays
    list($col1[$c],$col2[$c],$col3[$c]) = explode(",",$data);
    $c++;
}

foreach ($f2 as $row2 => $data2)
{
    if ($row2 != 0)
    {
        // splits the string into the 3 columns in different arrays
        list($col1[$c],$col2[$c],$col3[$c]) = explode(",",$data2);
        $c++;
    }
}
// Sort by column 2, the event
asort($col2);

// First column is headers
$realOutput = $col1[0].",".$col2[0].",".$col3[0]."
";

// Add them in sorted order by column 2
foreach ($col2 as $key => $val)
{
    if ($key != 0)
        $realOutput .= $col1[$key].",".$col2[$key].",".$col3[$key]."
";
}

echo $realOutput;

?>

EDITED to account for columns not being in the same order, and avoid column headers being present in sorted data. This still relies on column headers being the same (including identical case). Also fixed SORTDESC (should be SORT_DESC)

$txt = glob('files/*.txt*');
$csv = glob('files/*.csv*');
$rows = $events = array();

// Get data into rows, not columns
if (($handle = fopen($csv[0], "r")) !== FALSE) {
    // Get column headers
    $headers = fgetcsv($handle, 1000, ",");
    // Get rest of rows
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $row = array();
        foreach ($data as $k => $v) $row[$headers[$k]] = $v;
        $rows[] = $row;
    }
    fclose($handle);
}

if (($handle = fopen($txt[0], "r")) !== FALSE) {
    // Get column headers
    $headers = fgetcsv($handle, 1000, "\t");
    while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE) {
        $row = array();
        foreach ($data as $k => $v) $row[$headers[$k]] = $v;
        $rows[] = $row;
    }
    fclose($handle);
}

// Prepare the sort column for array_multisort()
foreach ($rows as $key => $row) {
  $events[$key] = $row['Event'];
}

// Sort it
array_multisort($events, SORT_DESC, $rows);

// Open the output file
$outFile = fopen('outfile.csv','w');

// Put the column headers back
fputcsv($outFile, array('Edit','Event','Venue'), ',');

// Write the data
foreach ($rows as $row) {
  fputcsv($outFile, $row, ',');
}

// Close the file
fclose($outFile);