Unanswered question

How to separate the variables into different columns from shared queue?

Under variable manager, I have a Shared Queue variable created. There's a column separator option there where I chose comma as the delimiter but when I use comma for the values under my variable modifier it doesn't output the two values into separate columns as it should. I get var1,var2 both in the same column.

Aayush S.
Aayush S.

Aayush S.

Level
1
189 / 750
points

Answers

Roland D.
Roland D.

Roland D.

Level
0
40 / 100
points

I also have this behaviour, and found a workaround.

I want to have 3 values in one shared queue line. As you can use a csv file, it is obvious that you assume to seperate colums with a comma character or a semicolon character. But the behaviour is strange and not intuitive.

I did this: I use a different column separator like the $ sign, where I'm sure this character will never be in a value,you can take any (special) character. But I dont make use of the $ sign as a separator, its just a dummy.

Then I put sth. like this into "Add the value" field of a "Modify value" action:
${CustomerID};${CustomerName};${CustomerZipCode}

Then I get lines like
4711;Meyer;012345

If you use semicolon as column separator AND use semicolons between variables in the "Add the value" field, then the whole string gets escaped with quotation marks like:
"4711;Meyer;012345", which is useless.

And it gets worse if I insert more quotation marks like:
${CustomerID}";"${CustomerName}";"${CustomerZipCode}
The idea is to get sth like: "4711";"Meyer";"012345"

You get:"4711"";""Meyer"";""012345" (quotation marks also get escaped)