search

shenwei356 / csvtk

A cross-platform, efficient and practical CSV/TSV toolkit in Golang
http://bioinf.shenwei.me/csvtk
MIT License
1.01k stars 84 forks source link

loss data #150

Closed happydentist closed 3 years ago

happydentist commented 3 years ago

nice tool and speed. But I got an error, When my csv file which first character with # on every line(row), data would be loss after csvtk handle the data. For example csv file like

hcuhsd,122,ehfefj,

&^jjddk,654,hdhjh,

after csvtk replace -H -f 4 -p "^$" -r "10003" and result &^jjddk,654,hdhjh,10003 loss one row

avilella commented 3 years ago

I think you can avoid that by changing the '-C' flag from the default '#' to something else.

On Fri, Jun 18, 2021 at 12:03 PM happydentist @.***> wrote:

nice tool and speed. But I got an error, When my csv file which first character with # on every line(row), data would be loss after csvtk handle the data. For example csv file like

hcuhsd,122,ehfefj,

&^jjddk,654,hdhjh, after csvtk replace -H -f 4 -p "^$" -r "10003" and result &^jjddk,654,hdhjh,10003 loss one row

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/shenwei356/csvtk/issues/150, or unsubscribe https://github.com/notifications/unsubscribe-auth/AABGSN5FJV3SIVCZIKSTP4DTTMRYVANCNFSM465OSQXQ .

avilella commented 3 years ago

$ echo -e "#foo\nbar" | csvtk pretty bar $ echo -e "#foo\nbar" | csvtk pretty -C '@'

foo

bar

On Fri, Jun 18, 2021 at 12:10 PM Albert Vilella @.***> wrote:

I think you can avoid that by changing the '-C' flag from the default '#' to something else.

On Fri, Jun 18, 2021 at 12:03 PM happydentist @.***> wrote:

nice tool and speed. But I got an error, When my csv file which first character with # on every line(row), data would be loss after csvtk handle the data. For example csv file like

hcuhsd,122,ehfefj,

&^jjddk,654,hdhjh, after csvtk replace -H -f 4 -p "^$" -r "10003" and result &^jjddk,654,hdhjh,10003 loss one row

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/shenwei356/csvtk/issues/150, or unsubscribe https://github.com/notifications/unsubscribe-auth/AABGSN5FJV3SIVCZIKSTP4DTTMRYVANCNFSM465OSQXQ .

happydentist commented 3 years ago

Albert Vilella Thank for your help. I read the usage again. The document was talk about it.