Remove the headings


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove the headings
# 1  
Old 08-10-2012
Remove the headings

HI I am executing faloowing commands.
Code:
 
mr batch_1 > my_temp.txt ;
mr batch_2 >>my_temp.txt;
mr batch_3 >> my_temp.txt;
mr batch_4 >> my_temp.txt;

and the out put file is as this
Code:
 
 
cat my_temp.txt
Machine Name                  Max Load   Current Load Factor  O/S         Status
_____________________________ __________ ____________ _______ ___________ ______
batch_1.18dev        2000       0            ----    Unix        Online
Machine Name                  Max Load   Current Load Factor  O/S         Status
_____________________________ __________ ____________ _______ ___________ ______
batch_2.17dev        ---        3            ----    Unix        Online
Machine Name                  Max Load   Current Load Factor  O/S         Status
_____________________________ __________ ____________ _______ ___________ ______
batch_3.18dev        2000       4            ----    Unix        Online
Machine Name                  Max Load   Current Load Factor  O/S         Status
_____________________________ __________ ____________ _______ ___________ ______
batch_4.18dev        ---        2            ----    Unix        Online
Machine Name                  Max Load   Current Load Factor  O/S         Status
_____________________________ __________ ____________ _______ ___________ ______
batch_u.01dev        2000       0            ----    Unix        Online

But i dont want the heading on each line like "Machine Name Max Load Current Load Factor O/S Status
"
please help .

Last edited by vbe; 11-05-2015 at 09:24 AM.. Reason: sanitized - missing code tag
# 2  
Old 08-10-2012
Code:
grep -v 'Machine Name                  Max Load   Current Load Factor' temp.txt

???
# 3  
Old 08-10-2012
Sorry for incorrect question actually.

I would need to remove the lines as well like

"_____________________________ __________ ____________ _______ ___________ ______"
# 4  
Old 08-10-2012
you can use the same method what balajesuri suggested .

Code:
grep -v '_____________________________ __________ ____________ _______ ___________ ______' temp.txt

Cheers.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Bash to remove find and remove specific extension

The bash below executes and does find all the .bam files in each R_2019 folder. However set -x shows that the .bam extension only gets removed from one .bam file in each folder (appears to be the last in each). Why is it not removing the extension from each (this is $SAMPLE)? Thank you :). set... (4 Replies)
Discussion started by: cmccabe
4 Replies

2. Shell Programming and Scripting

Help with awk command on report with headings

Hi all, I have a report that looks like this: ------------------------------------------------- -- AOC - XXXXXXX -- ------------------------------------------------- Thread Last Sequence Received Last Sequence Applied Difference ----------... (12 Replies)
Discussion started by: cougartrace
12 Replies

3. Shell Programming and Scripting

remove brackets and put it in a column and remove repeated entry

Hi all, I want to remove the remove bracket sign ( ) and put in the separate column I also want to remove the repeated entry like in first row in below input (PA156) is repeated ESR1 (PA156) leflunomide (PA450192) (PA156) leflunomide (PA450192) CHST3 (PA26503) docetaxel... (2 Replies)
Discussion started by: manigrover
2 Replies

4. UNIX for Dummies Questions & Answers

sort by keeping the headings intact?

Hi all, I have a file with 3 columns separated by space. Each column has a heading. I want to sort according to the values in the 2nd column (ascending order). Ex. Name rank direction goory 0.05 --+ laby 0.0006 --- namy 0.31 -+- ....etc. Output should be Name rank direction laby... (3 Replies)
Discussion started by: Unilearn
3 Replies

5. UNIX for Dummies Questions & Answers

Help needed with adding column headings in syslog report

Hi all, I need your help in adding column headings in the below report. The headings I want are: Count - Host - Message Type The command used to create the report is as follows: for messages in `cat syslog_message_list.txt` do grep $messages syslog.`date +%d%m%y`.log | awk '{print $4 " " "... (4 Replies)
Discussion started by: wthomas
4 Replies

6. Shell Programming and Scripting

Using sed (or similar) to rename variable headings

Hello, I'm rather new to the world of regular expressions and sed, though am excited by its possibilities. I have a particular task I'd like to achieve, and have googled the topic quite a bit. However, having found some codes that perform a task very similar to what I'd like to do, I can't for... (2 Replies)
Discussion started by: redseventyseven
2 Replies

7. AIX

split a filename and print to 2 different headings

I need help to split a filename 'a0crk_user:A0-B0123$#%test' into a0crk_user and A0-B0123 and print the output under 2 different columns namely User and Status. for eg. the output should like below: User Status ---- ------ a0crk_user A0-B0123 (3 Replies)
Discussion started by: mbak
3 Replies

8. UNIX for Dummies Questions & Answers

ls -l column headings

I'm trying to see if there's a way to see column headings when I type the ls -l command. I know what some of the fields mean for example in the following listing: total 136 drwxr-xr-x 2 root root 4096 Jun 5 15:16 bin drwxr-xr-x 3 root root 4096 Jul 9 15:25 boot drwxr-xr-x 9... (6 Replies)
Discussion started by: thoughts
6 Replies

9. Shell Programming and Scripting

sed or awk to convert text files with recurring headings to rows and colum

I have many text file reports generated by a Information Assurance tool that I need to get into a .CSV format or Excel tab delimited format. I want to use sed or awk to grab all the information in the sample text file below and create column headings:Risk ID, Risk Level, Category, Description, How... (5 Replies)
Discussion started by: Bjoeboo
5 Replies

10. UNIX for Dummies Questions & Answers

smitty, remove user, remove directory as well..

hi, i am on aix. i used smitty to remove a user.. but then found that its directory still exists.... so i have to remove the directory manually... am i doing it the right way? (2 Replies)
Discussion started by: yls177
2 Replies
Login or Register to Ask a Question