How to replace multiple spaces between words with a single space in teradata SQL?

Question

I have to compare two columns say A and B. If they change I need to print both the values as old and new values.
But the problem is that the 2nd column is having some extra spaces between the words, so the names are displayed even though the name didn't change > help me out on this. I am looking for a SQL query in teradata

dnoeth · Accepted Answer · 2013-12-16 10:16:38Z

3

What's your Teradata release?

In TD14 there's REGEXP_REPLACE, before you might have the oREPLACE UDF installed:

TRIM(REGEXP_REPLACE(x, '( )+',' ',1,0,'c'))
TRIM(OREPLACE(OREPLACE(OREPLACE(x,'     ',' '), '   ',' '), '  ',' ')

You can get rid of the TRIM if you don't have leading or trailing blanks.

answered Dec 16, 2013 at 10:16

dnoeth

60.5k4 gold badges45 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to replace multiple spaces between words with a single space in teradata SQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related