{"id":8426,"date":"2020-09-16T12:34:32","date_gmt":"2020-09-16T19:34:32","guid":{"rendered":"https:\/\/minisoft.com\/support\/?p=8426"},"modified":"2020-09-16T12:34:33","modified_gmt":"2020-09-16T19:34:33","slug":"csv-files-with-commas-in-data","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/csv-files-with-commas-in-data\/","title":{"rendered":"CSV files with commas in data"},"content":{"rendered":"\n

Sometimes CSV data includes commas or other characters within the data that results in processing errors. For example, an address field with a comma can throw off the fields even if the field has quotes around it. The following text is interpreted as six fields instead of five:<\/p>\n\n\n\n

Minisoft,\"1024 First Street, Suite 311\",Snohomish,WA,98290<\/code><\/p>\n\n\n\n

One way to handle this is to add a Replace preprocessor to the project to change all occurrences of “, ” (comma-space) to some other string. This example changes “, ” to ” – ” (space-hyphen-space). The text processed by the CSV parser then handles the data as expected:<\/p>\n\n\n\n

Minisoft,\"1024 First Street - Suite 311\",Snohomish,WA,98290<\/code><\/p>\n\n\n\n

Complete the following steps to add a Replace preprocessor to your eFORMz project file:<\/p>\n\n\n\n

  1. Start the eFORMz Composer and open the eFORMz project file.<\/li>
  2. Right click the project name in the Project window > Add Preprocessor > Replace occurrences of a string.
    \"\"
    <\/li>
  3. In the Search for field, type the characters comma-space (, ). In the Replace with field, type the characters space-comma-space ( – ).\"\"
    <\/li>
  4. Click OK and save the project. The updated project is picked up the next time that the project is called.<\/li><\/ol>\n\n\n\n

    Read more about importing CSV records<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Sometimes CSV data includes commas or other characters within the data that results in processing errors. For example, an address field with a comma can throw off the fields even if the field has quotes around it. The following text is interpreted as six fields instead of five: Minisoft,”1024 First Street, Suite 311″,Snohomish,WA,98290 One way […]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8426"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=8426"}],"version-history":[{"count":5,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8426\/revisions"}],"predecessor-version":[{"id":8434,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8426\/revisions\/8434"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=8426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=8426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=8426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}