开发者

Splitting file by columns

开发者 https://www.devze.com 2023-04-11 07:12 出处:网络
I know about cut command which can cut a column(s) from a file, but what can I use to split a file into multiple files so that each file would be named as first line in that column and there wo开发者_

I know about cut command which can cut a column(s) from a file, but what can I use to split a file into multiple files so that each file would be named as first line in that column and there wo开发者_StackOverflowuld be same number of produced files as there was columns in original file

Example (edit)

Columns are separated by TAB and can be of different length. I would like first file to actually have names of rows.

Probe File1.txt File2.txt File3.txt
"1007_s_at" 7.84390328616472 7.60792223630275 7.77487266222512
...

Also thing is that this original file is extremely huge, so I would want some solution that could split this in one run. That is not calling cut repeatedly


Can do it with one line of awk:

$ cat test.tsv
field1  field2  field3  field4
asdf    asdf    asdf    asdf
lkjlkj  lkjlkj  lkjlkj  lkjlkj
feh     feh     feh     bmeh

$ awk -F'\t' 'NR==1 {  for(i=1;i<=NF;i++) { names[i] = $i }; next } { for(i=1;i<=NF;i++) print $i >> names[i] }' test.tsv

$ ls
field1  field2  field3  field4  test.tsv

$ cat field4
asdf
lkjlkj
bmeh

Edited to include Tab separator courtesy of Glenn Jackman


Addition

Removing double quotes from the fields:

awk -F'\t' 'NR==1 {  for(i=1;i<=NF;i++) { names[i] = $i }; next } { for(i=1;i<=NF;i++) {gsub(/"/,"",$i); print $i >> names[i] }}' example.tsv

Additional Addition

Removing double quotes from fields, only at the start or end of the field:

awk -F'\t' 'NR==1 {  for(i=1;i<=NF;i++) { names[i] = $i }; next } { for(i=1;i<=NF;i++) {gsub(/^"|"$/,"",$i); print $i >> names[i] }}' example.tsv
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号