Pattern matching


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Pattern matching
# 1  
Old 06-03-2013
Power Pattern matching

Code:
USING ('/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT1',
                '/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT2',
                '/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT3',
                '/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT4')
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibbdstr/sbdstridx'55360,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibbdstr/sbdstridx'55360,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibbdstr/sbdstridx'55360)
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibborg/sborgidx'500,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibborg/sborgidx'500,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibborg/sborgidx'500)
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibbpol/sbpolidx'18431544,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibbpol/sbpolidx'18431544,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibbpol/sbpolidx'18431544)
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibbprod/sbprodidx'317744,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibbprod/sbprodidx'317744,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibbprod/sbprodidx'317744)
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibbstag/sbstagidx'702704,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibbstag/sbstagidx'702704,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibbstag/sbstagidx'702704)


I need an o/p like the following

only within the single quotes

Code:
/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT1
/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT2
/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT3
/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT4
/udb/udbsi001/index01/udbsi001/RGC/sibbdstr/sbdstridx55360
/udb/udbsi001/index02/udbsi001/RGC/sibbdstr/sbdstridx55360
/udb/udbsi001/index03/udbsi001/RGC/sibbdstr/sbdstridx55360
/udb/udbsi001/index01/udbsi001/RGC/sibborg/sborgidx500
/udb/udbsi001/index02/udbsi001/RGC/sibborg/sborgidx500
/udb/udbsi001/index03/udbsi001/RGC/sibborg/sborgidx500
/udb/udbsi001/index01/udbsi001/RGC/sibbpol/sbpolidx18431544
/udb/udbsi001/index02/udbsi001/RGC/sibbpol/sbpolidx18431544
/udb/udbsi001/index03/udbsi001/RGC/sibbpol/sbpolidx18431544
/udb/udbsi001/index01/udbsi001/RGC/sibbprod/sbprodidx317744
/udb/udbsi001/index02/udbsi001/RGC/sibbprod/sbprodidx317744
/udb/udbsi001/index03/udbsi001/RGC/sibbprod/sbprodidx317744
/udb/udbsi001/index01/udbsi001/RGC/sibbstag/sbstagidx702704
/udb/udbsi001/index02/udbsi001/RGC/sibbstag/sbstagidx702704
/udb/udbsi001/index03/udbsi001/RGC/sibbstag/sbstagidx702704

Kindly provide the correct code.

Last edited by jim mcnamara; 06-03-2013 at 01:14 PM..
# 2  
Old 06-03-2013
What have you tried so far?
# 3  
Old 06-03-2013
Pattern matching

I've not tried anything. I was going through the SED tutorial how to extract things which is between the single quotes. Not deriving anything as of now.
# 4  
Old 06-05-2013
Try not to extract things between single quotes, which, btw, would not yield your sample output. Try to suppress/eliminate/remove everything outside those quotes, and then, remove the quotes themselves.
# 5  
Old 06-05-2013
Try this: This is for only within the single quotes.

awk -F"'" '{print $2}' inputfile

Note that the output you mentioned also contains piece outside the single quotes.
If that is the case, then I agree with what RudiC said.
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. Shell Programming and Scripting

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... (6 Replies)
Discussion started by: Siv_Pat
6 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