Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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