I have a field that is in a table that is a semicolon delimited list and I need to parse that list out to have each value in either a multivalue token or in a separate token that I can then save into a new table and then repeat until each value of the list is put into a new table.
The token is currently like this:
First M Last; firstn mi lastn; firstname lastname
But there may be 100 names in that list and I need each one to be in it's own cell in a different table.