you can loop on all records.
For each record,
Set Variable $MultiID = substitute(content; ", "; ¶)
Set Variable $VCMultiID = valueCount($MultiID)
Set Variable $i = 0
exit loop if (let $i = $i +1; $i > VCMultiID)
set variable $CurrentID = GetValue($MultiID; $i)
do stuff with it ("it" being content with ID = $CurrentID) , like create a new record etc
I just told you a part of my problem. I will explain everything.
I have 3 tables: Flag, Color and Flag-Color
I pulled all the information from internet, so this is what I have and need.
First I need an script to take the color name and write the number from Color table to the color_id field, I made one script and It works with only one color, if it has 2 or more colors it doesn't copy anything.
After that I need to automate and copy the Flag ID and the Color_ID one by one on to the Flag-Color Table, like this:
Thank you for all your help
Thank you so much, I appreciate your help and the solution is excellent.
You're a master