I ve spent the last few weeks staring at vendor files, and I m convinced that "CSV" stands for Constantly Slightly Variable.
I was trying to ingest a few product catalogs recently. One supplier sends prices as 12.99 USD, the next uses $12,99, and the third just puts 1299 and expects you to guess the decimals. I ended up spending more time writing "one-off" cleanup scripts than actually using the data.