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

[Z_Jonah]

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.

[paul_n]

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: ",", " " }}

[Z_Jonah]

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 · Accepted solution]

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

{{ order.customer.displayName | replace: ",", " " }}

[Z_Jonah]

Solved. Thanks a lot!