I need a help to make script to separate the multinumber in a field.

Discussion created by chs0615 on Jun 30, 2014
Latest reply on Jul 1, 2014 by LaRetta

I have two table, Member and Number.


Member contains MemberID, MultiNumber. (Ex. 100001 / 700001,70043,30003,32123 [MultiNumber field contains 1 thru about 10 number, it might have space after comma]
Number contain ID and Number.

I make relationship one to many ( Member --< Number )

Now I want to separate Multinumber and copy into potal container Number. How can I make a script to seperate like down below?


MemberID: 100001 Potal 100001 700001

100001 70043

100001 30003.....

Thank you.