Emacs 24.5 : replace pattern in a specific column of a CSV file

Question

I want to replace in the 3rd column ONLY the pattern 'foo' by 'bar' of the following CSV file. Is it possible to do this with emacs or do I need to write a script to do this ?

foo;bbb;foo;
foo;bbbbbbbb;bar;
foo;bbbbbb;foo;
foo;bbbbbbbbbbbb;bar;
foo;bbbbbb;foo;

So, the expedted result would be :

foo;bbb;bar;
foo;bbbbbbbb;bar;
foo;bbbbbb;bar;
foo;bbbbbbbbbbbb;bar;
foo;bbbbbb;bar;

djangoliv · Accepted Answer · 2016-02-25 10:44:38Z

3

With csv mode: https://github.com/emacsmirror/csv-mode

M-x csv-transpose
Then your column is a line, so you can select as region and do a query-replace on the region or use narrow-to-region or ...
M-x csv-transpose

-

answered Feb 25, 2016 at 10:44

djangoliv

1,79814 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Emacs 24.5 : replace pattern in a specific column of a CSV file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related