finding the longest successful Mars mission using awk

[AkshatSoni26]

The answer for this is XRT-421-ZQP

BEGIN {
    FS = "|"
    max_duration = 0
    security_code = ""
    mission_details = ""
}

/^[0-9]/ && $3 ~ /Mars/ && $4 ~ /Completed/ {
    # Clean up fields
    gsub(/[ \t]+/, "", $1)
    gsub(/[ \t]+/, "", $2)
    gsub(/[ \t]+/, "", $6)
    gsub(/[ \t]+/, "", $8)
    
    duration = $6 + 0  # Convert to number
    
    if (duration > max_duration) {
        max_duration = duration
        security_code = $8
        mission_details = "Date: " $1 " | Mission ID: " $2 " | Duration: " duration " days"
    }
}

END {
    print "LONGEST SUCCESSFUL MARS MISSION:"
    print "================================="
    print mission_details
    print "Security Code: " security_code
    print ""
    print "Final Answer: " security_code
}