Reference > Functions reference > Text functions > GetValue
 
GetValue
Purpose 
Returns the requested value given by valueNumber from listOfValues.
Format 
GetValue(listOfValues;valueNumber)
Parameters 
listOfValues - a list of carriage return-delimited values
valueNumber - the value to return from the list
Data type returned 
text
Originated in 
FileMaker Pro 8.0
Description 
This function is useful in looping scripts or recursive custom calculations.
Values are text items separated by carriage returns. You can place several values together to create a carriage return-delimited list of values. A value can be empty, a single character, a word, a sentence, or a paragraph. When you press Enter or Return, you start creating a new value. The last value will be recognized with or without a carriage return.
When the listOfValues parameter is a literal string, you must insert a literal carriage return character (¶) between each item in the string. To insert a literal carriage return character, click the button in the Specify Calculation dialog box.
Examples 
GetValue(“London¶Paris¶Hong Kong”;2) returns
Paris
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas