Edit CSV column with unix command

Question

I have a CSV table structured as below (I aligned columns for clarity):

AAAA, BBBB,                CCCC, DDDD
EEEE, FFFF;1111,           GGGG, HHHH
IIII, JJJJ;2222;3333;4444, KKKK, LLLL

And in the second column I would like to remove everything after the first occurrence of a semi-colon, resulting in:

AAAA, BBBB, CCCC, DDDD
EEEE, FFFF, GGGG, HHHH
IIII, JJJJ, KKKK, LLLL

I've tried various awk commands inspired from here, here, and here, but can't quite get it.

I understand I could select the second column and edit it by awk -F, '{print $2}' file | cut -d ';' -f 1, but can't seem to figure out how to replace the second column with that command

karakfa · Accepted Answer · 2018-04-12 00:41:17Z

3

$ awk '{sub(";[^,]+","")}1' file

or, perhaps better

$ sed -E 's/;[^,]+//' file

answered Apr 12, 2018 at 0:41

karakfa

67.8k8 gold badges45 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Edit CSV column with unix command

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related