I thought someone suggested that, but I can't remember what happened to
it. We have a Perl internal language that works in 7.1beta. You
basically want a sed-type ability. I can see real value in that.
> Are there any plans to provide a regular expression substitution function,
> similar to translate but allowing more complex substitutions?
>
> This is an example of what I want to use it for. I am using a query that
> builds web urls from a couple of different types of data and then union
> together. Some of the data is raw urls, and some is title information
> that gets turn into search urls. The title information needs to be
> massaged before being used in a url and it needs to be done in the query
> if I want to do the union. The translate command could be used in my
> particular case, but it will be very long, as I need to delete most
> nonletter nondigit characters and change spaces to plusses. A regular
> expression describing what I want would be much more compact.
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026