Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

How to convert comma delimited string into semicolon delimited string in an automation

cancel
Showing results for 
Search instead for 
Did you mean: 
AfeefaTk
Support
Support

How to convert comma delimited string into semicolon delimited string in an automation

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:

 

Labels (2)
Attachments
Version history
Last update:
‎2021-10-11 07:45 AM
Updated by:
Contributors