how can i delete text after final semi-colon

webster76

is there a way to delete everything after the final semi-colon within a page?

the script produce sql queries in a textarea that can be clicked and copied, but the last query is sometime incomplete.

INSERT INTO `jobs` ( `title` , `salary`,`duration`,`contact` ) VALUES ('chef','35000','full time ','555-5555');
INSERT INTO `jobs` ( `title` , `salary`,`duration`,`contact` ) VALUES ('teacher

this list may sometimes be 100 queries in length, but i need to delete everything after the final semi-colon.

thanks in advance

NogDog

$text = preg_replace('/;[^;]+$/', ';', $text);

Xager

$text = substr($text, 0, strripos($text, ";"));

Should work

webster76

@, thanks your code worked but also deleted the final semi-colon which wasnt a problem as i could has put it back with an echo ";"; on the final line.

@ worked liked a charm, correctly formed with the final semi-colon in place,

Thank you both.
Marked as resolved.