Skip to main content
Contributor
Feb 1, 2023 12:40 AM UTC
Solved

Literal parameter : issue with unbalanced [ or ] in the text being input

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.

 

Ashok_1-1675211369275.png

 

Member
Feb 1, 2023 3:36 PM UTC

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.

5 replies

Member
Feb 1, 2023 3:36 PM UTC

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.

Employee - Sage
Feb 1, 2023 3:43 PM UTC

You could push your value through an XFBR to escape or remove unwanted character, like the one described here: https://community.onestream.com/topic/show?tid=5239&fid=59

Member
Feb 1, 2023 3:45 PM UTC

The problem is before even getting to a rule; it'll fail, which is what is there in his screenshot.

Employee - Sage
Feb 1, 2023 4:24 PM UTC

ah yes, i see what you mean. I'm sure there is a workaround...

AshokAuthor
Contributor
Feb 1, 2023 4:24 PM UTC

Thank you all! appreciate quick response.