Sponsored Content
Top Forums Shell Programming and Scripting Ignore records with no values through awk Post 302494768 by singh.chandan18 on Tuesday 8th of February 2011 10:06:42 AM
Old 02-08-2011
Ignore records with no values through awk

Hi Guys,
Hope you are doing well out there.

I have to format the output of a script.

Current output is
Code:
 auktltbr.dc-dublin.de:4322 ICCIR2Test13-PB-01 active
auktltbr.dc-dublin.de:8322 ICCIR2Test13-SB-02 active
auktlttr.dc-dublin.de:4422 ICCIR2Test24-CB-02 active
auktlttr.dc-dublin.de:5422 ICCIR2Test24-CB-01 active
auktltur.dc-dublin.de:6422
auktlttr.dc-dublin.de:7422 ICCIR2Test24-SB-01 active
auktlttr.dc-dublin.de:7423
auktltur.dc-dublin.de:4422
auktltur.dc-dublin.de:5422
auktltur.dc-dublin.de:7422 ICCIR2Test24-SB-02 active

I want it to be like
Code:
 auktltbr.dc-dublin.de:4322 ICCIR2Test13-PB-01 active
auktltbr.dc-dublin.de:8322 ICCIR2Test13-SB-02 active
auktlttr.dc-dublin.de:4422 ICCIR2Test24-CB-02 active
auktlttr.dc-dublin.de:5422 ICCIR2Test24-CB-01 active
auktlttr.dc-dublin.de:7422 ICCIR2Test24-SB-01 active
auktltur.dc-dublin.de:7422 ICCIR2Test24-SB-02 active

That is ignore the records which have null values in 2nd coloumn.

I want to achive this using awk.

Any help, would be highly appereciated.

Thanks,
Chandan
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Generating key values for leader records

All, I have a file with text as shown below. I want the o/p file with generated values in the first column as shown in the o/p file. Pls note that the size of my file is 6 GB. How do i do this ? Input file 999999abcdef 999999ghijkl 999999mnopq 777777rosesarered 777777skyisblue Output... (1 Reply)
Discussion started by: ajfaq
1 Replies

2. Shell Programming and Scripting

awk, ignore first x number of lines.

Is there a way to tell awk to ignore the first 11 lines of a file?? example, I have a csv file with all the heading information in the first lines. I want to split the file into 5-6 different files but I want to retain the the first 11 lines of the file. As it is now I run this command: ... (8 Replies)
Discussion started by: trey85stang
8 Replies

3. Shell Programming and Scripting

verifying column2 for same kind of records and adding corresponding values in column3

Hi am having a file which looks like this i want to get unique values in column2 and sum up the corresponding column3 values and discard the column4 and then write the output in different file. i.e the output has to be like i.e 07-Jun-2009 919449829088 52 lessrv1 07-Jun-2009... (2 Replies)
Discussion started by: aemunathan
2 Replies

4. Shell Programming and Scripting

awk to ignore the text before a particular word

Hi I am new to Awk programming , i would appreciate if anyone help me with the below scenario i have text file arranged in rows and columns like below 11004 04493384 26798 CASSI0000I Server manager initialization started 111004 04493486 26798 CASSI4005I Retrieving ES... (7 Replies)
Discussion started by: rakeshkumar
7 Replies

5. Shell Programming and Scripting

Splitting record into multiple records by appending values from an input field (AWK)

Hello, For the input file, I am trying to split those records which have multiple values seperated by '|' in the last input field, into multiple records and each record corresponds to the common input fields + one of the value from the last field. I was trying with an example on this forum... (4 Replies)
Discussion started by: imtiaz99
4 Replies

6. Shell Programming and Scripting

Copy header values into records

I'm using a shell script to manipulate a data file. I have a large file with two sets of data samples (tracking memory consumption) taken over a long period of time, so I have many samples. The problem is that all the data is in the same file so that each sample contains two sets of data.... (2 Replies)
Discussion started by: abercrom
2 Replies

7. Shell Programming and Scripting

Clean values in range of duplicate records

Dear Gents, Could you please help me to solve this problem. I am getting the average of a column for same duplicate records in this case locate in column 1. The average is computed from column 5 from all duplicate records in column 1. Normallly the values in column 5 is constant so the... (3 Replies)
Discussion started by: jiam912
3 Replies

8. Programming

Subtract values based on records

Hi Guys, I am having below tables in oracle T1 ID F_TYPE F_AMT DATE_COL 1 F 6 11-Feb-16 1 D 2 11-Feb-16 1 D 2 11-Feb-16 1 F 6 11-Feb-16 1 F 2 12-Mar-16 1 D 3 12-Mar-16 1 F 4 10-Apr-16 1 F 4 11-Apr-16 1 D 1 11-Apr-16 T2 ID START_DATE END_DATE F_ID FLAG... (0 Replies)
Discussion started by: rohit_shinez
0 Replies

9. Shell Programming and Scripting

awk to ignore whitespace in field

The awk below executes and update the desired field in my first awk. However, the white space between nonsynonymous SNV in $9 is being split into tabs and my attempt to correct this does not update the field unless it is removed. I am not sure what I am doing wrong? Thank you :). file1 ... (4 Replies)
Discussion started by: cmccabe
4 Replies

10. Shell Programming and Scripting

Getting cut to ignore cols in middle of records

I recently had to remove a number of columns from a sorted copy of a file, but couldn't get the cut command to take fields out, just what to keep. This is the only thing I could find as an example, but could it be simplified? tstamp=`date +%H%M%S` grep -v "T$" filename |egrep -v "^$" |sort... (3 Replies)
Discussion started by: wbport
3 Replies
IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME
igawk - gawk with include files SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ... igawk [ all gawk options ] [ -- ] program-text file ... DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1). AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like @include getopt.awk in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path. OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports. EXAMPLES
cat << EOF > test.awk @include getopt.awk BEGIN { while (getopt(ARGC, ARGV, "am:q") != -1) ... } EOF igawk -f test.awk SEE ALSO
gawk(1) Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995. AUTHOR
Arnold Robbins (arnold@skeeve.com). Free Software Foundation Nov 3 1999 IGAWK(1)
All times are GMT -4. The time now is 03:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy