Don't know if this is what you are looking for but the following will
remove them
select translate('hello \nworld \n',' ','');
HTH
Darren
On Wed, 19 Feb 2003, Richard Huxton wrote:
> On Wednesday 19 Feb 2003 5:07 pm, Dave Smith wrote:
> > I have a field of type text that has a value like
> >
> > 'hello \nworld \n'
> >
> > 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.
>
> The replace function doesn't handle regexps AFAIK - you could look at
> SUBSTRING() in the POSIX Regexp section of the functions reference but I
> don't think that's going to do it either.
>
> The problem is you seem to want to remove spaces after "hello" and "world" - I
> think that means you need perl regexps or a loop.
>
> Unless some posix guru steps forward, I'd say the easiest way is to build a
> loop that repeatedly calls replace(my_string,' \n','\n')
>
--
Darren Ferguson
