Hello,
I have a multi-select listbox on a datapage called "TeachingArtists" where a user can select one or more artists and assign them to an educational program that is taught in schools.
On a separate data page, I have the user selecting the program name and have a cascading listbox that filters on program name so user sees only the artists linked to the program name. The problem I am running into is that the some of the entries in the listbox contain multiple values of artists names separated by commas where ideally I want each artist name listed separately.
Is there a way that I can parse the comma delimited artist name values and present them as single entries in the listbox?
I am attaching a screen shot for reference.
Thank you for your help.