01-31-2023 07:40 PM - last edited on 05-23-2023 04:41 AM by JackLacava
Hi All,
I am facing an interesting issue (or a bug).
Requirement: Capturing comments using a text box (linked with a literal parameter) and save it as annotation text so that it can be pulled in CV reports as well. Using literal parameter as I set it to stored comment using the BR when click on a cell in CV. I have a save button to save the comment if they want to change it and save it. when they save reading this text input in the textbox. so same textbox is used to display and write. I am passing this text as [|!Param!|] to rule. whole setup work great but found an issue when there is a unbalanced "[" or "]" then it throws this error.
Error: Invalid comma separated values. Unmatched brackets
wondering if anyone seen this or have a workaround to handle this? appreciate any help.
Solved! Go to Solution.
02-01-2023 10:36 AM
I'm not sure that using a literal parameter will help since multiple users can do this, and there is only one literal parameter. That being said not sure you can do much about that if they have a closing ] without an open one. You might have to tell users that if they are using ]s, then it must be balanced.
02-01-2023 10:36 AM
I'm not sure that using a literal parameter will help since multiple users can do this, and there is only one literal parameter. That being said not sure you can do much about that if they have a closing ] without an open one. You might have to tell users that if they are using ]s, then it must be balanced.
02-01-2023 10:43 AM
You could push your value through an XFBR to escape or remove unwanted character, like the one described here: https://community.onestreamsoftware.com/t5/Blog/Building-BiBlend-table-names-or-a-classic-tale-of-XF...
02-01-2023 10:45 AM
The problem is before even getting to a rule; it'll fail, which is what is there in his screenshot.
02-01-2023 11:24 AM
ah yes, i see what you mean. I'm sure there is a workaround...
02-01-2023 11:24 AM
Thank you all! appreciate quick response.