Passing special characters in SAP Design Studio Query

[Former Member]

We have a query on SAP Design Studio with a prompt on a dimension. This dimension contains values with '(' and ')'. We are displaying this on a list box and then trying to pass the selected value to the prompt in the query. The query refresh fails with an error "Invalid Format". Any solution to this would be highly appreciated. Thanks!!

[jyothirmayee_s]

Hi,

How are you displaying your list box values?.

Thru a code?.

Thanks,

Jothi

[Former Member]

Hi Jothi,

List box values are populated through code - LISTBOX_1.setItems. The values contain '('.

[Former Member]

Hi Tammy,

Thanks for the links and appreciate your quick response. Even in the threads I couldn't find the right answer. I have the same issue when trying to replace special characters with a '\'. Design studio throws an error "Invalid Escape Sequence". Screenshots attached.special-characters-error-2.jpg special-characters-error.jpg

Code:

X_Filter_BUG = Convert.replaceAll(X_Filter_BUG, "(", "\(");

We are using SAP Lumira Designer 2.0 SP2 Patch 1.

[TammyPowlas]

Hi - I recommend searching for this; I searched and found these threads: https://archive.sap.com/discussions/thread/3703975

https://archive.sap.com/discussions/thread/3686092

If this doesn't help, please share some screen shots, along with version and SP of Design Studio you are using