Disabling Unnecessary Commas in Clay Support Columns

·

Hey best support team in the world....CLAY SUPPORT! I'm seeing unnecessary commas in a few columns, is there a way to disable?

6 comments

· Sorted by Oldest

Channeled
APP
·
·
To address the issue of unnecessary commas in columns, you can try the following steps: 1. Remove commas from your data cells, replacing them with another separator like semicolons. 2. Ensure your CSV is UTF-8 encoded with comma-separated values for best results. 3. Create a dedicated "CSV Export View" in Clay before exporting: • Duplicate your current view • Hide or delete unnecessary columns • Focus on including only the raw values you need If you're still experiencing issues after trying these steps, you can request human assistance by clicking on "Talk to a person" for further support.
Sources: Issues with Clay Spreadsheet CSV Downloads: Help Needed | Clay Issue with Commas Adding in G Sheet on Row Update | Clay Andi D. | Clay CSV Upload Issue: Keeping Values in Same Cells in Clay | Clay Andi D. | Clay
Joe H.
·
·
Not really....I'm not ready to export. Will the commas be there when I export?
Joe H.
·
·
https://app.clay.com/workspaces/457918/workbooks/wb_YsSXoFjWferQ/tables/t_hXVRPtakQmJ4/views/gv_4fj9rVPdYfC9
Joe H.
·
·
"Beta SIC" is column of interest
Bo (.
·
·
Hey Joe, The easiest way to fix the extra commas is to convert the column into a text column. Here’s how: 1. Create a new column and set it as a Text type 2. Click the column header > Edit Column 3. Use a forward slash (/) to reference the original value (e.g. from Claygent) This will show the value without adding commas. Let me know if you want help setting it up!
Channeled
APP
·
·

Channeled
APP
·
·
To address the issue of unnecessary commas in columns, you can try the following steps: 1. Remove commas from your data cells, replacing them with another separator like semicolons. 2. Ensure your CSV is UTF-8 encoded with comma-separated values for best results. 3. Create a dedicated "CSV Export View" in Clay before exporting: • Duplicate your current view • Hide or delete unnecessary columns • Focus on including only the raw values you need If you're still experiencing issues after trying these steps, you can request human assistance by clicking on "Talk to a person" for further support.
Sources: Issues with Clay Spreadsheet CSV Downloads: Help Needed | Clay Issue with Commas Adding in G Sheet on Row Update | Clay Andi D. | Clay CSV Upload Issue: Keeping Values in Same Cells in Clay | Clay Andi D. | Clay
Joe H.
·
·
Not really....I'm not ready to export. Will the commas be there when I export?
Joe H.
·
·
https://app.clay.com/workspaces/457918/workbooks/wb_YsSXoFjWferQ/tables/t_hXVRPtakQmJ4/views/gv_4fj9rVPdYfC9
Joe H.
·
·
"Beta SIC" is column of interest
Bo (.
·
·
Hey Joe, The easiest way to fix the extra commas is to convert the column into a text column. Here’s how: 1. Create a new column and set it as a Text type 2. Click the column header > Edit Column 3. Use a forward slash (/) to reference the original value (e.g. from Claygent) This will show the value without adding commas. Let me know if you want help setting it up!
Channeled
APP
·
·