topic Re: Assigning a String having commas to a Variable in App Development

Assigning a String having commas to a Variable

durgesh22 — Mon, 20 Dec 2021 21:08:46 GMT

I am assigning a string value having commas to a variable ,but couldn't achieved expected.

set vVar= "Let vColumn = peek('Column', 0,'Config') ";

output which i am getting -->$(vVar) ="Let vColumn = peek('Column'"

Expected value is $(vVar)= "Let vColumn = peek('Column', 0,'Config') ";

Please advise what am i missing here.

Re: Assigning a String having commas to a Variable

marcus_sommer — Wed, 09 Sep 2020 10:35:07 GMT

A comma will be always treated as delimiter for a parameter. Therefore it's an expected behaviour - although it would be really desirable to have some logic to mask them.

What's the aim for your approach - why setting a variable-creation within another variable?

- Marcus

Re: Assigning a String having commas to a Variable

dirk_fischer — Wed, 09 Sep 2020 10:42:12 GMT

Hi Durgesh22

for me the code behaves exactly as you expect it. The only unexpected behaviour is, that the variable contains a double hypen after the set statement. But if you execute the variable, it does perfectly what you would expect. In my testdata, the value in the first dataset contains the string PRODUCT1, so everything is fine.

Regards

Dirk

TestcodeLog Testcode

Re: Assigning a String having commas to a Variable

marcus_sommer — Wed, 09 Sep 2020 12:04:27 GMT

I never tried this before but I could admit that it worked in QlikView, too.

Seems that you have anywhere a small syntax error in your approach. Nevertheless it looked for me more complicated as necessary.

- Marcus

Re: Assigning a String having commas to a Variable

dieterwoestemeier — Fri, 11 Sep 2020 01:25:43 GMT

Try something like this:

set vVar= 'Let vColumn = peek(''Column'', 0,''Config'')';