4. New SPLIT function for Formula Editor

Introducing #

• In modern data integration and transformation workflows, the ability to efficiently manipulate and parse text strings is crucial. The Skyvva Integration App, a native Salesforce solution, offers a comprehensive formula editor that supports various text functions. However, it currently absence a dedicated SPLIT function, which is essential for dividing strings based on specific delimiters.
• Introducing aSPLIT function would significantly enhance the formula editor’s capabilities. This function would allow users to divide a text string into an array of substrings using a specified separator. For instance, it SPLIT("a|b|c","|") would yield ["a","b","c"]. Such functionality is particularly beneficial when dealing with delimited data fields, enabling more straightforward data parsing and transformation within integration processes.

The proposed implementation of the SPLIT Function in the Skyvva Integration App’s formula editor would be as follows:

Prerequisite #

To enhance the text processing capabilities within the SKYVVA Integration App’s Formula Editor, a new ‘SPLIT‘ function is proposed. This function aims to provide users with a straightforward method to divide strings based on specified delimiters, thereby facilitating more efficient data transformation and mapping processes.

Function Definition:

• Name: SPLIT

• Syntax: SPLIT(text, separator)

• Description: The SPLIT function returns an array of substrings by dividing the input ‘text’ at each occurrence of the specified ‘separator’. This is particularly useful for parsing delimited strings into individual components.

• Example: SPLIT(“a|b|c”, “|”) yields [“a”, “b”, “c”].

Use Cases:

• Data Parsing: Extracting individual data elements from concatenated strings, such as CSV, JSON, and XML formats.

• Field Mapping: Assigning specific segments of a string to corresponding fields in target systems during data integration.

• Data Validation: Ensuring that input strings conform to expected formats by checking the number and content of resulting substrings.

Summary #

The SPLIT function is a newly introduced feature in the SKYVVA Integration App’s formula editor. It enables users to divide a text string into an array of substrings based on a specified separator. The function is defined as SPLIT(text, separator) and is categorized under the ‘Text’ group. For instance, SPLIT(“a|b|c”, “|”) returns [“a”, “b”, “c”]. This enhancement facilitates more efficient text manipulation within integration mappings.