A awk script that will convert a CSV file exported from Outlook Express into one easily consumable by Thunderbird

oe_csv_to_tb_csv.awk

BEGIN {
    FS= ","
}

/$^/ { }
NF {
    if(NR == 1) {
        a[1] = "First Name"
        a[2] = "Last Name"
    } else {
        split($1, a, " ")
    }

    print a[1]","a[2]","$1",,"$2",,,"$14","$8",,,,"$3",,"$4","$6","$5","$7","$9",,"$10","$12","$11","$13","$16
}