Formula Function Reference

Our Formula Function Reference

List - Text

Arguments: 
(Text d, Text t1, Text t2, ...)
Result Type: 
Text
Explanation: 
Concatenates (strings together) all arguments starting with the second argument, using the first argument as the delimiter between them. If one of the arguments is blank, it and the corresponding delimiter are omitted.
Example: 
List("-", "a", "b", "d") returns "a-b-d" List(", ", "a", "b", "", "d") returns "a, b, d" List(", ", [Last Name], [First Name]) returns "Last Name, First Name" if both fields are not empty, returns "Last Name" if [First Name] is empty, and returns "First Name" if [Last Name] is empty. List("\n", "Name", "Address Line 1", "", List(", ", "City", "State"), "Zip") returns "Name Address Line 1 City, State Zip"
Tags:

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit