Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re: Truncate Data from MySQL

by poolpi (Hermit)
on Jul 07, 2009 at 12:58 UTC ( #777868=note: print w/replies, xml ) Need Help??

in reply to Truncate Data from MySQL

text to text:

$data->{pubText} =~ /\A((?:\w+\s){14}\w+).+/; my $text = $1 if defined $1; # ...


'Ebry haffa hoe hab im tik a bush'. Jamaican proverb

Replies are listed 'Best First'.
Re^2: Truncate Data from MySQL
by kulls (Hermit) on Jul 07, 2009 at 14:16 UTC

    I guess you can try with mySQl string functions() , so that you can do it through your sql query itself instead of fetching all the values from the db.
    - Raja
      I wondered about that as well, but having had a look at the MySQL reference, I can't see anything that would do what the OP needs.

      I'm no expert though. Is it possible? Can anyone enlighten?

      use JAPH;
      print JAPH::asString();

        SUBSTRING_INDEX() : Return a substring from a string before the specified number of occurrences of the delimiter

        And if you look at the actual description you see that positive n (count of the delimiter) returns the string to the left of the delimiter whilst negative n (e.g. -2) return the substring to the right of the nth delimiter. Now image that the delimiter is ' ' (which can be explicitly stated in Mysql as '<space>').

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://777868]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2023-02-05 23:56 GMT
Find Nodes?
    Voting Booth?
    I prefer not to run the latest version of Perl because:

    Results (33 votes). Check out past polls.