Hi, I’m trying to use Formatter to separate a line of text like (No, Yes, No, No, Yes) into separate fields, and I want each No/Yes to be in its own cell (row or column doesn’t matter but row preferred). When I say add row to sheets, it only gives me the option of putting the whole line of text “No, Yes, No, No, Yes” into 1 cell. How do I break them apart into their own cells?
Breaking up comma separated text into new Google Sheet Rows
Userlevel 7
+11
- Zapier Staff
- 2116 replies
-
19 May 2020
- Answer
Hi
One way to approach that would be to use the Formatter’s Split Text function. So you map the field that has those comma-separated items, split on that comma and output one of two things (depending what you want to do):
- If you want each comma-separated piece to be on its own row, use #1 in the screenshot below.
- If you want each comma-separated piece to be in the same row, but in its own column, use #2 in the screenshot below.
If you’re splitting into line items, you’ll have to use the Google Sheets action that suports line items:
Can you give that a try to see if you can get it working? Please let me know if you still need help with anything :)
Userlevel 1
Thank you for this, its exactly what I needed and it worked!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.