Re: sqlite: select statement not working

The problem is that the name + firstname value are in my table...
<- execute("Normand", " Bruce")= ( '0E0' ) [1 items] at Collabs_db.pm line 99

Are you sure that the firstname has that leading space?

Comment on Re: sqlite: select statement not working Download Code

Replies are listed 'Best First'.
Re^2: sqlite: select statement not working by frazap (Monk) on Nov 09, 2018 at 12:22 UTC
Bravo... I was extracting with `( $last, $first ) = ( $name =~ /^(.+),(.+)/ );` [download] And I should have used `( $last, $first ) = ( $name =~ /^(\w+),\s(\w+)/ );` [download] Thanks ! Update* And in fact, the above is not working except in simple case where first name has no space in it. `($name, $firstname) = ($value=~/(.+),\s(.+)/);` [download] works better since it takes first name like "J. F.", "Tim Jr.", or norwegian name with funny things on some character. F.	[reply] [d/l] [select]

Replies are listed 'Best First'.

I was extracting with

 ( $last, $first ) = ( $name =~ /^(.+),(.+)*/ );
[download]

 ( $last, $first ) = ( $name =~ /^(\w+),\s*(\w+)*/ );
[download]

Thanks !

Update

($name, $firstname) = ($value=~/(.+),\s*(.+)*/);
[download]