A proposal: fill stackexchange with Miller

[aborruso]

Hi,
I think Miller is one of the best tool to work on text structured data. Unfortunately (it seems to me) it is not very known.

Than I'm doing a simple thing: search for Miller matter in stack exchange (as this) and write answers Miller related. I'm still a Miller "yellow belt" 😄 , but I started with this, this, this and this one.

I think that all those who often use this fantastic tool could do it.

What do you think about?

[aborruso]

Two useful things:

• a better search output list https://stackexchange.com/filters/358478/csv?sort=newest
• the RSS feed of this https://stackexchange.com/feeds/tagsets/358478/csv?sort=newest

[aborruso]

I'm adding some new reply:

• https://unix.stackexchange.com/questions/492434/sed-delete-csv-column-if-exists/492534#492534
• https://unix.stackexchange.com/questions/486655/parsing-csv-that-has-multiple-line-values-with-carriage-returns/491748#491748
• https://unix.stackexchange.com/questions/472858/csv-file-group-and-sum-values-based-on-first-pattern-of-each-value/491732#491732
• https://unix.stackexchange.com/questions/476023/organizing-data-by-a-header/491731#491731
• https://unix.stackexchange.com/questions/484274/add-a-pattern-before-the-delimiter/491730#491730
• https://unix.stackexchange.com/questions/430199/output-a-header-label-in-data-field-in-miller/492541#492541
• https://unix.stackexchange.com/questions/238046/stack-data-from-multiple-delimited-files-into-one-with-variable-columns/492859#492859
• https://unix.stackexchange.com/questions/457091/convert-data-from-ldif-file-to-csv/492863#492863
• https://unix.stackexchange.com/questions/318446/cut-an-array-column-and-join-an-another-column-to-a-csv-file/492865#492865
• https://unix.stackexchange.com/questions/493551/join-two-files-based-on-a-common-field/493629#493629
• https://unix.stackexchange.com/questions/493552/compare-columns-in-2-files-and-put-information-according-to-file-1/493627#493627
• https://unix.stackexchange.com/questions/494259/getting-file-as-rows-and-columns-data-matrix/494273#494273
• https://askubuntu.com/questions/1109590/extracting-numbers-whose-lengths-are-fixed-from-text-file/1109598#1109598
• https://unix.stackexchange.com/questions/494778/how-remove-duplicate-names-and-print-array-after-unique-names/494801#494801
• https://unix.stackexchange.com/questions/494803/how-can-i-remove-repeated-lines-taking-into-consideration-the-text-from-just-a-c/494874#494874
• https://unix.stackexchange.com/questions/495005/sql-operation-on-csv-file-using-bash-or-shell/495026#495026
• https://unix.stackexchange.com/questions/7698/command-to-layout-tab-separated-list-nicely/495416#495416
• https://unix.stackexchange.com/questions/7425/is-there-a-robust-command-line-tool-for-processing-csv-files/495417#495417
• https://stackoverflow.com/questions/54273438/merging-two-csv-files-cant-get-rid-of-newline/54274740#54274740
• https://stackoverflow.com/questions/54273622/convert-entry-log-csv-to-list-of-names-based-on-whether-they-entered-on-each-d/54275979#54275979
• https://stackoverflow.com/questions/54277980/split-large-csv-file-into-several-based-on-condition/54280028#54280028
• https://askubuntu.com/questions/1109777/move-specific-column-from-csv-file-in-front-select-column-by-name/1111476#1111476
• https://stackoverflow.com/questions/54312302/need-to-replace-specific-text-in-csv-file-using-batch-script/54314203#54314203
• https://stackoverflow.com/questions/54317248/converting-from-field-value-format-to-csv/54317558#54317558
• https://stackoverflow.com/questions/54353222/how-to-re-pivot-data-in-bash/54356470#54356470
• https://stackoverflow.com/questions/54363812/add-trailing-commas-to-ensure-csv-rows-have-same-number-of-columns/54368097#54368097
• https://unix.stackexchange.com/questions/497716/to-get-average-of-columns-for-all-the-entries-whose-first-column-entries-are-dup/497884#497884
• https://unix.stackexchange.com/questions/498132/removing-duplicate-entries-and-replacing-it-with-comma-bash/498150#498150
• https://unix.stackexchange.com/questions/499352/how-to-generate-a-pivotal-table/499444#499444
• https://stackoverflow.com/questions/54594951/delete-all-line-after-a-specific-date/54596152#54596152
• https://stackoverflow.com/questions/54661258/remove-rows-based-on-values-in-a-column/54664933#54664933
• https://stackoverflow.com/questions/54679856/text-processing-csv-file-truncate-digits-without-rounding/54680559#54680559
• https://stackoverflow.com/questions/54678054/whats-the-best-practice-to-scan-a-text-file-on-linux-for-quality-checking-patt/54680780#54680780
• https://unix.stackexchange.com/questions/501550/how-to-extract-fields-from-a-csv-i-e-comma-separated-where-some-of-the-fields-ha/501635#501635
• https://unix.stackexchange.com/questions/502368/output-to-last-column-depending-on-first-column-if-is-greater-less-than-or-equa/502377#502377
• https://stackoverflow.com/questions/17752072/combining-multiple-csv-files/54855980#54855980
• https://unix.stackexchange.com/questions/504891/how-could-i-painlessly-split-or-reverse-last-first-within-a-record-in-mille/504978#504978
• https://askubuntu.com/questions/1122680/comparing-the-content-and-produce-new-file/1124822#1124822
• https://stackoverflow.com/questions/55124218/merge-2-csv-files-via-batch/55125480#55125480
• https://stackoverflow.com/questions/55149498/how-can-i-count-the-rows-of-a-csv-with-only-the-linux-terminal/55151056#55151056
• https://unix.stackexchange.com/questions/507719/creating-new-columns/507778#507778
• https://askubuntu.com/questions/1127670/delete-multiple-columns-using-awk-or-sed/1127741#1127741
• https://stackoverflow.com/questions/55368375/copy-first-column-to-new-column-renamed-header-at-end-in-csv-with-mac-terminal/55371953#55371953
• https://stackoverflow.com/questions/51233041/how-to-format-csv-into-multiline-newline-delimited-plain-text-output-using-csvki/55529867#55529867
• https://unix.stackexchange.com/questions/511658/getting-values-from-comma-seperated-file/511706#511706
• https://unix.stackexchange.com/questions/511773/how-to-compare-two-csv-files-and-display-unique-records/511831#511831
• https://stackoverflow.com/questions/55602163/is-there-a-way-to-parse-multiple-lines-to-a-single-line-by-merging-duplicates-an/55627219#55627219
• https://unix.stackexchange.com/questions/512169/how-to-rename-output-of-split-command-to-match-the-first-word-in-each-line/512178#512178
• https://stackoverflow.com/questions/55685497/split-huge-csv-by-columns-with-miller/55687128#55687128
• https://stackoverflow.com/questions/55743810/check-if-value-of-column-1-exists-anywhere-in-column-2-write-result-to-column-3/55750730#55750730
• https://superuser.com/questions/1432161/how-to-filter-value-in-csv-with-batch-and-show-the-output-to-txt/1432211#1432211
• https://stackoverflow.com/questions/41842304/reshaping-from-wide-to-long-format/56073938#56073938
• https://unix.stackexchange.com/questions/520031/pivot-file-values/520468#520468
• https://stackoverflow.com/questions/56257428/parsing-csv-which-contains-json/56261697#56261697
• https://unix.stackexchange.com/questions/520492/merging-csv-files-with-key-columns/520513#520513
• https://unix.stackexchange.com/questions/522046/how-to-convert-a-3-column-csv-file-into-a-table-or-matrix/522550#522550
• https://stackoverflow.com/questions/56440446/how-to-unstack-data-from-one-column-to-multiple-column/56441388#56441388
• https://unix.stackexchange.com/questions/523479/convert-rows-into-columns-in-bash-shell-script/523735#523735
• https://unix.stackexchange.com/questions/524169/comparing-two-csv-files-and-write-into-3rd-file/524212#524212
• https://askubuntu.com/questions/1153856/csv-to-tsv-without-replacing-commas-within-quotes/1153968#1153968
• https://unix.stackexchange.com/questions/527563/how-to-add-new-column-with-constant-value-in-a-text-file/527614#527614
• https://gis.stackexchange.com/questions/328580/finding-maximum-distribution-between-multiple-columns/328617#328617
• https://datascience.stackexchange.com/questions/55879/file-format-where-column-names-are-repeated-on-each-row/55917#55917
• https://unix.stackexchange.com/questions/532043/unable-to-simply-use-tr-to-convert-a-tab-delimited-variable-file-to-a-comma-deli/532119#532119
• https://unix.stackexchange.com/questions/532092/split-file-lines-based-on-first-field/532123#532123
• https://stackoverflow.com/questions/57226479/conditional-append-of-strings-on-fields-in-a-csv-file/57231210#57231210
• https://unix.stackexchange.com/questions/533490/joining-merging-csv-files-that-do-not-share-all-their-headers-column/533601#533601
• https://unix.stackexchange.com/questions/450915/merging-multiple-csv-files-for-matching-and-non-matching-columns/533605#533605
• https://stackoverflow.com/questions/57388777/get-difference-between-two-csv-files-based-on-column-using-bash/57389381#57389381
• https://unix.stackexchange.com/questions/535351/extract-file-with-two-matched-strings-at-the-same-time/535378#535378
• https://unix.stackexchange.com/questions/535518/nested-loops-for-text-file/535591#535591
• https://stackoverflow.com/questions/57586507/reading-large-csv-and-splitting-it-into-smaller-chunks/57587030#57587030
• https://stackoverflow.com/questions/57672681/bash-grep-lines-from-csv-based-on-column-3-if-length-is-6-chars-numbers/57673347#57673347
• https://stackoverflow.com/questions/57874901/how-to-split-csv-rows-then-duplicate-that-row/57877936#57877936
• https://stackoverflow.com/questions/57978050/how-to-flatten-this-json-as-a-tsv/57978379#57978379
• https://unix.stackexchange.com/questions/542539/replace-the-content-of-specific-cells-in-a-tsv-file-with-the-edited-content-of-o/542565#542565
• https://unix.stackexchange.com/questions/543221/given-pattern-replacement-with-comma/543311#543311
• https://unix.stackexchange.com/a/544059/195582
• https://unix.stackexchange.com/questions/543726/split-the-content-of-a-specific-column-with-variable-number-of-strings/544063#544063
• https://unix.stackexchange.com/questions/544163/csv-dataset-to-text-dataset/544166#544166
• https://stackoverflow.com/questions/58128032/splitting-a-column-into-two-columns-base-on-a-separator-in-csv-file-using-awk/58146864#58146864
• https://askubuntu.com/questions/1178129/compare-2-cols-when-1st-col-2nd-col-remove-2nd-col/1178661#1178661
• https://askubuntu.com/questions/1178592/count-number-of-different-name-in-a-file/1178739#1178739
• https://unix.stackexchange.com/questions/545343/extract-columns-with-certain-characters-and-store-them-in-separate-file/545356#545356
• https://stackoverflow.com/questions/58271333/create-a-csv-file-from-json-data-using-jq/58277093#58277093
• https://unix.stackexchange.com/questions/545788/compare-2-comma-separated-files-and-output-the-difference/545937#545937
• https://stackoverflow.com/questions/58327627/how-to-split-a-csv-file-such-that-first-column-stays/58330927#58330927
• https://unix.stackexchange.com/questions/546910/merge-csv-files-based-on-id-even-when-unmatched-ids-and-indefinite-number-of-col/547056#547056
• https://stackoverflow.com/questions/45484459/how-to-edit-a-cell-in-a-csv-file/58412431#58412431
• https://stackoverflow.com/questions/58431657/how-to-parse-a-complicated-csv-file-with-in-r/58433337#58433337
• https://stackoverflow.com/questions/58459956/edit-a-csv-column-through-another-column/58461626#58461626
• https://stackoverflow.com/questions/58603534/how-to-import-nested-json-file-into-google-sheets-with-some-missing-keyvalue-pa/58630961#58630961
• https://askubuntu.com/questions/1184179/how-to-rename-the-exisitng-cell-names-based-on-number-of-their-occurnaces-in-a-p/1185056#1185056
• https://stackoverflow.com/questions/58627542/remove-quotes-from-all-columns-with-awk/58638816#58638816
• https://unix.stackexchange.com/questions/550676/sum-of-even-and-odd-numbers-of-odd-and-even-lines/550736#550736
• https://stackoverflow.com/questions/58786303/transform-csv-file-into-a-flat-file-for-pandas/58790398#58790398
• https://unix.stackexchange.com/questions/551162/combine-file-data-sort-on-chromosome-position-next-to-each-other-column-vise/551417#551417
• https://stackoverflow.com/questions/58677751/how-to-merge-rows-in-openrefine/58814336#58814336
• https://stackoverflow.com/questions/58961650/merge-content-of-two-csv-file-side-by-side-in-bash/58964168#58964168
• https://stackoverflow.com/questions/59041187/sorting-csv-file-based-on-column-2-only/59041272#59041272
• "How to add new columns to CSVs with the same text in all lines" https://askubuntu.com/questions/1193534/how-to-add-new-columns-to-csvs-with-the-same-text-in-all-lines/1193544#1193544
• "csv text-processing question" https://unix.stackexchange.com/questions/555643/csv-text-processing-question/555667#555667
• "how to keep rows if there are a certain number of observations based on the first column?" https://unix.stackexchange.com/questions/558147/how-to-keep-rows-if-there-are-a-certain-number-of-observations-based-on-the-firs/558258#558258
• "Add Column to CSV based on Filename" https://stackoverflow.com/questions/59422250/batch-script-add-column-to-csv-based-on-filename/59426724#59426724
• "Concatenating columns of the same csv file to create a new column with a new heading" https://unix.stackexchange.com/a/558359/195582
• "How can I replace strings in a given column of a table using awk and regex?" https://unix.stackexchange.com/a/558362/195582
• "JSON -> csv creating header line and padding header if found empty field" https://unix.stackexchange.com/questions/507005/json-csv-creating-header-line-and-padding-header-if-found-empty-field/560690#560690
• "How to convert yaml to csv file format?" https://askubuntu.com/questions/941477/how-to-convert-yaml-to-csv-file-format/1201270#1201270
• "Shard CSV based on time values" https://stackoverflow.com/questions/59673777/shard-csv-based-on-time-values/59682909#59682909
• "How to parse Stdout as a mix of CSV and JSON?" https://unix.stackexchange.com/questions/561467/how-to-parse-stdout-as-a-mix-of-csv-and-json/561576#561576
• "How to use awk for joining two csv using a key column and write a another csv" https://unix.stackexchange.com/questions/560266/how-to-use-awk-for-joining-two-csv-using-a-key-column-and-write-a-another-csv/561580#561580
• "How to extract column name (header) from a CSV file which contains the max value in a row?" https://unix.stackexchange.com/questions/217817/how-to-extract-column-name-header-from-a-csv-file-which-contains-the-max-value/562350#562350
• "Need help to JOIN two CSV files" https://stackoverflow.com/questions/59913035/need-help-grepping-from-csv/59916638#59916638
• "Applying sort -u to one specific column in a CSV file?" https://stackoverflow.com/questions/59924061/applying-sort-u-to-one-specific-column-in-a-csv-file/59946495#59946495
• "compare the values of 2 files and merge the similar entries" https://stackoverflow.com/questions/60024879/compare-the-values-of-2-files-and-merge-the-similar-enteries/60025241#60025241
• "How to split one column into two based on a certain character?" https://unix.stackexchange.com/questions/565537/how-to-split-one-column-into-two-based-on-a-certain-character/565541#565541
• "SSV/CSV Manipulation: Calculate Ratios" https://unix.stackexchange.com/a/566055/195582
• "Column transposition according to two values" https://unix.stackexchange.com/questions/566096/column-transposition-according-to-two-values/566098#566098
• "Bash - Removing empty columns from .csv file" https://stackoverflow.com/questions/60098400/bash-removing-empty-columns-from-csv-file/60134937#60134937
• "Merge 3 .csv into one file with different number of columns" https://superuser.com/questions/1523440/merge-3-csv-into-one-file-with-different-number-of-columns/1524270#1524270
• "csv file - remove line feed in the middle of string" https://stackoverflow.com/questions/60177576/csv-file-remove-line-feed-in-the-middle-of-string/60178030#60178030
• "How to get data for past hour, 6h, 24h from CSV log file with awk, sed or other?" https://stackoverflow.com/questions/60365724/how-to-get-data-for-past-hour-6h-24h-from-csv-log-file-with-awk-sed-or-other/60371907#60371907
• "How to add a value of the variable at the beginning of a csv file" https://stackoverflow.com/questions/60379142/how-to-add-a-value-of-the-variable-at-the-beginning-of-a-csv-file/60390718#60390718
• "Convert JSON array into CSV", https://unix.stackexchange.com/questions/570548/convert-json-array-into-csv/570571#570571
• "How to combine TSV file" https://askubuntu.com/a/1217868/796708
• "How to put pivot table using Shell script" https://stackoverflow.com/questions/61186811/how-to-put-pivot-table-using-shell-script/61204513#61204513
• "Bash script to add double quotes in .CSV comma delimited file" https://stackoverflow.com/questions/61220101/bash-script-to-add-double-quotes-in-csv-comma-delimited-file/61244777#61244777
• "How can I delete from a file every second and fourth comma separated word using sed?" https://unix.stackexchange.com/questions/581068/how-can-i-delete-from-a-file-every-second-and-fourth-comma-separated-word-using/581072#581072
• "How to append additional text found in a duplicate entry to the original text" https://superuser.com/questions/1540589/how-to-append-additional-text-found-in-a-duplicate-entry-to-the-original-text/1543477#1543477
• "Concatenate matching ids from two files, with other columns from both files" https://unix.stackexchange.com/questions/583795/concatenate-matching-ids-from-two-files-with-other-columns-from-both-files/583821#583821
• "I want to convert list of json files to csv with only specific attributes" https://stackoverflow.com/questions/61819131/i-want-to-convert-list-of-json-files-to-csv-with-only-specific-attributes/61835027#61835027
• "CSV Filtering a column with mixed data types" https://stackoverflow.com/a/62099705/757714
• "(AWK) Csv separating same variables in columns into different files" https://unix.stackexchange.com/questions/590911/awk-csv-separating-same-variables-in-columns-into-different-files/591041#591041
• "GROUP BY CSV columns in bash" https://stackoverflow.com/questions/62252413/group-by-csv-columns-in-bash/62258153#62258153
• "vlookup using UNIX shell" https://unix.stackexchange.com/questions/592517/vlookup-using-unix-shell/592980#592980
• "Querying csv files like sql" https://unix.stackexchange.com/questions/593939/querying-csv-files-like-sql/594193#594193
• "Filling in blank spaces in the first column of a csv file using Bash / awk" https://unix.stackexchange.com/questions/601138/filling-in-blank-spaces-in-the-first-column-of-a-csv-file-using-bash-awk/602193#602193
• "Log search within date range" https://unix.stackexchange.com/questions/604588/log-search-within-date-range/604736#604736
• "Find value from one csv in another one (like vlookup) in bash (Linux)" https://stackoverflow.com/questions/10697724/find-value-from-one-csv-in-another-one-like-vlookup-in-bash-linux/63666127#63666127
• "Manipulate csv file using bash script or python, converting certain columns into rows" https://askubuntu.com/a/1273008/796708
• "Handle CSV data: Separate data with a comma" https://stackoverflow.com/questions/63999865/handle-csv-data-separate-data-with-a-comma/64012427#64012427
• "How to “Partial-Transpose-and-Duplicate” rows in a CSV with a CSV command line tool" https://stackoverflow.com/questions/64220427/how-to-partial-transpose-and-duplicate-rows-in-a-csv-with-a-csv-command-line-t/64240640#64240640
• "Csv trasform one row in 4 row" https://stackoverflow.com/questions/64322327/csv-trasform-one-row-in-4-row/64332420#64332420
• "Grep the data only (-o) and the first column", https://unix.stackexchange.com/questions/615597/grep-the-data-only-o-and-the-first-column/617644#617644
• "sorting a csv file with 3 columns", https://askubuntu.com/questions/1277136/sorting-a-csv-file-with-3-columns/1295780#1295780
• "How do I print all lines of a file with duplicate values in a certain column", https://unix.stackexchange.com/questions/255563/how-do-i-print-all-lines-of-a-file-with-duplicate-values-in-a-certain-column/621876#621876
• "Parsing through Bash", https://stackoverflow.com/questions/65208302/parsing-through-bash/65213118#65213118
• "I need an efficient method to combine thousands of csv files", https://unix.stackexchange.com/questions/625168/i-need-an-efficient-method-to-combine-thousands-of-csv-files/625194#625194
• "Compare csv files based on column value", https://stackoverflow.com/questions/65592814/compare-csv-files-based-on-column-value/65608417#65608417
• "How to rearrange columns when you don't know their initial positions (UNIX, BASH)", https://superuser.com/questions/1618362/how-to-rearrange-columns-when-you-dont-know-their-initial-positions-unix-bash/1618583#1618583
• "Sort multiple columns in csv including date stored as dd/mm/yyyy", https://unix.stackexchange.com/a/632204/195582
• "How to get the pivot lines from two tab-separated files?", https://stackoverflow.com/questions/66121376/how-to-get-the-pivot-lines-from-two-tab-separated-files/66167539#66167539
• "grep output from long to wide", https://unix.stackexchange.com/questions/634364/grep-output-from-long-to-wide/634376#634376
• "Adding CSV layer to QGIS when X and Y fields are the same", https://gis.stackexchange.com/questions/388039/adding-csv-layer-to-qgis-when-x-and-y-fields-are-the-same/388042#388042
• "How to split the data from two columns based on two different delimiters in a Redshift database?", https://stackoverflow.com/questions/66359957/how-to-split-the-data-from-two-columns-based-on-two-different-delimiters-in-a-re/66412025#66412025
• "How to convert a CSV (with quote) to TSV?", https://stackoverflow.com/questions/66422944/how-to-convert-a-csv-with-quote-to-tsv/66435748#66435748
• "converting space separated file into csv format in linux", https://stackoverflow.com/questions/66456419/converting-space-separated-file-into-csv-format-in-linux/66477278#66477278
• "Bash to send variable value to csv?", https://unix.stackexchange.com/questions/650580/bash-to-send-variable-value-to-csv/650724#650724
• "awk extract columns that meet condition", https://unix.stackexchange.com/a/651415/195582
• "Is it possible to rename multiple columns of a CSV to empty columns when using miller?", https://stackoverflow.com/a/68452078/757714
• "How to merge multiple Mac excel files all with headers that are the same but out of order", https://superuser.com/questions/1666750/how-to-merge-multiple-mac-excel-files-all-with-headers-that-are-the-same-but-out/1666899#1666899
• "How to extract columns by names from CSV file?", https://unix.stackexchange.com/questions/663701/how-to-extract-columns-by-names-from-csv-file/663792#663792

