bcp-exorcist 0.2.1

Cleans up SQL Server's bcp Export

🧹 bcp-exorcist

Fix malformed CSVs exported with broken delimiters and newlines from legacy systems.

bcp-exorcist is a Python extension written in Rust that "exorcises" broken CSV files using uncommon delimiters and newline characters. It processes files in memory-efficient batches and transforms them into proper, escaped CSV files ready for analysis or ingestion.

✨ Features

• Efficient batch processing of large CSV files.
• Handles broken CSVs with custom delimiters (e.g. \x1E) and newlines (e.g. \x1D).
• Recovers valid CSV structure with correct escaping.
• Rust-powered speed with Python simplicity.

📦 Installation

pip install bcp-exorcist

☦️ Example

from bcp_exorcist import exorcize_csv

try:
    exorcize_csv("path/to/broken.csv", delim=b'\x1E', newline=b'\x1D', chunk_size=1024 * 1024)
    print("Exorcism completed successfully!")

except TypeError:
    print("`delim` and `newline` must be single-byte values.")
except FileNotFoundError:
    print("Check that the filepath is correct.")
except RuntimeError as e:
    print(f"Exorcism failed: {e}")