I believe, you had a keyword field. You can import that in one element of Sesame form. Make seven more Layout elements in the form and a little programming in MassUpdate will do the job for you to parse the value.

Following Code will help you:

var VMembers as String = Members
var vFirst as String
var vSecond as String
var vThird as String
var vFourth as String
var vFifth as String
var vSixth as String
var vSeventh as String
var vEighth as String
var vSeparator as char = ";"


If @right(vMembers, 1) <> vSeparator then

     {
           vMembers = VMembers + vSeparator
     }


vFirst =  @Left (vMembers, (@in (VMembers, vSeparator) - 1))
vMembers = @replace (vMembers, @Left (vMembers, @in (VMembers, vSeparator)), "")

vSecond =  @Left (vMembers, (@in (VMembers, vSeparator) - 1))
vMembers = @replace (vMembers, @Left (vMembers, @in (VMembers, vSeparator)), "")

vThird =  @Left (vMembers, (@in (VMembers, vSeparator) - 1))
vMembers = @replace (vMembers, @Left (vMembers, @in (VMembers, vSeparator)), "")

vFourth =  @Left (vMembers, (@in (VMembers, vSeparator) - 1))
vMembers = @replace (vMembers, @Left (vMembers, @in (VMembers, vSeparator)), "")

vFifth =  @Left (vMembers, (@in (VMembers, vSeparator) - 1))
vMembers = @replace (vMembers, @Left (vMembers, @in (VMembers, vSeparator)), "")

vSixth =  @Left (vMembers, (@in (VMembers, vSeparator) - 1))
vMembers = @replace (vMembers, @Left (vMembers, @in (VMembers, vSeparator)), "")

vSeventh =  @Left (vMembers, (@in (VMembers, vSeparator) - 1))
vMembers = @replace (vMembers, @Left (vMembers, @in (VMembers, vSeparator)), "")

vEighth =  @Left (vMembers, (@in (VMembers, vSeparator) - 1))
vMembers = @replace (vMembers, @Left (vMembers, @in (VMembers, vSeparator)), "")


//WriteLn (vFirst, vSecond, vThird, vFourth, vFifth, vSixth, vSeventh, vEighth)

//Members is your present LE, the value of which you need to parse

//Reassign the value of various variables to your newly created LEs

MembersTeamA = vFirst
MembersTeamB = vSecond
MembersTeamC = vThird
MembersTeamD = vFourth
MembersTeamE = vFifth
MembersTeamF = vSixth
MembersTeamE = vSeventh
MembersTeamF = vEighth

I hope this helps.  The code seems long but it is the repeatition of the same code eight times.

Jyellis, please note the modified post with added code in the suggestion of accomplishing the task with MassUpdate.   

I do not think, you assigned the value of variables to your LEs.  I have included those statement in my earlier post. Please note... in the earlier post, change the LE in the code as necessary.


You will have to start all over as value of the keyfield must have vanished altogether.