CODEWITHSUNDEEP
csvemacsemacs24
ben.IT
ben.IT

Reputation: 1610

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

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;

Upvotes: 1

Views: 120

Answers (1)

djangoliv
djangoliv

Reputation: 1788

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
    -

Upvotes: 3

Related Questions