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?