[aborruso]

It would be useful that someone of you vote for some of these replies :)

[aborruso]

And we have the first accepted answer https://unix.stackexchange.com/questions/430199/output-a-header-label-in-data-field-in-miller/492541#492541 (the one related to #215 )

[aborruso]

The second miller answer chosen as the right one :) https://unix.stackexchange.com/questions/492434/sed-delete-csv-column-if-exists/492534#492534

[aborruso]

The third miller answer chosen as the right one :)
https://unix.stackexchange.com/questions/494259/getting-file-as-rows-and-columns-data-matrix/494273#494273

[aborruso]

I have had a +50 bounty for a Miller answer in Ask Ubuntu :)

[aborruso]

Another Miller answer chosen as the right one:
https://stackoverflow.com/a/54317558/757714

[aborruso]

Another Miller answer chosen as the right one:
https://unix.stackexchange.com/questions/504891/how-could-i-painlessly-split-or-reverse-last-first-within-a-record-in-mille/504978#504978

[aborruso]

Another Miller answer chosen as the right one (it's not a great reply):
https://stackoverflow.com/questions/55149498/how-can-i-count-the-rows-of-a-csv-with-only-the-linux-terminal/55151056#55151056

[aborruso]

Another Miller answer chosen as the right one:
https://stackoverflow.com/questions/55368375/copy-first-column-to-new-column-renamed-header-at-end-in-csv-with-mac-terminal/55371953#55371953

[aborruso]

Another Miller answer chosen as the right one:
https://stackoverflow.com/questions/51233041/how-to-format-csv-into-multiline-newline-delimited-plain-text-output-using-csvki/55529867#55529867

[aborruso]

Another Miller answer chosen as the right one:
https://stackoverflow.com/questions/55685497/split-huge-csv-by-columns-with-miller/55687128#55687128

[aborruso]

Another Miller answer chosen as the right one:
https://stackoverflow.com/a/56441388/757714

[f3rn4nd0-c354r]

How about a miller tag? I don't have enough points (Awarded at: 1,500 reputation)

[aborruso]

Another answer, in which I use Miller, chosen as the right one: "Parsing CSV with AWK, returning fields to bash var with line breaks"
https://unix.stackexchange.com/questions/706410/parsing-csv-with-awk-returning-fields-to-bash-var-with-line-breaks/706505#706505

[seamusdemora]

Miller post alert: https://unix.stackexchange.com/a/709884/286615

[aborruso]

Another answer in which I use Miller, chosen as the right one: "How to format the layout of a CSV or JSON file" https://stackoverflow.com/questions/73784255/how-to-format-the-layout-of-a-csv-or-json-file/73798176#73798176

[aborruso]

Another answer in which I use Miller, chosen as the right one: "Create files from one column of a csv. And write data from the other column to those files"
https://stackoverflow.com/questions/74671186/create-files-from-one-column-of-a-csv-and-write-data-from-the-other-column-to-t/74673749#74673749

[aborruso]

Another answer in which I use Miller, chosen as the right one: "How to grep columns and their ajoining rows of text from a .csv file then print in a specific pattern for zenity? "
https://stackoverflow.com/questions/74937414/how-to-grep-columns-and-their-ajoining-rows-of-text-from-a-csv-file-then-print/74953909#74953909

[aborruso]

Another answer in which I use Miller, chosen as the right one: "Finding whether a string is a substring of another with Miller/mlr's DSL"
https://unix.stackexchange.com/questions/731761/finding-whether-a-string-is-a-substring-of-another-with-miller-mlrs-dsl/731765#731765

[aborruso]

Another answer in which I use Miller, chosen as the right one: "Miller: ofs="\n"?"
https://stackoverflow.com/questions/75987935/miller-ofs-n/75988137#75988137

[aborruso]

Another answer in which I use Miller, chosen as the right one: "Deduplicate CSV rows based on a specific column, with a CSV parser" https://unix.stackexchange.com/questions/747421/deduplicate-csv-rows-based-on-a-specific-column-with-a-csv-parser/747425#747425

[aborruso]

Another answer in which I use Miller, chosen as the right one (I think I could have used Miller much better): "How to select value from CSV containing JSON as a column"
https://stackoverflow.com/questions/76477520/how-to-select-value-from-csv-containing-json-as-a-column/76480692#76480692

[aborruso]

Another answer in which I use Miller, chosen as the right one: "Miller: selecting columns based on their last value"
https://stackoverflow.com/questions/76745809/miller-selecting-columns-based-on-their-last-value/76746983#76746983

[aborruso]

Another answer in which I use Miller, chosen as the right one: "Forcing miller to read data as string in conversion to JSON"
https://unix.stackexchange.com/a/752842/195582

[aborruso]

Another answer in which I use Miller, chosen as the right one: "How to convert a CSV with paragraphs to JSON on macOS's BSD Terminal?"
https://unix.stackexchange.com/a/758184/195582

[aborruso]

Another answer in which I use Miller, chosen as the right one: "How to fillter a CSV file with csvgrep and print only certain columns?"
https://stackoverflow.com/a/77273217/757714

[aborruso]

Another answer in which I use Miller, chosen as the right one: "Miller: getting the row containing the max (or min) values"
https://stackoverflow.com/questions/77818261/miller-getting-the-row-containing-the-max-or-min-values/77818430#77818430

[aborruso]

Another answer in which I use Miller, chosen as the right one: "How to use positional field names with Miller cut verb"
https://stackoverflow.com/questions/78908146/how-to-use-positional-field-names-with-miller-cut-verb/78913573#78913573

Also, this was the inspiration for adding a note in the documentation cc @GlassGruber

[aborruso]

I don't like the positional field names, because there are formats that are not rectangular, that don't have the same number of columns, and that may not have for each row a uniform fields order (e.g., json)

[GlassGruber]

You could change if (@i == 4) to if (@i != 4)

It's one of the first thing I've tried, the problem with that is the emit part because it will print a single line/record per field. So (using same example data) we get

s=green
t=red
a=3

instead of

s=green,t=red,a=3

[aborruso]

like "keep all fields but column number 3"?

Try this

echo s=green,t=red,a=3,b=4 | mlr put 'unset $[[3]]'

[aborruso]

@GlassGruber have you tried this?

echo s=green,t=red,a=3,b=4 | mlr put 'unset $[[3]]'

[GlassGruber]

Hey sorry for the late reply! Yes I've tried it and it definitely works! I will do some more tests for other similar cases, anyway thank you for your time!