Commas in shipping address are considered a separator by the Flow app

Solved

Commas in shipping address are considered a separator by the Flow app

Z_Jonah
Excursionist
17 0 4

I have a Flow that pulls orders' data to a Google Sheet.

When a customer uses a comma in their name or their street address, the Flow app considers it a separator and puts it in the next column on the sheet.

Example:

  • Address 1: 5 Patrick Road, Blackpool
  • Address 2: blank

Instead of putting Address 1 in one column and leaving the next column blank (because Address 2 is blank), the Flow app puts "5 Patrick Road" in the first column, and "Blackpool" in the column next to it; then leaves the third column blank.

Accepted Solution (1)
paul_n
Shopify Staff
1162 143 275

This is an accepted solution.

Don't replace any variables but put that replace filter part on those variables. something like:

{{ order.customer.displayName | 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.

View solution in original post

Replies 4 (4)

paul_n
Shopify Staff
1162 143 275

Technically Flow doesn't do that. Flow just renders the comma provided in the data. Sheets treats any comma as a separator. 

 

If the data potentially has a comma, you can find and replace it using liquid, like:

{{ order.note | 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.
Z_Jonah
Excursionist
17 0 4

Thanks Paul,

Where to put code exactly?

And the commas are generally in the customer's name and address. What should I put instead of "order.note"?

paul_n
Shopify Staff
1162 143 275

This is an accepted solution.

Don't replace any variables but put that replace filter part on those variables. something like:

{{ order.customer.displayName | 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.
Z_Jonah
Excursionist
17 0 4

Solved. Thanks a lot!