Is there a function to eat extra spaces in a string?

[mode09]

I know about rtrim, ltrim commands, but what I was interested in was a way to eat extra spaces also contained within strings.


For example:
myString = ' The dog is out side the house . ';

Is there a function that will keep one space between each word so the final result would be:
'The dog is outside the house.'

[Tim...]

Hi.

What about,

Code: Select all

Replace(variable, '  ', ' ')

If you think you might have more than two together, you could use regexp_replace.

Cheers

Tim...