How to add specific information in a csv file in specific row and column?

Question

I have a script in bash that in some part of the code i need to add to a csv specific information in row and column specific, for example :

The format of my csv is the next :

Columns1 Columns2 Columns3 Columns4 Columns5 Columns6 Columns7 Columns8
animals   value2   value3   value4   value5   value6   value7   value8
bird      value2   value3   value4   value5   value6   value7   value8

So, I need that when the script found a value for example :

grep "animals" myfile.csv

add some information for example in the row with the value "animals" add or replace the value in the column5

In all my script.sh always I need to add several information many times in a specific range.

I would appreciate that the solution was in bash

Unlike forum sites, we don't use "Thanks", or "Any help appreciated", or signatures on Stack Overflow. See "Should 'Hi', 'thanks,' taglines, and salutations be removed from posts?. BTW, it's "Thanks in advance", not "Thanks in advanced". — John Saunders
– John Saunders, Commented May 24, 2015 at 22:50

score 1 · Accepted Answer · 2015-05-24 22:13:38Z

1

You can do this very easily with awk:

awk -v M=match -v R=replace 'BEGIN {FS=","; OFS=","} $1==M {$5=R} {print}' infile.csv > outfile.csv

edited May 24, 2015 at 22:13

answered May 24, 2015 at 21:35

user554538

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

8 Comments

shaveax Over a year ago

Woow this is works, really, I had been searching for days this answer, but only one little detail, when i run this command in a terminal , it works but does no add the information to the csv file, what parameter i need to add ?

user554538 Over a year ago

I just updated the code to show how to write the output to a new file. You can then rename the new file to the same name as the old file if you'd like.

shaveax Over a year ago

ok, i see, but i have a little problem, after executed this comand the line where is replace a value, it is shows without "," , like this : animals value2 value3 value4 newvaluel value6 value7 value8 and when create a new file (> outfile.csv) i have the value of the row modified in a cell instead of severals cells

user554538 Over a year ago

Sorry about that. I've edited it so that both the input and output field separators are set properly.

shaveax Over a year ago

Thanks again Misandrist

|

Collectives™ on Stack Overflow

How to add specific information in a csv file in specific row and column?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related