Split Comma Separated Values or Delimited Data into Separate Rows

[vila123]

Hello!

I ran into a problem with my appsheet where I allow comma separated values in a LongText field but for every value separated by a comma I want a new row. How do I go about doing so if the list can potentially be 300+ different values separated by commas. 

For example: this table below is how I currently have it set up (in a simpler version). Mine realistically has 30 other columns in addition to this 

Name	Days Working
Jane	Monday, Tuesday
Doe	Tuesday, Thursday
Hello	Friday, Saturday

I want my output to look like so below:

Name	Day
Jane	Monday
Jane	Tuesday
Doe	Tuesday
Doe	Thursday
Hello	Friday
Hello	Saturday

[Suvrutt_Gurjar]

If you search in the "Tips and Tricks" section, you will get multiple tips on adding rows.

You may find the below one from @Steve relevant to you.

FAQ: add row per value in EnumList - Google Cloud Community

[vila123]

Hi,
I reviewed that thread & it's only helpful for enum lists but I'm looking for how to add rows per comma separated value (ex: 1,2,3,4) into rows on their own & I'm looking to do this at scale where there could be potentially 20,000 values in one row.

[Suvrutt_Gurjar]

Well,  you could possibly convert comma separated values into a list.

[vila123]

would this work if we're trying to separate SKU IDs? There could be 200-10,000 in one LongText entry so I'm trying to find the simplest way to get each SKU ID appended to it's unique row 

[Suvrutt_Gurjar]

You could try with bots webhook. Even though I may mention that adding 10000 rows is a bit unusual.

[vila123]

Do you think the split() function would be able to solve for this? Or do you recommend maybe manipulating data through SQL instead of appsheet?

[Suvrutt_Gurjar]

If you are referring to converting comma separated text values into a list, yes, you can do so with SPLIT()

SPLIT() - AppSheet Help

[Steve · Accepted solution]

---

@vila123 wrote:

Or do you recommend maybe manipulating data through SQL instead of appsheet?

---

Definitely outside of AppSheet. In fact, AppSheet may not be a good solution if you are regularly importing data on this scale.