Search the Community
Showing results for tags 'comma delimited'.
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.
I had this workflow that a user will enter Names in one text filed separated by a "," and that input would be inserted on a separate table but 1 name per column. To solve this I created a small Trigger that will separate all inputs and insert them to a different table. The trigger above can also be modified to fit other "separator".