topic Re: String List expression in QlikView

String List expression

rwunderlich — Mon, 26 Jan 2026 18:19:17 GMT

Can anyone come up with an expression (no script solutions) to convert this list:

A, B C, D

into

'A','B C','D'

This kinda works:

=chr(39) & replace(mytext',',', chr(39) & ',' & chr(39)) & chr(39)

Except it doesn't remove leading and trailing spaces from each element.

Thanks,

Rob

swuehl — Tue, 06 Mar 2012 23:12:53 GMT

Not sure if this is the best solution, but I think we need a way to iterate over the substrings and apply a trim.

So I reused something I used for substring removal (posted here:http://community.qlik.com/message/162166)

Please find attached an adaption to your problem.

Regards,

Stefan

CELAMBARASAN — Wed, 07 Mar 2012 04:55:39 GMT

Hi,

I tried and come up with this using valuelist function.

=Chr(39)&Concat(Trim(ValueList($(=chr(39) & replace('A, B, C, D',',', chr(39) & ',' & chr(39)) & chr(39)))), Chr(39) & ',' & Chr(39)) & Chr(39)

Celambarasan