Remove spaces from the text and combine them into a single text

Question

I have a text APPLE 23 under a field Fruits. I would like to remove the spaces and get a text as APPLE23. How to i do that in postgres?

-Thanks in advance.

score 2 · Answer 1 · answered Dec 17 '13 at 16:17

2

try this:

replace(mystring,' ','') to get rid of spaces in the string.

answered Dec 17 '13 at 16:17

BWS

score 0 · Answer 2 · answered Dec 17 '13 at 16:43

0

To replace characters (as opposed to whole strings), translate() is even faster:

SELECT translate (mystring, ' ', '')

answered Dec 17 '13 at 16:43

2 Answers2