Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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
Partner

Hi,

     Try using replace

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

Celambarasan

View solution in original post

3 Replies
CELAMBARASAN
Partner
Partner

Hi,

     Try using replace

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

Celambarasan

View solution in original post

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