view release on metacpan or  search on metacpan

bin/db-browser  view on Meta::CPAN

=item

Choose the input record separator.

=item

Set the number of columns (I<Col count>) and the width of the column separator (I<Sep width>). I<Col count> expects an
integer of 1 or greater; I<Sep width> expects an integer of 0 or greater.

=item

Set the widths of the columns (1 or greater). For the last column, one can also enter an asterisk (C<*>). An asterisk in
the last column means: Use the remaining part of the row for the last column.

=item

Decide whether leading spaces should be removed. Trailing whitespaces are removed automatically.

=back

Advantages:

=over

=item

Ideal for fixed-length inputs containing only single-width characters.

=back

=back

=over

=item

Spreadsheet::Read

If C<Spreadsheet::Read> is chosen, the default settings from L<Spreadsheet::Read> are utilized.

C<Spreadsheet::Read> will use the first line of the file to auto-detect the separation character if the file is a CSV
file.

C<Spreadsheet::Read::rows> automatically fills up uneven rows, so the filters L</Fill up Rows> and L</Row Groups> have no
significance when C<Spreadsheet::Read> is used.

Advantages:

=over

=item

Automatically detects the separation character for CSV files.

=back

=back

=head3 CSV Options In a

Set C<sep_char>, C<quote_char>, C<escape_char>, C<eol> and C<comment_str>. If left empty, default values are used. For
details on these options, refer to L<Text::CSV_XS>.

=head3 CSV Options In b

Set C<allow_loose_escapes>, C<allow_loose_quotes>, C<allow_whitespace>, C<blank_is_undef>, C<binary>, C<decode_utf8>,
C<empty_is_undef> and C<skip_empty_rows>. For meanings of these options, refer to L<Text::CSV_XS>.

=head3 Settings 'split'

=over

=item

Record Separator

Set the input record separator (regexp).

=item

Trim Record Left

Expects a regex pattern. If set, removes leading characters matching the regexp from each record.

=item

Trim Record Right

Expects a regex pattern. If set, removes trailing characters matching the regexp from each record.

=item

Field Separator

Set the input field separator (regexp).

=item

Trim Field Left

Expects a regex pattern. If set, removes leading characters matching the regexp from each field.

=item

Trim Field Right

Expects a regex pattern. If set, removes trailing characters matching the regexp from each field.

=back

=head3 Input Filter

Enable the input filter menu.

Enabling I<input filter> will cause a second copy of the data to be kept in memory.

=head3 Empty to Null

Set the I<empty_to_null> defaults for the different data source types.

=head3 File Encoding In

How to decode text files.

=head3 Directory History

Set how many searched directories should be saved in the directory history.

A value of C<0> disables the history.

If I<Directory History> is set to C<1> and a directory has been saved, the directory is chosen automatically without
showing the history menu.

=head3 File Filter

This option expects a string as its value, used as a glob pattern.

If I<file> is selected as the data source type, only files matching this glob pattern are part of the available files.

=head3 Hidden Files

If I<file> is selected as the data source type, this setting determines if hidden files are included in the available
files or not.

=head3 Source Type

Set the data source type to C<plain>, C<file>, or C<menu> for C<Insert Into> and for C<Create Table>.

If set to C<menu>, a menu is offered where the user can choose the type of the data source. If set to C<plain> or
C<file>, the respective setting is used directly without any menu.

=head2 Export Data

=head3 Destination Folder

Set the folder where the data to be exported will be saved as a CSV file.

=head3 File Name

=over

=item File Extension CSV

If enabled, the file extension C<csv> is automatically added to the file name.

=item Default File Name

If enabled, the table name will be used as the default file name.

=back

=head3 CSV Options Out a

Set C<sep_char>, C<quote_char>, C<escape_char>, C<eol> and C<undef_str>.

If left empty, default values are used except for C<eol>, which is then set to C<$/> (input record separator).

For the meaning of the different options, see L<Text::CSV_XS>.

=head3 CSV Options Out b

Set C<always_quote>, C<binary>, C<escape_null>, C<quote_binary>, C<quote_empty> and C<quote_space>.

For the meaning of the different options, see L<Text::CSV_XS>.

=head3 File Encoding Out

The encoding of the exported CSV file.

=head2 Miscellaneous

=head3 Warnings

Enable/disable:

=over

=item

C<File::Find> warnings when searching for C<SQLite> databases.

=item

Warnings (e.g., UTF-8 warnings) when printing a table.

=back

=head3 Progress Bar

Set the progress bar threshold. If the number of fields (rows x columns) exceeds the threshold, a progress bar is shown
while preparing the data for output.

=head3 Search

Set the search behavior (C<Ctrl-F>).

=over

=item

disabled

=item

case-insensitive search

=item

case-sensitive search

=back

=head1 CONFIGURATION FILES

To locate the configuration files, run C<db-browser -h> and select I<Path>. The data is saved in JSON format.