Text functions

TextJoin

View as Markdown

The TextJoin function combines multiple text strings into a single string, inserting a delimiter between each value.

Syntax

TextJoin(delimiter, string_1, string_2, ...)

Function arguments:

delimiter(required) String to insert between each of the combined values.
string_1(required) First string to combine in the sequence.
string_2+(optional) Additional strings to combine in the sequence.

Notes

  • The delimiter is inserted only between values. It isn’t added before the first value or after the last value.
  • All arguments must be text. To combine a value of another data type with text data, convert the value to text using quotation marks or the Text function, such as Text([ID Number]).
  • A null value is treated as an empty string. The delimiter is still inserted on both sides of it, which produces consecutive delimiters in the output.
  • To combine strings without a delimiter, use the Concat function.

Examples

TextJoin("-", "555", "867", "5309")

Returns 555-867-5309.

TextJoin(", ", "Lincoln", Null, "Abe")

Returns Lincoln, , Abe. The Null value is treated as an empty string, so the delimiter is still inserted around it.

TextJoin(" to ", [Start Station Name], [End Station Name])

Returns the start and end station names joined by to, such as South Van Ness at Market to South Van Ness at Market.

A table titled TRIP with Start Station Name, End Station Name, and Trip path columns. The Trip path column combines the two station names with the word to between them, so the row with Spear at Folsom and Embarcadero at Bryant returns Spear at Folsom to Embarcadero at Bryant.

TextJoin(" to ", [Start Station Name], [Transfer Station Name], [End Station Name])

Returns the three station names joined by to. Because the delimiter is specified only once, you can add stops to the sequence without repeating it.

A table titled TRIP with Start Station Name, Transfer Station Name, End Station Name, and Trip path columns. The Trip path column combines all three station names with the word to between them, so the row with San Jose City Hall, Market at 4th, and San Jose City Hall returns San Jose City Hall to Market at 4th to San Jose City Hall.