Shell Programming and Scripting

First problem:

Code:

awk '{for(i=1;i<=NF;i++)sub(/:.*/,x,$i)} !/^##/' infile

Second problem:

Code:

grep -E '^(Month|Day|Average)' infile

or

Code:

awk '/^(Month|Day|Average)/' infile

Thanks Scrutinizer, you are the man!!! The third option worked like charm (awk).
Thanks man...

One question, is it possible to add spaces in between the specific lines using awk (to distinguish between the respective rows), i know i can copy this into notepad and do the necessary stuff but am thrilled with all this text manipulation tricks.

By the way how did you learn all this? You were able to give me a solution under minutes. I know i will get there someday.

All the same thanks...

Thanks Scrutinizer, you are the man!!! The third option worked like charm (awk).
Thanks man...

One question, is it possible to add spaces in between the specific lines using awk (to distinguish between the respective rows), i know i can copy this into notepad and do the necessary stuff but am thrilled with all this text manipulation tricks.

By the way how did you learn all this? You were able to give me a solution under minutes. I know i will get there someday.

All the same thanks...

Try:

Code:

awk '/^(Month|Day|Average)/{print $0 RS}' infile

You are welcome... I learned this from experience, books, curiosity, practice and the help of others on the Internet and on this forum in particular..

best book to understand regexp: Mastering Regular Expressions, 3rd Edition-O'Reilly Media

Many thanks to you guys, the command worked just ok, i will figure out the rest, i will check the book on regexp.. I believe this will go a long way in becoming a master at *nix systems.. Thank God that i found this forum..Many thanks "Scrutinizer and Tip78"..God bless your soul!!!