Conditional grep command to search entire file Post: 302697495

Sponsored Content

Top Forums Shell Programming and Scripting Conditional grep command to search entire file Post 302697495 by Corona688 on Thursday 6th of September 2012 11:29:19 PM

09-07-2012

Registered User

awk is a language which loops over all lines by default.

So, for every single line, it runs both code blocks.

Code:

awk '# NR is the total line number.
# FNR is the line number in the file.
# When they are the same, it must be in the right file.
#
# $5 is the 5th field.  When it does not contain none,
# it is considered to be a valid line, and the 12th column
# and 5th column get saved for later in the array A.
# Then it skips to the next line without executing the block below.
NR==FNR && !($5 ~ /none/) {
        A[$12]=$5 # Save ID and key for later
        next # Skip to next line
}

# When the 5th column contains none, try to look
# it up in A.  If found, set the 5th column to its contents.
# The 1 at the end of the line tells it to print every line.
($5 ~ /none/) && ($12 in A) { $5=A[$12] } 1' logfile logfile

We give awk logfile twice, so it reads the same file twice. The first time it saves names for lookup. The second time, it tries to look up entries and substitute the data you wanted before printing every line.

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

search in a directory using grep command

Hi, I want to search files/directories in /temp directory which starts with letter 'a'. How can I do that using grep command. I can find out like ls -ltr a* but I want to use grep command like ls -ltr | grep ..... like that. Please help. Malay

2. UNIX for Dummies Questions & Answers

Search / Find / grep command ...

Is there any command, so I can retrieve all the records in a file from the first occurance of a search string, within that file?

3. Shell Programming and Scripting

Awk+Grep Input file needs to match a column and print the entire line

I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this). For example, i have a input file1.txt: cat inputfile1.txt 218299910417 1172051195 1172070231 1172073514 1183135117 1183135118 1183135119 1281440202 ...

4. UNIX for Dummies Questions & Answers

grep question: stop search from finding entire line

Sorry for the title, I really don't know how to word this question or what to even search for. I tried "grep one match", "grep 1 match", "stop grep" on both google and here and haven't found something that helps, so here I go: I have a file that's about 1.5 million lines long, every line looks...

5. UNIX for Advanced & Expert Users

Advance conditional grep command

Hi guys, I need your help to use advance grep command, In my example below, I have 5 container which has some information on it, and I need to grep specific word "PLMNCode=454F00" which will not only grep the line contains that word, but I need to print the output for the whole container. Input...

6. UNIX for Advanced & Expert Users

search the entire man pages

Could someone please tell me how to search the entire man pages? I know man -k whatever searched the description but I wanna search the entire man page.

7. Shell Programming and Scripting

Pattern search using grep command !

Hi, I am trying to do pattern search using grep command. But i donot know what mistake i'm doing. I am not getting the expected Result. could any one please help me out? $ cat b.ksh AasdjfhB 57834B 86234B 472346B I want to print the line which is starting with either A or 8 and...

8. UNIX for Dummies Questions & Answers

Bashrc File - Conditional Command Execution?

Hello All, I was wondering if there is a way to execute a command in my ".bashrc" file based on how I logged into the PC? I was thinking maybe there is a way to check how the user (*myself) logged in, maybe somehow with the who command along with something else, but I'm not sure... I know I...

9. Shell Programming and Scripting

Search file pattern using grep command

I 'm writing a script to search particular strings from log files. The log file contains lines start with *. The file may contain many other lines start with *. I need to search a particular line from my log file. The grep command is working in command line , but when i run my script, Its printing...

10. UNIX for Beginners Questions & Answers

Search a string and display its location on the entire string and make a text file

I want to search a small string in a large string and find the locations of the string. For this I used grep "string" -ob <file name where the large string is stored>. Now this gives me the locations of that string. Now how do I store these locations in a text file. Please use CODE tags as...

LEARN ABOUT OSX

colrm

COLRM(1)						    BSD General Commands Manual 						  COLRM(1)

NAME

     colrm -- remove columns from a file

SYNOPSIS

     colrm [start [stop]]

DESCRIPTION

     The colrm utility removes selected columns from the lines of a file.  A column is defined as a single character in a line.  Input is read
     from the standard input.  Output is written to the standard output.

     If only the start column is specified, columns numbered less than the start column will be written.  If both start and stop columns are spec-
     ified, columns numbered less than the start column or greater than the stop column will be written.  Column numbering starts with one, not
     zero.

     Tab characters increment the column count to the next multiple of eight.  Backspace characters decrement the column count by one.

ENVIRONMENT

     The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).

EXIT STATUS

     The colrm utility exits 0 on success, and >0 if an error occurs.

SEE ALSO

     awk(1), column(1), cut(1), paste(1)

HISTORY

     The colrm command appeared in 3.0BSD.

BSD
								  August 4, 2004							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

search in a directory using grep command

Discussion started by: malaymaru

2. UNIX for Dummies Questions & Answers

Search / Find / grep command ...

Discussion started by: videsh77

3. Shell Programming and Scripting

Awk+Grep Input file needs to match a column and print the entire line

Discussion started by: poliver

4. UNIX for Dummies Questions & Answers

grep question: stop search from finding entire line

Discussion started by: rmoakler