AnsweredAssumed Answered

Problem with calculation in repeating field

Question asked by pm125 on Sep 12, 2018
Latest reply on Sep 14, 2018 by steve_ssh

I am trying (for the first time) to use the Get ( CalculationRepetitionNumber ) function to use a repetition number in a field that I am using like an array. The following calculation:

 

I want to extract the positions of the first 6 underscores in a filename, AH_FnameNoExt. For example, the value "Last_First_Month_Day_Year" should return 5, 11, ...

 

The following function is meant to create a repeating field with the position of the first underscore in repetition 1, of the second one in rep. 2, etc.

 

Position ( AH_FnameNoExt ; "_" ; 1 ; Get ( CalculationRepetitionNumber ) )

 

Instead, the repeating field contains the position of the first underscore in its first repetition; repetitions 2-6 are blank.

 

Can anyone figure out my error?

Outcomes