Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
    • Neuroanalyst for creating calculated fields
      • All Functions
        • Overview
        • ARRAY
        • ARR_AVG
        • ARR_DISTINCT
        • ARR_INDEX_OF
        • ARR_INTERSECT
        • ARR_MAX
        • ARR_MIN
        • ARR_PRODUCT
        • ARR_REMOVE
        • ARR_STR
        • ARR_SUM
        • CAST_ARR_FLOAT
        • CAST_ARR_INT
        • CAST_ARR_STR
        • CONTAINS
        • CONTAINS_ALL
        • CONTAINS_ANY
        • CONTAINS_SUBSEQUENCE
        • COUNT_ITEM
        • GET_ITEM
        • LEN
        • REPLACE
        • SLICE
        • STARTSWITH
        • UNNEST
      • Function Availability
    • Parameters
  • DataLens Gallery
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. Array functions
  4. ARR_STR

ARR_STR

Written by
Yandex Cloud
Updated at December 19, 2025
View in Markdown

SyntaxSyntax

ARR_STR( array [ , delimiter [ , null_str ] ] )

DescriptionDescription

Concatenates elements of the array array using delimiter as a delimiter (comma by default) and null_str as a NULL string (NULL items are skipped by default).

See also STR

Argument types:

  • array — Array of fractional numbers | Array of integers | Array of strings
  • delimiter — String
  • null_str — String

Return type: String

Note

Only constant values are accepted for the arguments (delimiter, null_str).

ExamplesExamples

ARR_STR(ARRAY(1, 2, NULL, 4)) = 1,2,4
ARR_STR(ARRAY(1, 2, NULL, 4), ';') = 1;2;4
ARR_STR(ARRAY(1, 2, NULL, 4), ';', '*') = 1;2;*;4
ARR_STR(ARRAY('a', 'b', '', NULL), ';', '*') = a;b;;*

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, PostgreSQL 9.3, Trino, Yandex Documents.

Was the article helpful?

Previous
ARR_REMOVE
Next
ARR_SUM
© 2026 Direct Cursus Technology L.L.C.