Using commas in a comma-separated Google Sheet

Solved

Using commas in a comma-separated Google Sheet

ContactsAsia
Visitor
3 0 0

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.

Accepted Solution (1)
paul_n
Shopify Staff
1368 153 321

This is an accepted solution.

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
Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.

View solution in original post

Replies 7 (7)

paul_n
Shopify Staff
1368 153 321

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

field 1, "My string, mystring()", field3
Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
ContactsAsia
Visitor
3 0 0

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

paul_n
Shopify Staff
1368 153 321

This is an accepted solution.

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
Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
ContactsAsia
Visitor
3 0 0

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!

paul_n
Shopify Staff
1368 153 321

You can find and replace using liquid. Something like

{{ variable | replace: ",","" }}
Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
specklefarms
Excursionist
37 1 11

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

 

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

 

paul_n
Shopify Staff
1368 153 321

You don't nest brackets in liquid

 

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

 

 
Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.