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.
|