Issue with substr

user12863665

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?

John Thorton

Query with substr

DUPLICATE THREAD!

do NOT multi-post