Re: 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

Comment on Re: Truncate Data from MySQL Download Code
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]
Re^3: Truncate Data from MySQL by wol (Hermit) on Jul 07, 2009 at 22:18 UTC
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]
Re^4: Truncate Data from MySQL by stevemayes (Scribe) on Jul 08, 2009 at 05:46 UTC
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]
Re^5: Truncate Data from MySQL by zebedee (Pilgrim) on Jul 08, 2009 at 07:53 UTC


good chemistry is complicated, and a little bit messy -LW
	PerlMonks