Search the Community
Showing results for tags 'parse data'.
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.