UNIX for Dummies Questions & Answers

Hi All
Thanks for all your post and advice, you have been extremely helpful in the past.


I have an issue where I'm stumped and am seeking a wider opinion.

I'm relatively new to unix and have been tasked with collating a vast amount of data and presenting it within excel.

Now the original data from the unix boxes are csv files, but I have to update these files dependent on an entry in the first field.

ie:

Field one is a path

Field to be updated depends on the contents of field pne.

Filed one path would look like:

/usr/home
/adm/user
/opt/oracle

so depending on the path i require a script that would put a predetermined vaule in the updated field.

Field one Filed updated
/usr/home owner is Team1
/adm/user owner is Team2
/opt/oracle owner is Team3


The above is what I'm trying to achieve, whereby the script reads through each line of data and depending on the path will update a new field.

Hope this is clear and thanks for any assistance.

Code:

sed 's!/usr/home!& owner is Team1!' infile

You can do the same with the other patterns (paths). Just redirect the output to a new file or check if your sed has the -i option so you it edits the file right in place.

Many thanks Zaxxon for the prompt response.

Would this allow for multiple lines to be updated to the same file?

Yes, you can try it out. For the other 2 paths and 2 teams you have to use a similar line or expand the existing sed command.

still stumped here

---------- Post updated at 03:19 PM ---------- Previous update was at 03:10 PM ----------

sorry typo..., that works a charm

moving on a step, how do i put this new input at the end of the line? there are six commas per line??

? Please give an example snippet of the input and desired output using code tags.