String List expression

[rwunderlich]

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 · Accepted solution]

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]

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