Replacing blank fields in a repeatting field of 15

[spaceboy]

I need a script that replaces blank fields in a repeating field of 15 with a "-".Does anyone know how to do this ?

Thanx

[ernst]

set YourRepeatingField [(-1), Case(isEmpty(GetRepetition(YourRepeatingField, 1))), "-"]

set YourRepeatingField [(-2), Case(isEmpty(GetRepetition(YourRepeatingField, 2))), "-"]

:

:

:

set YourRepeatingField [(-15), Case(isEmpty(GetRepetition(YourRepeatingField, 15))), "-"]

I would think...

Regards,

Ernst

[spaceboy]

thanx , but that seemed to be invalid, too many seperaters , strange !!

[ernst]

how did you enter the formula? Copy it from my post? There is one closing bracket to much in there, so try:

Case(isEmpty(GetRepetition(YourRepeatingField, 1 )), "-")

etc.

Ernst.

[Lee Smith]

His spaceboy,

by chance are you using a non US copy of FileMaker?

If so, you need to use the semicolon ( instead of the comma (,) in the calculation.

HTH

Lee