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.
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)
