.\" DO NOT MODIFY THIS FILE!  It was generated by help2man 1.49.2.
.TH APOP_TEXT_TO_DB "1" "September 2022" "Apophenia (Debian )" "Apophenia"
.SH NAME
apop_text_to_db \- command line utility to convert a text file into a database table
.SH SYNOPSIS
.B apop_text_to_db
[\fI\,-d delimiters\/\fR] \fI\,text_file table_name dbname\/\fR
.SH DESCRIPTION
If the input text file name is a single dash, \-, then read from STDIN.
Input must be plain ASCII or UTF\-8.
.TP
\fB\-d\fR
the single\-character delimiters to use, e.g., \fB\-d\fR " ," or \fB\-d\fR "\et" (which you
will almost certainly have to write as \fB\-d\fR "\e\et") (default: "|,\et", meaning
that any of a pipe, comma, or tab will delimit separate entries)
.TP
\fB\-nc\fR
data does not include column names
.TP
\fB\-n\fR regex
case\-insensitive regular expression indicating Null values (default: NaN)
.TP
\fB\-m\fR
use a MySQL database (default: SQLite)
.TP
\fB\-f\fR
fixed width field ends: \fB\-f\fR"3,8,12,17" (first char is one, not zero)
.TP
\fB\-u\fR
mysql username
.TP
\fB\-p\fR
mysql password
.TP
\fB\-r\fR
data includes row names
.TP
\fB\-v\fR
verbosity
.TP
\fB\-N\fR
a comma\-separated list of column names: \fB\-N\fR"apple,banana,carrot,durian"
.TP
\fB\-en\fR
if table exists, do nothing and exit
.TP
\fB\-ed\fR
if table exists, retain the table, delete all data, refill with the new data (i.e., call 'delete * from your_table')
.TP
\fB\-eo\fR
if table exists, overwrite the table from scratch (deleting the previous table entirely)
.TP
\fB\-ea\fR
if table exists, append new data to the existing table
.TP
\fB\-h\fR
display this help and exit