Sponsored Content
Top Forums Shell Programming and Scripting Check the file if the search pattern is there or not. Post 302588032 by smolakal on Friday 6th of January 2012 02:18:02 PM
Old 01-06-2012
Check the file if the search pattern is there or not.

I want to check the files if the below pattern is there or not. I have to scan thousands of files.

It should start search with "Group" (Case insensitive) and followed by first semicolon ";" . In between these two there should be "partition"(case insensitive).

File1.txt
a)
Code:
update benchmark_app.dropme4
from
(sel a.empid from
benchmark_app.dropme3 a
GROUP by 1
QUALIFY row_number() over (partition by a.empid order by a.managername desc) = 1) c
set empid4 = c.empid
where 
benchmark_app.dropme4.empid4 = c.empid
;

sel
 group by;

sel
partition 
;

b) file2.txt
Code:
sel
 group by;

sel
partition 
;

I should not get any output from file2.txt because my pattern is not there in between start and ending search criteria.

I am using the following command, but it is not giving me the expected output.
Code:
awk '/[Gg][Rr][Oo][Uu][Pp]/ {s=x} {s=s$0"\n"} /[Pp][Aa][Rr][Tt][Ii][Tt][Ii][Oo][Nn]/ {p=1} /;/ && p {print s;s=x;p=0}' file2.txt


Last edited by Franklin52; 01-06-2012 at 06:02 PM.. Reason: Please use code tags for data and code samples, thank you
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search file for pattern and grab some lines before pattern

I want to search a file for a string and then if the string is found I need the line that the string is on - but also the previous two lines from the file (that the pattern will not be found in) This is on solaris Can you help? (2 Replies)
Discussion started by: frustrated1
2 Replies

2. UNIX for Dummies Questions & Answers

Search a file for pattern?

Hi, I'm looking for a single command that will be able tell me which files in a directory don't contain a certain pattern e.g. regular expression I've tried a combination of ls, xargs and grep but I haven't come up with anything yet. :confused: I would appreciate any help. Thanks (2 Replies)
Discussion started by: davjoyce
2 Replies

3. Shell Programming and Scripting

how to check for pattern in other file

i hav file1 with contents: welcome this is first file file name is file 1 last line of the file now i want to check if the second line has sentence "this is first file" through "if" statement from another file ... is it possible if so how!!! (6 Replies)
Discussion started by: suri
6 Replies

4. Shell Programming and Scripting

search a pattern and if pattern found insert new pattern at the begining

I am trying to do some thing like this .. In a file , if pattern found insert new pattern at the begining of the line containing the pattern. example: in a file I have this. gtrow0unit1/gctunit_crrownorth_stage5_outnet_feedthru_pin if i find feedthru_pin want to insert !! at the... (7 Replies)
Discussion started by: pitagi
7 Replies

5. Shell Programming and Scripting

Search for a pattern in a String file and count the occurance of each pattern

I am trying to search a file for a patterns ERR- in a file and return a count for each of the error reported Input file is a free flowing file without any format example of output ERR-00001=5 .... ERR-01010=10 ..... ERR-99999=10 (4 Replies)
Discussion started by: swayam123
4 Replies

6. Linux

Search a file with specified pattern

May I know how to search for a file whose name is embedded with 3007 but it shouldn't begin or end with 3007. For ex. : 3008ab3007cd1007. (10 Replies)
Discussion started by: ravisingh
10 Replies

7. Shell Programming and Scripting

How to use sed to search a particular pattern in a file backward after a pattern is matched.?

Hi, I have two files file1.txt and file2.txt. Please see the attachments. In file2.txt (which actually is a diff output between two versions of file1.txt.), I extract the pattern corresponding to 1172c1172. Now ,In file1.txt I have to search for this pattern 1172c1172 and if found, I have to... (9 Replies)
Discussion started by: saurabh kumar
9 Replies

8. Shell Programming and Scripting

How to search pattern in file?

Hi I want to search pattern in file "S12345678B" which start with S and end with B total length is 10,numeric part 12345678 is variable. e.g S99001229B and S88226901B. please help (4 Replies)
Discussion started by: ashfaque
4 Replies

9. UNIX for Dummies Questions & Answers

Search pattern in File

Hi I want to search pattern in file "S12345678B" which start with S and end with B total length is 10,numeric part 12345678 is variable. e.g S99001229B and S88226901B. please help (2 Replies)
Discussion started by: ashfaque
2 Replies

10. UNIX for Beginners Questions & Answers

Grep/awk using a begin search pattern and end search pattern

I have this fileA TEST FILE ABC this file contains ABC; TEST FILE DGHT this file contains DGHT; TEST FILE 123 this file contains ABC, this file contains DEF, this file contains XYZ, this file contains KLM ; I want to have a fileZ that has only (begin search pattern for will be... (2 Replies)
Discussion started by: vbabz
2 Replies
PTARGREP(1)						 Perl Programmers Reference Guide					       PTARGREP(1)

NAME
ptargrep - Apply pattern matching to the contents of files in a tar archive SYNOPSIS
ptargrep [options] <pattern> <tar file> ... Options: --basename|-b ignore directory paths from archive --ignore-case|-i do case-insensitive pattern matching --list-only|-l list matching filenames rather than extracting matches --verbose|-v write debugging message to STDERR --help|-? detailed help message DESCRIPTION
This utility allows you to apply pattern matching to the contents of files contained in a tar archive. You might use this to identify all files in an archive which contain lines matching the specified pattern and either print out the pathnames or extract the files. The pattern will be used as a Perl regular expression (as opposed to a simple grep regex). Multiple tar archive filenames can be specified - they will each be processed in turn. OPTIONS
--basename (alias -b) When matching files are extracted, ignore the directory path from the archive and write to the current directory using the basename of the file from the archive. Beware: if two matching files in the archive have the same basename, the second file extracted will overwrite the first. --ignore-case (alias -i) Make pattern matching case-insensitive. --list-only (alias -l) Print the pathname of each matching file from the archive to STDOUT. Without this option, the default behaviour is to extract each matching file. --verbose (alias -v) Log debugging info to STDERR. --help (alias -?) Display this documentation. COPYRIGHT
Copyright 2010 Grant McLean <grantm@cpan.org> This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.18.2 2018-08-17 PTARGREP(1)
All times are GMT -4. The time now is 06:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy