Skip to content

Latest commit

 

History

History
55 lines (40 loc) · 1.4 KB

README.md

File metadata and controls

55 lines (40 loc) · 1.4 KB

oxfordcsv

About

Why use plain old CSV when you can use Oxford CSV?

Compatible with both Python 3. Tested on 3.9.19.

Usage

To use oxfordcsv, simple pipe CSV data into it: python3 oxfordcsv.py < infile.csv

$ cat sample.csv
id,name,address,city,state
1,Alice,213 Elk St.,New York,NY
2,Bob,84924 1st Ave.,Boulder,CO
3,Cheryl,99376 Apple Pkwy. Apt. #1632,Los Angeles,CA
4,Dean,153 8th St. So.,Houston,TX
$ python3 oxfordcsv.py < sample.csv > oxford.csv
$ cat oxford.csv
id,name,address,city,and state
1,Alice,213 Elk St.,New York,and NY
2,Bob,84924 1st Ave.,Boulder,and CO
3,Cheryl,99376 Apple Pkwy. Apt. #1632,Los Angeles,and CA
4,Dean,153 8th St. So.,Houston,and TX
$

For those on PowerShell, you can run it like this:

PS D:\Projects\oxfordcsv> Get-Content .\sample.csv | python.exe .\oxfordcsv.py | Out-File oxford.csv

Do you want stricter adherence to the rules of the English language? The -E argument will cause extra spaces to be added:

$ python3 oxfordcsv.py -E < sample.csv
id, name, address, city, and state
1, Alice, 213 Elk St., New York, and NY
2, Bob, 84924 1st Ave., Boulder, and CO
3, Cheryl, 99376 Apple Pkwy. Apt. #1632, Los Angeles, and CA
4, Dean, 153 8th St. So., Houston, and TX

License

MIT