topic remove spaces from string in QlikView

remove spaces from string

Wed, 21 Mar 2012 07:05:11 GMT

hi all,

i have a string: 'a b c'

which function do i use to remove the spaces in this string, to retrieve 'abc' ?

thanks a lot!

CELAMBARASAN — Wed, 21 Mar 2012 07:10:15 GMT

Hi,

Try using replace

Replace('a b c',' ','')

Celambarasan

Sokkorn — Wed, 21 Mar 2012 07:17:10 GMT

Hi,

I think Celambarasan is right. Just want to add more on this TRIM(REPLACE(Field,' ',''))

Regards,

Sokkorn

sivarajs — Wed, 21 Mar 2012 09:48:02 GMT

Hi,

i have another option

purgechar('a b c',chr(32))

Regards,

Sivaraj S