Liquid Studio 2020
Data Mapping / Data Mapper Functions / By Category / String / SplitString
In This Topic
    SplitString
    In This Topic

    Function Name
    SplitString
    Category
    String
    Icon
    CodeToChar
    Description
    SplitString is used to break a delimited string into substrings.
    Inputs
    String The string to be split (whenever a separator character is found)
    Outputs
    Values A sequence of strings, each being a part of the input String being split
    Properties
    Separator A character that delimits the substrings in the input String
    Ignore Empty Omits empty values from the sequence being returned

    Usage

    Splits a string into the maximum number of substrings delimited by the characters specified in the Separators property. Empty values can be ignored by setting the appropriate property.

    Example 1

    Input String = "A,B,C,,D,E"

    Separator = ','

    Ignore Empty = false

    Result

    A
    B
    C
    D
    E
    Example 2

    Input String = "A,B,C,,D,E"

    Separator = ','

    Ignore Empty = true

    Result

    A
    B
    C
    D
    E

    Example 3

    In this example the input String is a sequence of strings. The result is the combination of all the split parts from each input value.

    Input Strings

    A,B,C,,D,E
    1,2,3
    X
    Separator = ','

    Ignore Empty = false

    Result

    A
    B
    C
    D
    E
    1
    2
    3
    X