Date ,Who,Frm, To , By, Flgt, doy, FFpts\n__________________________________";
foreach ($output_with_ff as $line) {
    echo "$line\n";
}

echo "\nNote airline 'tr' is train, 'rd' is road trip,
Airline code/custom name used for train stn.\n
The item 'K' = 'K M, 'C' = 'J C' aka 'S M'.\n
The K and C travel together, 'Home Port' is HKG.\n
FFpts column: shows frequent flyer program when points credited, blank = missed/ineligible\n
Total lines processed: " . count($output_with_ff) . "
";

// Save to CSV - now uses $output_with_ff
function saveToCsv($output, $filename) {
    $file = fopen($filename, 'w');
    foreach ($output as $line) {
        if (strpos($line, ',') !== false) {
            fputcsv($file, array_map('trim', explode(',', $line)));
        }
    }
    fclose($file);
}

 $filename = 'iata_' . $THIS_YEAR . 'out.csv'; 
saveToCsv($output_with_ff, $filename);











// ATTEMPT TO ALSO SAVE A JSON RECORD

// Split into lines and clean up
$lines = array_filter(array_map('trim', explode("\n", $data)));

// Output array
$records = [];

foreach ($lines as $line) {
    // Skip empty lines and placeholder lines starting with "__"
    if (empty($line) === 0) {
        continue;
    }

    // Split by spaces, but preserve full remainder after 5th field
    $parts = preg_split('/\s+/', $line, 6); // Limit to 6 parts

    if (count($parts) < 5) {
        continue; // Skip malformed lines
    }

    // Extract first 5 fields
    $traveller           = trim($parts[0]);
    $ticket_no           = trim($parts[1]);
    $from_to_airline     = trim($parts[2]);
    $flight_no           = trim($parts[3]);
    $julian_date_class    = trim($parts[4]);
    $remainder           = isset($parts[5]) ? trim($parts[5]) : '';

    // Build record
    $records[] = [
        'Traveller'           => $traveller,
        'Ticket_N0'           => $ticket_no,
        'From_To_Airline'     => $from_to_airline,
        'Flight_No'           => $flight_no,
        'Julian_Date_Class_Other' => $julian_date_class,
        'Remainder_Of_Data'   => $remainder
    ];
}

// Save to JSON file in the same directory
$jsonFile = __DIR__ . '/iata25_Codes.json';
$jsonData = json_encode($records, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE);

if (file_put_contents($jsonFile, $jsonData) !== false) {
    echo "Successfully saved " . count($records) . " records to $jsonFile\n";
} else {
    echo "Failed to write JSON file.\n";
}

?>