Repetition To List ( RepText )

Get values from a repeating field and paste them as a List

Be the first to rate this function Log in to vote

Paulo Tavares - Show more from this author

Sample input:

Repetition To List (RepeatingField)

Sample output:

1
2
3

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [

// Get the field name in the oficial format TableName::FieldName

    ofn = GetFieldName ( RepText);

//Find the separator position

    pos = Position ( ofn; "::"; 1 ; 1 ) + 1;

//Get the simple FieldName we need

    fn = Right ( ofn; Length ( ofn ) - pos);
    
// Prepare the draft of the expression    

    predraft = "FieldRepetitions ( " & "\"" & Get ( FileName ) & "\"" & ";"  & "\""  &   Get ( LayoutName ) & "\"" & ";"  & "\"" & fn & "\""  & ")" ;
    
// Use Evaluate to extract the repetition result from FieldRepetitions (for example "10 vertical") 

    draft = Evaluate ( predraft );

// Parse the first word to get the number of repetitions as a number

    repetitions = GetAsNumber ( LeftWords ( draft ; 1 ) ) ;
    
//Initialize the rest of the calculation variables

    i = 1 ;
    list = ""
];

// Use While to loop through the repetitions and build the list

    While (
        [ 
            list = "" ; 
            i = 1 
        ] ; 
        i <= repetitions ; 
        [ 
            list = list & GetRepetition ( RepText ; i ) & ¶ ; // Append each repetition value to the list
            i = i + 1 
        ] ; 
        Trim ( list ) // Return the list, trimmed to remove the last extra carriage return
    )
)

Enter a repeating field as parameter (RepText)
Use the function to define a calculation text field or a variable that will become a list of values separated by carriage returns
Each value can have one or several words

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Repetition To List ( RepText )

Comments

Support this website.

Support this website.