You can use SRPL. The first set of quotes has one space between, the second
set of quotes have no space between
(SRPL( upc_txt, ' ', '', 0))
Karen
> I have a text column that has numbers with spaces interleaved (example 8
> 1234 5678 9). I am trying to strip the spaces so that I end up with the
> following 8123456789 (all of the numbers without spaces).
>
> I tried to accomplish this by using the following function:
>
> Update FINN set UPC_TXT = (sstrip(upc_txt,(char(032))))
>
> I have also tried:
>
> Update FINN set UPC_TXT = (sstrip(upc_txt,’ ‘))
>
>
>
> This does not work either:
>
> set var vTEST text = (sstrip('8 1234 5678 9',(char(032))))… the result is 8
> 1234 5678 9
>
>
>
> Any ideas what I am doing wrong.
>
>
>
