Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Split Table Type Value by comma in single row

Hi,   Can anyone help me with this, please? I have a column MCRType of type Table. The 5th row contains these values. My requirement is I want those values to be comma-separated, but the sp...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks, HotChilli  for the reply.

     

    So I created a custom column and wrote the code below and the new column got converted to list and I was able to extract values.

     

     

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

If i understand correctly you want to convert the table to a text field separated by commas.

So, add a custom column to create a list.  This will be [MCRType][Value] . Then you can expand the list from the column header to extract values (choose comma as delimiter).

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks, HotChilli  for the reply.

     

    So I created a custom column and wrote the code below and the new column got converted to list and I was able to extract values.