Visit Our UNIX and Linux User Community


Perl Repetitive Pattern Matching


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Perl Repetitive Pattern Matching
# 1  
Old 08-05-2009
Perl Repetitive Pattern Matching

Problem:

GIVEN
=======
my $sql="INSERT INTO table_nm(a, b, b, d, e, f , g) VALUES (2046, TODAY, 'Change Subscription Name', '00000000000002000000000000000000000000000000000000', '00000000000001000000000000000000000000000000000000', '00000000000000000000000000000000000000000000000000', 1); ";

Required O/P:
================
a=2046 AND b=TODAY AND c='Change Subscription Name' AND d='00000000000002000000000000000000000000000000000000' AND e='00000000000001000000000000000000000000000000000000' AND f='00000000000000000000000000000000000000000000000000' AND g=1

WHAT I DID:
Code:
if ( $sql =~ m/^\s*INSERT\s+INTO\s+.*VALUES\s*\(/ )
   {
                          $sql =~ s/^\s*INSERT\s+INTO\s+[^\(]*\((.*),?\)\s+VALUES[\s]*\(([^\)]*)\).*/$1|--|$2/i;
                          $sql =~ s/([^,]*),.*?\|--\|([^,]*),.*?/$1=$2 AND/gi;
                          print "$sql"
   }

Actual Output:

a=2046 AND TODAY, 'Change Subscription Name', '00000000000002000000000000000000000000000000000000', '00000000000001000000000000000000000000000000000000', '00000000000000000000000000000000000000000000000000', 1


Can you please suggest me how to get the required output?



Last edited by Yogesh Sawant; 08-05-2009 at 07:17 AM.. Reason: added code tags
# 2  
Old 08-05-2009
Code:
my $sql="INSERT INTO table_nm(a, b, c, d, e, f , g) VALUES (2046, TODAY, 'Change Subscription Name', '00000000000002000000000000000000000000000000000000', '00000000000001000000000000000000000000000000000000', '00000000000000000000000000000000000000000000000000', 1); ";
my @arr=$sql=~/\(([^)]*)\)/g;
my @tmp1=split(",",$arr[0]);
my @tmp2=split(",",$arr[1]);
for(my $i=0;$i<=$#tmp1;$i++){
	print $tmp1[$i],"=",$tmp2[$i]," AND ";
}

# 3  
Old 08-05-2009
Quote:
Originally Posted by summer_cherry
Code:
my $sql="INSERT INTO table_nm(a, b, c, d, e, f , g) VALUES (2046, TODAY, 'Change Subscription Name', '00000000000002000000000000000000000000000000000000', '00000000000001000000000000000000000000000000000000', '00000000000000000000000000000000000000000000000000', 1); ";
my @arr=$sql=~/\(([^)]*)\)/g;
my @tmp1=split(",",$arr[0]);
my @tmp2=split(",",$arr[1]);
for(my $i=0;$i<=$#tmp1;$i++){
    print $tmp1[$i],"=",$tmp2[$i]," AND ";
}

Thanks summer_cherry.

But I want to do the whole things only by pattern matching.

---------- Post updated at 05:17 AM ---------- Previous update was at 05:15 AM ----------

Input is changed little bit. Inside the quotes ',' can present... Please try to use pattern matching only
GIVEN
=======
my $sql="INSERT INTO table_nm(a, b, b, d, e, f , g) VALUES (2046, TODAY, 'Change Subscription Name', '000000000000020000, 0000000000000000000000, 0000000000', '00000000000001000, 000000000000000000000000000000000', '0000000000000000,0000000000000000000000000000000000', 1); ";
Required O/P:
================
a=2046 AND b=TODAY AND c='Change Subscription Name' AND d='000000000000020000, 0000000000000000000000, 0000000000' AND e='00000000000001000, 000000000000000000000000000000000AND f='0000000000000000,0000000000000000000000000000000000' AND g=1

Previous Thread | Next Thread
Test Your Knowledge in Computers #783
Difficulty: Medium
Microsoft launched its first retail version of Microsoft Windows in 1983.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl - Use of *? in Matching Pattern

