Oracle Analytics Cloud and Server

Home› Oracle Analytics› Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Issue with substr

Received Response
4
Views
1
Comments
user12863665
user12863665 ✭✭✭✭✭
edited August 13 in Oracle Analytics Cloud and Server

Hi , i am having some issue with substr.

my requirement is, i want to extract separate values based on the users selected(single or multiple) prompt values to use it in calculations. below values i am getting from presentation variable and those values dynamically change.

ABC,EFG,XYZ

ABC,EFG

ABC

users can select either one or multiple values. anyone suggest me how can i separate each value to use it in different calculations? i am trying to use substr with locate, but i am getting some issue.

anyone suggest me how can i achieve this with generic substr for all scenarios regardless if user passes one value or multiple values?

Answers