Using commas in a comma-separated Google Sheet

Shopify Plus
1

I am trying to use Shopify Flow to automate some of my order processes by creating a new row in Google Sheets everytime an order comes in.

Some columns I use formulas which contain " , ’ ( ) and various other symbols. My question is how can I add a comma without making it a separator? I have tried “,” which sadly does not work.

2

Try putting quotes (") around them, for example:

field 1, "My string, mystring()", field3
3

Thank you Paul, that’s what I tried but unfortunately the quotes did not do anything

4

We’ll try to document this better. Part of the issue is that some characters affect things in Flow and some in Sheets. Anyway, I looked at past answers and think that actually backslash solves this. So try:

field 1, "My string\, mystring()", field3
5

Thank you Paul, that worked a treat! The only problem I got stumped on now is that the shipping addresses would sometimes contain commas, which I don’t think I will have a solution to since they are variables, but this might be something you guys need to take note of!

6

You can find and replace using liquid. Something like

{{ variable | replace: ",","" }}
7

How would this be implemented? I’m receiving a syntax error in Shopify Flow when I try this:

{{"{{product.title}}"|replace: ",",""}}
8

You don’t nest brackets in liquid

{{ product.title | replace: ",",""}}