Truncate an CSV column using CsvKit
I didn’t think it was directly possible with CSVKit, until shown otherwise. However, I do know that it can be done with Miller: … Read more
csv
sed/awk to remove double quotes ” that are inside of curly braces {}
Try this using sed: $ sed -r ‘ :L; s/(\{[^”}]*)”(([^”}]*”)*)([^”}]*\})/\1\2\4/g; tL; ‘ file
How can SQLite command “.import” read directly from standard input?
How can SQLite command “.import” read directly from standard input?
Adding suffix to filename during for loop in bash
Adding suffix to filename during for loop in bash
adding an empty first line inside csv file
Use sed as follows to insert a blank line in the beginning of a file x.txt: sed ‘1 i \ ‘ x.txt
How to join two csv with same number of rows
How to join two csv with same number of rows
Replacing the values in one file with the values in another file in bash
Some notes: Bash is a terrible language for database emulation. Are you sure you cannot use a relational database for this? Avoid useless … Read more
How to use Unix Shell to show only the first n columns and last n columns?
perl: echo a,b,X,X,X,X,c,d | perl -F, -slane ‘print join “,”, @F[0..$n-1, -$n..-1]’ — -n=2 a,b,c,d
Executable common files (*.pdf, etc.)
The green in your ls display means that the files have execute permissions, which doesn’t necessarily mean that they can be executed in … Read more
Replace only first instance of a character
Pure bash solution while IFS=\, read -r a b ; do echo “$a;$b” ; done <file.csv Or just for fun paste -d\; <(cut … Read more
