regular expression problem (preg_replace)

[monomaniac21]

hi all

using preg_replace

how can i replace the letter i in a string with nothing (delete it)
when it is the last letter or it is followed by an i?

i have products that are listed in a db with i or ii as in 320ii and i
want to strip out the i's at the end when displaying the product name

thanks

marc

[Rik]

monomaniac21 wrote:

hi all

using preg_replace

how can i replace the letter i in a string with nothing (delete it)
when it is the last letter or it is followed by an i?

i have products that are listed in a db with i or ii as in 320ii and i
want to strip out the i's at the end when displaying the product name

With last latter, do you mean last letter in a word or the real last
character.
Word:
preg_replace('/i(\b|i)/i','$1',$string);
Dead last:
preg_replace('/i($|i)/si','$1',$string);

If you want to strip out ALL ending i's:
preg_replace('/i+(\b)/i','$1',$string);
--
Rik Wasmus

[Rik]

Rik wrote:

preg_replace('/i($|i)/si','$1',$string);

No need for the /s modifier offcourse...
--
Rik Wasmus

[monomaniac21]

Rik wrote:

Rik wrote:

preg_replace('/i($|i)/si','$1',$string);

No need for the /s modifier offcourse...
--
Rik Wasmus

hi rik that works great for instances of a single i at the end of the
string (last character) but i also need it to strip out any i's that
occur next to other i's so for example:

230ii := 230, 230iiiiii := 230,
just as 230i := 230

thanks for your help

marc

[Rik]

monomaniac21 wrote:

Rik wrote:

>Rik wrote:

>>preg_replace('/i($|i)/si','$1',$string);

No need for the /s modifier offcourse...
--
Rik Wasmus

hi rik that works great for instances of a single i at the end of the
string (last character) but i also need it to strip out any i's that
occur next to other i's so for example:

230ii := 230, 230iiiiii := 230,
just as 230i := 230

The last one should work:
preg_replace('/i+(\b)/i','$1',$string);
--
Rik Wasmus

[william]

On Wed, 03 Jan 2007 07:37:02 -0800, monomaniac21 wrote:

hi all

using preg_replace

how can i replace the letter i in a string with nothing (delete it)
when it is the last letter or it is followed by an i?

i have products that are listed in a db with i or ii as in 320ii and i
want to strip out the i's at the end when displaying the product name

thanks

marc

if you have a huge database it might be better to use stored procedure :

(vars between "{}" have to be adapted to your table/field)

DELIMITER ?
CREATE PROCEDURE sp ()
BEGIN
DECLARE id INT;
DECLARE currentid INT DEFAULT 0;
DECLARE productname VARCHAR(128);
DECLARE newproductname VARCHAR(128);
DECLARE maxid INT DEFAULT 0;
SELECT max({product_id}) INTO maxid FROM {product} where {product_id} >
current AND {product_name} REGEXP 'ii$';

WHILE ( current < maxid+1 ) DO

SELECT {product_id},{product_name} INTO id,productname FROM {product}
where {product_id} current AND {product_name} REGEXP 'ii$' LIMIT 1;
newproductname = LEFT(productname,LENGTH(productname)-1);

UPDATE {product} set {product_name} = newproductname WHERE {product_id}
=id;

current=id;

END WHILE;
END?
DELIMITER ;

[Petr Vileta]

"monomaniac21" <mc******@googlemail.compíse v diskusním príspevku
news:11**********************@n51g2000cwc.googlegr oups.com...

hi all

using preg_replace

how can i replace the letter i in a string with nothing (delete it)
when it is the last letter or it is followed by an i?

i have products that are listed in a db with i or ii as in 320ii and i
want to strip out the i's at the end when displaying the product name

preg_replace('/^([^i]+)i*$/i','$1',$string);

320i will be 320
320ii will be 320
preg_replace('/^(.+)i*$/i','$1',$string);

320i will be 320
320ii will be 320i

--

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)

[Curtis]

<?php
$regex = '
/
([^i]+) # product name before i. You could also negate \s to
validate, if necessary
i+(?:\b|$) # one or more is before a word boundary or end of line
/x';

$product = preg_replace($regex, '$1', $product);
?>

Just tested it, and it seems to work how the OP specified. This will
replace all i's following the product name:

$p = '320i 320ii 400 555iiii';

Becomes

320 320 400 555

Curtis

On Jan 3, 7:37 am, "monomaniac21" <[e-mail]:

hi all

using preg_replace

how can i replace the letter i in a string with nothing (delete it)
when it is the last letter or it is followed by an i?

i have products that are listed in a db with i or ii as in 320ii and i
want to strip out the i's at the end when displaying the product name

thanks

marc