Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

! regexp_replace

Status
Not open for further replies.
NickBelgium

NickBelgium

Programmer
Nov 6, 2006
1
BE
hello,

how can i convert the following php expression: preg_replace("/[^a-zA-Z ]/", "", $iVeldInhoud) to postgresql.

<?php
$iVeldInhoud = "Hallo hier hilve-rsum! Hoe gaat het ermee? Hoe is het nu? ewel zulle?";
$iVeldInhoud = preg_replace("/[^a-zA-Z ]/", "", $iVeldInhoud);
print $iVeldInhoud;
?>


I would like the following expression:

SELECT regexp_replace('Hallo hier hilve-rsum! Hoe gaat het ermee? Hoe is het nu? ewel zulle?', 'regex', '');

result in:

Hallo hier hilve-rsum Hoe gaat het ermee Hoe is het nu ewel zulle


How can I Accomplish this?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top