import csv
import io
import re
import requests
from openpyxl import Workbook
from openpyxl.styles import Font
from openpyxl.utils import get_column_letter
from openpyxl.worksheet.table import Table, TableStyleInfo

# Change to your desired file

from pathlib import Path

def get_csv_filenames() -> list[str]:
    """
    Scans the current working directory and returns a list 
    of filenames ending in .csv.
    """
    # Path(".") points to the current working directory
    return [file.name for file in Path(".").glob("*.csv") if file.is_file()]

# Usage
csv_files = get_csv_filenames()
print(csv_files)

inp = "x18_ale3458_gpib_6_2026data_2823A16128.csv"

def remove_target_characters(input_file: str, output_file: str) -> None:
    """
    Reads a file and replaces '\\r\\r' and '|' characters with an empty string (null).
    """
    with open(input_file, 'r', encoding='utf-8') as f:
        content = f.read()

    # Chain replace calls to remove double carriage returns and pipe characters
    cleaned_content = content.replace('\n\n', '').replace('|', ',').replace(';', ',').replace(' ', '').replace('=', ',')

    with open(output_file, 'w', encoding='utf-8') as f:
        print (cleaned_content)
        f.write(cleaned_content)

# Usage
for fcnt in range(0,len(csv_files)):
    inp = csv_files[fcnt]
    outp = inp.split('.csv')[0] + '_filt.csv'
    print (outp)
    remove_target_characters(inp, outp)