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 |
|
BLAKE2-256 | 2412329f1468230a50cdb61aff5add9cd66c383e2c4876eadd2084ae95569f17 |