Find string match

[ddragosa]

Hello,

I have a question about searching a string.

For example I have the following string:

insert into table1 ( v1, v2 , v3) values ( v1, v2, v3)

How can I extract only what's between "into" and the first "(" ?. The name of the table?

Thank you.

[Ratazong]

$str =~ /into\s(.*?)\(/

Now you should have your name in the variable $1.

(see also the following info on regexes and greediness)


HTH, Rata

[Utilitarian]

Not quite
($tablename) = $str=~/\binto\s+([\S]+)/; Updated: on foot of cdarke's observations below

[cdarke]

Not quite
The match returns 1 (true). Maybe you are thinking of s?

$str=~/\binto\s+(\S+)/; 
my $tablename = $1;

[^\s] is better written as \S

[cdarke]

Or maybe:

my $tablename = ($str=~/\binto\s+([^\s]+)/)[0];

[ddragosa]

Thanks. I forget about the "?" after the (.*)

[bobf]

If you are going to do anything tricky or if you need more flexibility, you might want to consider using SQL::Statement::Structure instead.

[7stud]

use strict;
use warnings;
use 5.010;

my $query = 'insert into table1 ( v1, v2 , v3) values ( v1, v2, v3)';

my @pieces = split ' ', $query, 4;
say "-->$pieces[2]<---";

--output:--
-->table1<---