How to Convert Comma-Separated Strings into an array

Hi,

I’m trying to reformat the values of six variables simultaneously.

Currently, the input data is formatted like this:

        "variables": [
            {
                "name": "Array of skills",
                "value": "67bf2ffc7cabfcc2fe46a070,67bf2fbd185e80560683666b,670e6bad3ced88ad68329944"
            },

For the API call, I need to transform them into the following format:

        "skills": [
          "67bf2ffc7cabfcc2fe46a070",
          "67bf2fbd185e80560683666b",
          "670e6bad3ced88ad68329944"
        ],

I’ve explored various methods but haven’t found a way to apply this transformation to all six variables.

Does anyone know how to achieve this?

Thanks!

@Maxkzn Using the ‘split’ function in make?

1 Like

@jeff_nguyen that should do it.

Here’s an example: