Split a String into an Array of Characters with No Delimiter in Azure Data Factory

Problem Statement

The split function within the offerings splits a string at each occurrence of a specified delimiter, returning the resulting substrings as elements of an array.

split('<text>', '<delimiter>')

Is it possible to split a String into an Array of Characters with No Delimiter?

Prerequisites

Azure Data Factory / Synapse Pipeline / Fabric Data Pipeline.

Solution

The initial step is to generate an array of integers, starting at 0, up to the length of the string which can then be leveraged for iteration purposes.

@range(0, length(pipeline().parameters.InputString))

Use For Each iteration to iterate over the Array Length.

@variables('InputStringRange')

Note. The For Each iteration should be Sequential.

Use Substring to get the character value from the input string in iterations over the string length and append within the array variable.

@substring(pipeline().parameters.InputString, item(), 1)

Result

Input

Output