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?
Best answer by nicksimard
View original
+11
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’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 :)
Thank you for this, its exactly what I needed and it worked!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
