http://qs1969.pair.com?node_id=777868


in reply to Truncate Data from MySQL

text to text:

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

[download]


hth,
PooLpi

'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
    Hi,

    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
[reply]
      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();

[reply]

        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>').

[reply]

In Section Seekers of Perl Wisdom