duckplus.functions.scalar.string#

String-oriented scalar DuckDB macros exposed as Python helpers.

Functions#

split_part(...)

Split a string by delimiter and return the 1-indexed part.

array_to_string(...)

Join array elements into a string using the supplied separator.

array_to_string_comma_default(...)

Join array elements with a comma separator when none is provided.

Module Contents#

duckplus.functions.scalar.string.split_part(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) duckplus.static_typed.expression.VarcharExpression#

Split a string by delimiter and return the 1-indexed part.

Overloads: - main.split_part(ANY string, ANY delimiter, ANY position) -> VARCHAR

duckplus.functions.scalar.string.array_to_string(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) duckplus.static_typed.expression.VarcharExpression#

Join array elements into a string using the supplied separator.

Overloads: - main.array_to_string(ANY arr, ANY sep) -> VARCHAR

duckplus.functions.scalar.string.array_to_string_comma_default(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) duckplus.static_typed.expression.VarcharExpression#

Join array elements with a comma separator when none is provided.

Overloads: - main.array_to_string_comma_default(ANY arr, ANY sep) -> VARCHAR