from FCC_database.file_read_backwards import FileReadBackwards

with FileReadBackwards("FCC_database/EN.dat",encoding="utf-8") as in_file, open("calldata.txt", 'w') as out_file:
    callsign_list = []
    skipped_list = []
    for line in in_file:
        line_list = line.split('|')
        if line_list[4] in callsign_list:
            skipped_list.append(line_list[4])
        else:
            callsign_list.append(line_list[4])
            out_file.write(line_list[4] + "," + line_list[17] + "," + line_list[7] + "\n")

    with open("callsign.lst", 'w') as list_file:
        for each in skipped_list:
            list_file.write(each + "\n")