Split at commas and put in each field

530 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I hope someone can solve this problem.

  • Split text content by commas (or other symbols)
  • Put each split text into multiple fields

How do I enter the function to make this possible?

2 Replies 2

Hey @sayaka_koda!
Welcome to the forums!

I’m a bit confused, and I would love more context into what you’re trying to achieve.
Could you possibly provide an example of what you’re trying to accomplish?

Any details you could provide would be greatly appreciated.

That will give us a better sense of how to get you there.

Thank you for the reply.

For example
first, convert the contents of “multi select” into text.
Then I want to split that text by comma and put it in each field.

What function can this be achieved using?

Thank you for your help.

화면 캡처 2022-08-19 113809

화면 캡처 2022-08-19 114440