Search results for "distribution:App-CSVUtils dist::Declare"
csv2td - Return an enveloped aoaos table data from CSV data
Read more about "table data" in App::td, which comes with a CLI td to munge table data....
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv2vcf - Create a VCF from selected fields of the CSV
You can set which CSV fields to use for name, cell phone, and email. If unset, will guess from the field name. If that also fails, will warn/bail out....
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-map - Return result of Perl code for every row
This is like Perl's "map" performed over rows of CSV. In $_, your Perl code will find the CSV row as an arrayref (or, if you specify "-H", as a hashref). $main::row is also set to the row (always as arrayref). $main::rownum contains the row number (2...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
App::CSVUtils::csv2td - Return an enveloped aoaos table data from CSV data
PERLANCAR/App-CSVUtils-1.034
-
02 Feb 2024 04:15:39 UTC
csv2csv - Convert CSV to CSV (alias for csv-csv)
Why convert CSV to CSV? When you want to change separator/quote/escape character, for one. Or you want to remove header or add one. Example: # in.csv name,age andi,12 budi,13 % csv-csv in.csv --output-sep-char ';' name;age andi;12 budi;13...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-avg - Output a summary row which are arithmetic averages of data rows
Non-numbers will be assumed to be 0. Example: # students.csv name,age andi,13 budi,12 chandra,12 dudi,12 % csv-avg students.csv name,age 0,12.25 % csv-avg students.csv --with-data-row name,age andi,13 budi,12 chandra,12 dudi,12 0,12.25...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-sum - Output a summary row which are arithmetic sum of data rows
Non-numbers will be assumed to be 0. Example: # students.csv name,score andi,130 budi,120 chandra,120 dudi,120 % csv-sum students.csv name,score 0,490 % csv-sum students.csv --with-data-row name,score andi,130 budi,120 chandra,120 dudi,120 0,12.25...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-csv - Convert CSV to CSV
Why convert CSV to CSV? When you want to change separator/quote/escape character, for one. Or you want to remove header or add one. Example: # in.csv name,age andi,12 budi,13 % csv-csv in.csv --output-sep-char ';' name;age andi;12 budi;13...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-cmp - Compare two CSV files value by value
This utility is modelled after the Unix command "cmp"; it compares two CSV files value by value and ignore quoting (and can be instructed to ignore whitespaces, case difference). If all the values of two CSV files are identical, then utility will exi...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-uniq - Report or omit duplicated values in CSV
(No description)...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-dump - Dump CSV as data structure (array of array/hash)
This utility reads CSV file then dumps it as a text table, or as JSON if you specify the "--format=json" or "--json" option....
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-info - Show information about CSV file (number of rows, fields, etc)
PERLANCAR/App-CSVUtils-1.034
-
02 Feb 2024 04:15:39 UTC
csv-trim - Trim (remove leading & trailing whitespace) values and/or fields in CSV
Whitespace includes space, tab, and newline....
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-pick - Return one or more random rows from CSV (shorter name for csv-pick-rows)
PERLANCAR/App-CSVUtils-1.034
-
02 Feb 2024 04:15:39 UTC
csv-shuf - Shuffle CSV rows (shorter name for csv-shuf-rows)
This is basically like Unix command "shuf" except it does not shuffle the header row....
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-grep - Select (only output) row(s) where Perl expression returns true
This is like Perl's "grep" performed over rows of CSV. In $_, your Perl code will find the CSV row as an arrayref (or, if you specify "-H", as a hashref). $main::row is also set to the row (always as arrayref). $main::rownum contains the row number (...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-sort - Sort CSV rows (shorter name for csv-sort-rows)
This utility sorts the rows in the CSV. Example input CSV: name,age Andy,20 Dennis,15 Ben,30 Jerry,30 Example output CSV (using "--by-field +age" which means by age numerically and ascending): name,age Dennis,15 Andy,20 Ben,30 Jerry,30 Example output...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv2paras - Convert CSV to paragraphs
This utility converts CSV format like this: name,email,phone,notes bill,bill@example.com,555-1236,+ lisa,lisa@example.com,555-1235,from work jimmy,jimmy@example.com,555-1237, into paragraphs format like this, which resembles (but not strictly follows...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-split - Split CSV file into several files
Will output split files xaa, xab, and so on. Each split file will contain a maximum of "lines" rows (options to limit split files' size based on number of characters and bytes will be added). Each split file will also contain CSV header. Warning: by ...
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC
csv-quote - Make sure values of CSV are quoted
This is a simple wrapper to csv-csv. It's equivalent to: % csv-csv --output-always-quote --output-quote-empty ......
PERLANCAR/App-CSVUtils-1.034 - 02 Feb 2024 04:15:39 UTC