Stream and convert BCP format files
Project description
BCP Reader
A reader for BCP-format data files. BCP files are similar to CSV files but contain a multi-character line and field delimiters. The default delimiters used are:
- field delimiter:
@**@
- line delimiter:
*@@*
Python's csv module can only deal with single character delimiters, so this
module has a reader
function and DictReader
class which should be drop-in
replacements for python's csv
module equivalents.
Credits
The author of the main method is Gertjan van den Burg of the Alan Turing Institute. It was based on a method originally developed by David Kane at NCVO.
Installation
Install with pip install bcp-reader
Usage
The module can be used by importing from the bcp
module in a python script:
import bcp
with open('path_to_bcp_file.bcp') as f:
bcpreader = bcp.reader(f)
for row in bcpreader:
print(row)
# ["Value 1", "Value 2"]
with open('path_to_bcp_file.bcp') as f:
bcpreader = bcp.DictReader(f, fieldnames=["field 1", "field 2"])
for row in bcpreader:
print(row)
# {"field 1": "Value 1", "field 2": "Value 2"}
You can also use it via the command line to convert a BCP file to CSV:
bcp path_to_bcp_file.bcp > csv_output.csv
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for bcp_reader-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9dae2ea7e3218b5fcf27ddd8de83f775a77618bf2259166ca7ecb7f073b59907 |
|
MD5 | 1e4602f3d2e3489244d5ea56b0e1012b |
|
BLAKE2b-256 | 2412329f1468230a50cdb61aff5add9cd66c383e2c4876eadd2084ae95569f17 |