******* Passing Multiple Comma separated values into text box prompt *********

[Good Friend]

Hello Friends,

I'm looking for a prompt functionality in Cognos Analytics that allows users to input multiple values, such as 01,02,03,04,05 into a text box or similar prompt. While a search-and-select option is already provided, users prefer a comma-separated input method to enter all values simultaneously. The goal is to dynamically filter the query based on these inputs. I've tried using prompt macros but haven't had success. Any insights, suggestions, or workarounds would be greatly appreciated. Thank you!