Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Pattern Matching

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Pattern Matching
# 1  
Old 01-12-2009
Pattern Matching
Hi Folks,

I have the following requirement:
I have a file that is containing numerous queries. The tables name mentioned in the queries are in the following format : SchemaName.Tablename. e.g COPDB.TableName.

I need to take out all the COPDB.TableName pattern and write it to a different file.
Note: Only the COPDB.TableName pattern.

Thanks in Advance.
# 2  
Old 01-12-2009
Please be aware that double-posting/bumping up of posts is against the rules of the forum. You already have 3 such violations. One more and you will be banned temporarily.
# 3  
Old 01-12-2009
Hi can you send me a sample input file and a expected output, Its not clear here
# 4  
Old 01-12-2009
Pattern Matching
Suppose my input File is as follows:

Locking for access COPDB.T1
insert into COPDB.T2 select * from COPDB.T5
update COPBD.T3 set................
insert into COPDB.T7 select * from COPDB.T12
update COPBD.T71 set................

My requirement is to get:
COPDB.T1
COPDB.T2
COPDB.T5
COPDB.T3
COPDB.T7
COPDB.T12
COPDB.T71
# 5  
Old 01-12-2009
Code:
perl -ne 'print $1."\n" while /(COPDB\.T\d+)/g;' input.txt

# 6  
Old 01-12-2009
Pattern Matching
Thanks for the reply.
But this script is fetching all the words after that Pattern.
For example if my input is :

LOCKING TABLE COPDB.cop_program_run_detail FOR ACCESS

this script is getting :
COPDB.cop_program_run_detail FOR ACCESS
But I want only COPDB.TableName
i.e COPDB.cop_program_run_detail .
And one more thing its not necessary that the Table name starts with T.
# 7  
Old 01-12-2009
Quote:
Originally Posted by Siv_Pat
Suppose my input File is as follows:

Locking for access COPDB.T1
insert into COPDB.T2 select * from COPDB.T5
update COPBD.T3 set................
insert into COPDB.T7 select * from COPDB.T12
update COPBD.T71 set................

My requirement is to get:
COPDB.T1
COPDB.T2
COPDB.T5
COPDB.T3
COPDB.T7
COPDB.T12
COPDB.T71
Code:
$ cat infile
Locking for access COPDB.T1
insert into COPDB.T2 select * from COPDB.T5
update COPDB.T3 set................
insert into COPDB.T7 select * from COPDB.T12
update COPDB.T71 set................
$ sed 's/\(COPDB\.[a-zA-Z0-9_]*\)/\
> \1\
> /g' infile|grep '^COPDB'
COPDB.T1
COPDB.T2
COPDB.T5
COPDB.T3
COPDB.T7
COPDB.T12
COPDB.T71

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Big pattern file matching within another pattern file in awk or shell

Hi I need to do a patten match between files . I am new to shell scripting and have come up with this so far. It take 50 seconds to process files of 2mb size . I need to tune this code as file size will be around 50mb and need to save time. Main issue is that I need to search the pattern from... (2 Replies)
Discussion started by: nitin_daharwal
2 Replies

2. UNIX for Dummies Questions & Answers

Grep -v lines starting with pattern 1 and not matching pattern 2

Hi all! Thanks for taking the time to view this! I want to grep out all lines of a file that starts with pattern 1 but also does not match with the second pattern. Example: Drink a soda Eat a banana Eat multiple bananas Drink an apple juice Eat an apple Eat multiple apples I... (8 Replies)
Discussion started by: demmel
8 Replies

3. Shell Programming and Scripting

PHP - Regex for matching string containing pattern but without pattern itself

The sample file: dept1: user1,user2,user3 dept2: user4,user5,user6 dept3: user7,user8,user9 I want to match by '/^dept2.*/' but don't want to have substring 'dept2:' in output. How to compose such regex? (8 Replies)
Discussion started by: urello
8 Replies

4. Shell Programming and Scripting

Sed: printing lines AFTER pattern matching EXCLUDING the line containing the pattern

'Hi I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match. Which option is to be used to exclude the line containing the pattern? sed -n '/Conn.*User/,$p' > consumers.txt (11 Replies)
Discussion started by: essem
11 Replies

5. UNIX for Dummies Questions & Answers

Find pattern suffix matching pattern

Hi, I am trying to get a result out of this but fails please help. Have two files /tmp/1 & /tmp/hosts. /tmp/1 IP=123.456.789.01 WAS_HOSTNAME=abcdefgh.was.tb.dsdc /tmp/hosts 123.456.789.01 I want this result in /tmp/hosts if hostname is already there dont want duplicate entry. ... (5 Replies)
Discussion started by: rajeshwebspere
5 Replies

6. Shell Programming and Scripting

sed - matching pattern one but not pattern two

All, I have the following file: -------------------------------------- # # /etc/pam.d/common-password - password-related modules common to all services # # This file is included from other service-specific PAM config files, # and should contain a list of modules that define the services... (2 Replies)
Discussion started by: RobertBerrie
2 Replies

7. Shell Programming and Scripting

counting the lines matching a pattern, in between two pattern, and generate a tab

Hi all, I'm looking for some help. I have a file (very long) that is organized like below: >Cluster 0 0 283nt, >01_FRYJ6ZM12HMXZS... at +/99% 1 279nt, >01_FRYJ6ZM12HN12A... at +/99% 2 281nt, >01_FRYJ6ZM12HM4TS... at +/99% 3 283nt, >01_FRYJ6ZM12HM946... at +/99% 4 279nt,... (4 Replies)
Discussion started by: d.chauliac
4 Replies

8. UNIX for Advanced & Expert Users

Pattern Matching

Hi Folks, I have the following requirement: I have a file that is containing numerous queries. The tables name mentioned in the queries are in the following format : SchemaName.Tablename. e.g COPDB.TableName. I need to take out all the COPDB.TableName pattern and write it to a different... (0 Replies)
Discussion started by: Siv_Pat
0 Replies

9. UNIX for Dummies Questions & Answers

Pattern Matching

Hi Folks, I have the following requirement: I have a file that is containing numerous queries. The tables name mentioned in the queries are in the following format : SchemaName.Tablename. e.g COPDB.TableName. I need to take out all the COPDB.TableName pattern and write it to a different... (0 Replies)
Discussion started by: Siv_Pat
0 Replies

10. Shell Programming and Scripting

comment/delete a particular pattern starting from second line of the matching pattern

Hi, I have file 1.txt with following entries as shown: 0152364|134444|10.20.30.40|015236433 0233654|122555|10.20.30.50|023365433 ** ** ** In file 2.txt I have the following entries as shown: 0152364|134444|10.20.30.40|015236433 0233654|122555|10.20.30.50|023365433... (4 Replies)
Discussion started by: imas
4 Replies
Login or Register to Ask a Question