Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Hi,

     Try using replace

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

Celambarasan

View solution in original post

3 Replies
Highlighted

Hi,

     Try using replace

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

Celambarasan

View solution in original post

Highlighted
Master
Master

Hi,

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

Regards,

Sokkorn

Highlighted
Specialist II
Specialist II

Hi,

i have another option

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

Regards,

Sivaraj S