Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

remove spaces from string

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!

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try using replace

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

Celambarasan

View solution in original post

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try using replace

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

Celambarasan

Sokkorn
Master
Master

Hi,

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

Regards,

Sokkorn

sivarajs
Specialist II
Specialist II

Hi,

i have another option

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

Regards,

Sivaraj S