/ 
App-CSVUtils-0.999_1
River stage one • 3 direct dependents • 4 total dependents

Changes for version 0.999_1 - 2022-12-14

  • Incompatible changes
    • Rename variable given to eval codes '$main::field_idxs' to '$main::fields_idx'.
    • [cli csv-sort-fields] --by-code code now receives [$field_name, $field_idx] instead of just $field_name.
    • [cli csv-select-rows] row number spec now means *data row* number spec, e.g. 1 means the first *data* row.
    • [cli csv-select-rows] Will not output header row if there is no rows matching spec.
    • [cli csv-setop] Will not output header row if there is no result data rows.
    • [cli csv-convert-to-hash] Row number now means *data* row number, e.g. 1 means the first row number.
  • New features
    • Add utility: csv-gen.
  • Internals
    • Make API modular. It is now possible and easier to create a new utility without modifying the "core" routine. No more "core" routine.
  • Enhancements
    • [cli csv-select-fields] Add option --show-selected-fields, like in csv-delete-fields.
  • Removed
    • Remove alias CLI's: csv2csv (only csv-csv now provided), dump-csv (only csv-dump now provided).
    • Reading from & writing to URL feature is removed to remove dependency to LWP::UserAgent. One can use piping to/from clipget/clipadd to read from/write to clipboard. There are other tools for reading/writing to URL addresses.
  • Documentation & UX
    • Add example(s) to all utilities.
    • Add -a as shortcut for --include-all-fields, -A for --exclude-all-fields.

Documentation

App::CSVUtils::Manual::Cookbook
App::CSVUtils cookbook
App::CSVUtils::Manual::Tips
App::CSVUtils tips/tricks
csv-add-fields
Add one or more fields to CSV file
csv-avg
Output a summary row which are arithmetic averages of data rows
csv-concat
Concatenate several CSV files together, collecting all the fields
csv-convert-to-hash
Return a hash of field names as keys and first data row as values
csv-csv
Convert CSV to CSV
csv-delete-fields
Delete one or more fields from CSV file
csv-dump
Dump CSV as data structure (array of array/hash)
csv-each-row
Run Perl code for every data row
csv-fill-template
Substitute template values in a text file with fields from CSV rows
csv-freqtable
Output a frequency table of values of a specified field in CSV
csv-gen
Generate CSV data using Perl code
csv-get-cells
Get one or more cells from CSV
csv-grep
Only output row(s) where Perl expression returns true
csv-info
Show information about CSV file (number of rows, fields, etc)
csv-list-field-names
List field names of CSV file
csv-lookup-fields
Fill fields of a CSV file from another
csv-map
Return result of Perl code for every row
csv-munge-field
Munge a field in every row of CSV file with Perl code
csv-munge-row
csv-pick
Return one or more random rows from CSV
csv-pick-fields
Select one or more random fields from CSV
csv-pick-rows
Return one or more random rows from CSV
csv-replace-newline
Replace newlines in CSV values
csv-select-fields
Only output selected field(s)
csv-select-rows
Only output of specified row numbers
csv-setop
Set operation (union/unique concatenation of rows, intersection/common rows, difference of rows) against several CSV files
csv-shuf
Shuffle CSV rows
csv-shuf-fields
Shuffle CSV fields
csv-shuf-rows
Shuffle CSV rows
csv-sort
Sort CSV rows
csv-sort-fields
Sort CSV fields
csv-sort-rows
Sort CSV rows
csv-split
Split CSV file into several files
csv-sum
Output a summary row which are arithmetic sum of data rows
csv-transpose
Transpose a CSV
csv2ltsv
Convert CSV to LTSV
csv2td
Return an enveloped aoaos table data from CSV data
csv2tsv
Convert CSV to TSV
csv2vcf
Create a VCF from selected fields of the CSV
tsv2csv
Convert TSV to CSV

Modules

App::CSVUtils
CLI utilities related to CSV
App::CSVUtils::csv2td
Return an enveloped aoaos table data from CSV data
App::CSVUtils::csv2vcf
Create a VCF from selected fields of the CSV
App::CSVUtils::csv_add_fields
Add one or more fields to CSV file
App::CSVUtils::csv_avg
Output a summary row which are arithmetic averages of data rows
App::CSVUtils::csv_concat
Concatenate several CSV files together, collecting all the fields
App::CSVUtils::csv_convert_to_hash
Return a hash of field names as keys and first data row as values
App::CSVUtils::csv_csv
Convert CSV to CSV
App::CSVUtils::csv_delete_fields
Delete one or more fields from CSV file
App::CSVUtils::csv_dump
Dump CSV as data structure (array of array/hash)
App::CSVUtils::csv_each_row
Run Perl code for every data row
App::CSVUtils::csv_fill_template
Substitute template values in a text file with fields from CSV rows
App::CSVUtils::csv_freqtable
Output a frequency table of values of a specified field in CSV
App::CSVUtils::csv_gen
Generate CSV data using Perl code
App::CSVUtils::csv_get_cells
Get one or more cells from CSV
App::CSVUtils::csv_grep
Only output row(s) where Perl expression returns true
App::CSVUtils::csv_info
Show information about CSV file (number of rows, fields, etc)
App::CSVUtils::csv_list_field_names
List field names of CSV file
App::CSVUtils::csv_lookup_fields
Fill fields of a CSV file from another
App::CSVUtils::csv_map
Return result of Perl code for every row
App::CSVUtils::csv_munge_field
Munge a field in every row of CSV file with Perl code
App::CSVUtils::csv_munge_row
App::CSVUtils::csv_pick_fields
Select one or more random fields from CSV
App::CSVUtils::csv_pick_rows
Return one or more random rows from CSV
App::CSVUtils::csv_replace_newline
Replace newlines in CSV values
App::CSVUtils::csv_select_fields
Only output selected field(s)
App::CSVUtils::csv_select_rows
Only output of specified row numbers
App::CSVUtils::csv_setop
Set operation (union/unique concatenation of rows, intersection/common rows, difference of rows) against several CSV files
App::CSVUtils::csv_shuf_fields
Shuffle CSV fields
App::CSVUtils::csv_shuf_rows
Shuffle CSV rows
App::CSVUtils::csv_sort_fields
Sort CSV fields
App::CSVUtils::csv_sort_rows
Sort CSV rows
App::CSVUtils::csv_split
Split CSV file into several files
App::CSVUtils::csv_sum
Output a summary row which are arithmetic sum of data rows
App::CSVUtils::csv_transpose
Transpose a CSV

Other files