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
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
Try this using sed: $ sed -r ‘ :L; s/(\{[^”}]*)”(([^”}]*”)*)([^”}]*\})/\1\2\4/g; tL; ‘ file
How can SQLite command “.import” read directly from standard input?
Adding suffix to filename during for loop in bash
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
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
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
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
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