On Wednesday 19 Feb 2003 9:25 pm, Darren Ferguson wrote:
> Don't know if this is what you are looking for but the following will
> remove them
>
> select translate('hello \nworld \n',' ','');
But surely this will remove *all* spaces, wheras Dave seemed to want only
spaces before newline characters.
> > > I would like to remove the trailing blanks between the last character
> > > and the newline. I would like to use replace with a regx like
> > > /[ ]+\n/\n/ but it does not seem to work.
--
Richard Huxton