NicerNewerCar · July 14, 2023 17:51
diff --git a/remove-trailing-commas.py b/remove-trailing-commas.py
 # This script will remove trailing commas from a CSV file, if they exist.
 #@Author: Anthony Lombardi
 #@Date: 07/14/2023

 import os, sys

 if __name__ == "__main__":
    # Grab the file name from the command line
    if len(sys.argv) != 2:
        print("Usage: python remove-trailing-commas.py <file_name>")
        sys.exit(1)
    file_name = sys.argv[1]
    if not os.path.isfile(file_name):
        print("System cannot file the file: " + file_name)
        sys.exit(1)
    
    # Read in the file
    with open(file_name, 'r') as f:
        lines = f.readlines()

    # Remove trailing commas
    new_lines = []
    for line in lines:
        if line[-2] == ',':
            new_lines.append(line[:-2] + '\n')
        else:
            new_lines.append(line)
    
    # Write the new file
    with open(file_name, 'w') as f:
        for line in new_lines:
            f.write(line)
No results found