In this article lets discuss how to convert comma-separated values into semi-colon separated values in an automation
Let's consider we have a string with comma-separated values for eg: abc,def,ghi which needs to be converted into abc;def;ghi .In order to achieve this please follow the steps below
- Use explode() function to convert a text with comma-separated items into a list. Formula usage : {explode: {$.testValueComma}, ','}
- Use implode() function to convert the above list of items into one text, separated with a semicolon. Formula usage : {implode: {$.array}, ';'}
The final formula that should be the combination of explode and implode function looks like as below
{implode: {explode: {$.testValueComma}, ','}, ';'}
Please check out the attached JSON file containing an example automation workspace demonstrating the above use case
Follow the steps provided in this article Upload Automation Workspace to import the automation from shared JSON file
Related Resources:
