This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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!
Try using replace
Replace('a b c',' ','')
View solution in original post
I think Celambarasan is right. Just want to add more on this TRIM(REPLACE(Field,' ',''))
i have another option
purgechar('a b c',chr(32))