Variable string manipulation help needed

Hi,

I’m parsing json and everything else gets parsed and appended to csv like a charm but one array I cannot parse.

      {
          "recordNumber": "2019/40637V",
          "registrationDate": "2019-06-29",
          "typeOfRegistration": "TA",
          "entryCodes": [
            "TASE"
          ],
          "detailsUri": "http://avoindata.prh.fi/opendata/tr/v1/publicnotices/2019/40637V"
        },
        {
          "recordNumber": "2019/227830",
          "registrationDate": "2019-06-24",
          "typeOfRegistration": "M",
          "entryCodes": [
            "ANTIP",
            "KOROI",
            "OSLUKU",
            "OSMIT"
          ],

entryCodes are saved to the variable and the entire message are written to csv but I should manipulate the string inside the entryCodes variable to get those values as should. now it is messign the whole csv file.
This is how those are now:

I need to get those like this:

Hi @hemuli
You used deserialize json and based on that use Build Datatable Activity and add data row

Thanks
Ashwin S

Hi, and thanks for your reply. Yes that’s how I’m doing it

But I don’t know how to get rid of the [ “” ] characters in entryCodes which are messing the written csv.

Hi, I managed to do this with Replace activity

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.