Skip to main content
A
Ashok
Contributor
February 1, 2023
Solved

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

  • February 1, 2023
  • 4 replies
  • 0 views

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

 

Best answer by ckattookaran

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.

4 replies

C
ckattookaranAnswer
Newcomer
February 1, 2023

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.

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
February 1, 2023

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-XFBR/ba-p/7843

    C
    ckattookaran
    Newcomer
    February 1, 2023

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

      J
      OneStream Employee
      JackLacavaOneStream Employee
      OneStream Employee
      February 1, 2023

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

      A
      AshokAuthor
      Contributor
      February 1, 2023

      Thank you all! appreciate quick response. 

      Terms & ConditionsAccessibility statement