TextJoin

Excel TEXTJOIN / JOINDRE.TEXTE column expressions.

fabrictools.excel.text.TextJoin(delimiter: str, ignore_empty: bool, *parts: pyspark.sql.Column | str) → pyspark.sql.Column[source]

Join text parts with a delimiter (Excel TEXTJOIN / JOINDRE.TEXTE).

Parameters:

  • delimiter (str) – Separator between non-empty parts.

  • ignore_empty (bool) – When True, skip null and blank strings (Excel TRUE).

  • parts (Column | str) – Column expressions or string literals to concatenate.

Returns:

Concatenated column expression.

Return type:

Column

Example

>>> from fabrictools import Excel
>>> Excel.TextJoin(" | ", True, F.lit("a"), F.lit(""))