I am using Perl version 5.8.4 and trying to understand the use of regular expression. Following is my code and output. $string = "Perl is a\nScripting language"; ($start) = ($string =~ /\A(.*?) /); @lines = ($string =~ /^(.*?) /gm); print "First Word (using \\A): $start\n","Line... (4 Replies)
Discussion started by: jnrohit2k
4 Replies

2. Shell Programming and Scripting

Pattern matching in Perl

Hi, I have a list of IP, eg : 192.168.0.15 192.168.0.24 192.168.2.110 192.168.2.200 And I would like the shortest pattern who match with '192.168.0' and '192.168.2' (without the last dot and number). (7 Replies)
Discussion started by: X-Or
7 Replies

3. Shell Programming and Scripting

Need help with perl pattern matching

My log file looks as given below, its actually a huge file around 1 GB and these are some of the line: conn=5368758 op=10628050 msgId=64 - RESULT err=0 tag=101 nentries=1 etime=0 conn=7462122 op=-1 msgId=-1 - fd=247 slot=247 LDAPS connection from 10.13.18.12:37645 to 10.18.6.45 conn=7462122... (5 Replies)
Discussion started by: sags007_99
5 Replies

4. Shell Programming and Scripting

Pattern Matching in PERL

I have a 2 files in .gz format and it consists of 5 million lines the format of the file would be gzcat file1.gz | more abcde aerere ffgh56 .. .. 12345 gzcat file2.gz | more abcde , 12345 , 67890, ffgh56 , 45623 ,12334 whatever the string is in the file1 should be matched... (3 Replies)
Discussion started by: aravindj80
3 Replies

5. Shell Programming and Scripting

Perl Pattern matching...

I am doing a file patterhn matching for a text file in PERL I am using this,,, but it says that no file is found $filepattern = '\d{1,4}.*A0NW9693.NDM.HBIDT.*.AD34XADJ.txt'; Can anyone help me out with Perl Pattern Matching concepts and how to do pattern matching for this txt file:... (4 Replies)
Discussion started by: msrahman
4 Replies

6. Shell Programming and Scripting

Perl pattern matching!!

Hi experts, I have many occurances of the following headers in a file. I need to grep for the word changed/inserted in the header, calculate the difference between the two numbers and list the count incrementally. Headers in a file look like this: ------------------- ---------------------... (6 Replies)
Discussion started by: nmattam
6 Replies

7. Shell Programming and Scripting

Perl Pattern Matching

Hello experts, I have a file containing the following text(shortened here). File Begin ---------- < # Billboard.d3fc1302a677.imagePath=S:\\efcm_T4 < Billboard.d3fc1302a677.imagePath=S:\\efcm_T4 --- > # Billboard.d3fc1302a677.imagePath=S:\\efcm_Cassini >... (2 Replies)
Discussion started by: nmattam
2 Replies

8. Shell Programming and Scripting

Perl -Pattern Matching help..!

Hi, I got doubt in Pattern matching, could you tell me how the following differs in action ?? if ( $line1==/$line2/ ) if ( $line1=~/$line2/ ) if ( $line1=~m/$line2/) What is the significance of '~' in matching. Thanks in advance CoolBhai (5 Replies)
Discussion started by: coolbhai
5 Replies

9. Shell Programming and Scripting

Perl Pattern Matching !!! Help

Hello I got the below one from in one of this forums For Ex: Loading File System Networking in nature now i need to extract the patterns between the words File and Networking : i.e. sample output: System cmd used : cat <file> | sed 's/.*File //' | sed 's/Closing.*$//' Actually... (0 Replies)
Discussion started by: maxmave
0 Replies

10. Shell Programming and Scripting

perl pattern matching

hi i am trying to get digits inside brackes from file , whose structure is defined below CREATE TABLE TELM (SOC_NO CHAR (3) NOT NULL, TXN_AMOUNT NUMBER (17,3) SIGN_ON_TIME CHAR (8) TELLER_APP_LIMIT NUMBER (17,3) FIL01 ... (2 Replies)
Discussion started by: zedex
2 Replies

Featured Tech Videos