Calc. field based on a repeating text field?

[ibiubu]

I have a repeating text field with 3 repeats. It is basically for entering email addresses. so the three repeating lines would have something like this entered:

[email protected]

[email protected]

[email protected]

I want a calculation field that links to the above email field, and some sort of calculation that can look at the 3 repeating lines and return something formatted like this:

[email protected],[email protected],[email protected]

Anyone have any thoughts as to the type of calculation that would show the information in all 3 repeating fields?

LR

[bobsmith]

Substitute(GetRepetition(emailRepeat,1),"

[ibiubu]

YIKES. I thought I understood File Maker calculations pretty well, but this one is a whopper. Works as promised, but what a calculation. Would have never guessed.

LR

[Anders]

Hello

Can't control myself, must publish link to incredible calculations:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB16&Number=14515&page=&view=&sb=&o=&vc=1

This one actually has no connection at all to your problem, but if you ever want to use holiday dates in your calculations...

Scroll down to the advanced stuff further down!

-Anders