LoginSignup
1
1

More than 3 years have passed since last update.

Excelで扱えない行数の CSV をなんとかする方法

Posted at

column -t -s,
| -t | 入力行のカラム数を判定して整形する |
| -s | -tオプションを使う際に、入力行をカラムに分ける区切り文字を指定する |

cat hoge.csv|sed -e 's/,,/,-,/g'|sed -e 's/,,/,-,/g'| sort -t, -k10 | column -t -s,
1
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
1