Split Comma Separated Values or Delimited Data into Separate Rows

AppSheet AppSheet Q&A
,
1

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
2

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

3

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.

4

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

5

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

6

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

7

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?

8

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

SPLIT() - AppSheet Help

1 Like
9

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

1 Like