{"id":16741,"date":"2018-12-11T04:54:23","date_gmt":"2018-12-11T04:54:23","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=16741"},"modified":"2018-12-11T04:54:23","modified_gmt":"2018-12-11T04:54:23","slug":"reading-values-from-a-csv-file-using-a-separator","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2018\/12\/11\/reading-values-from-a-csv-file-using-a-separator\/","title":{"rendered":"Reading Values from a csv file using a Separator"},"content":{"rendered":"

To read values from a csv file using a separator and writing the required values in a new file, follow the below steps-<\/strong><\/p>\n

    \n
  1. Open the directory where the csv file is located<\/li>\n
  2. Specify the separator(e.g. “;”) and new line(e.g. “chr$(10)”)<\/li>\n
  3. Read the values from a file<\/li>\n
  4. Store the required values in variables<\/li>\n
  5. Close the directory, path.<\/li>\n<\/ol>\n

    For example consider the below csv file that is to be read:<\/u><\/strong><\/p>\n

    \"Csv<\/a><\/p>\n

    Refer the below code snippet\/example-<\/u><\/strong><\/p>\n

    \"csv<\/a><\/p>\n

    Hope this blog helps you!<\/p>\n

    About Us<\/strong><\/span>
    \n    Greytrix<\/a> \u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n

    Greytrix<\/a>\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0Salesforce.com<\/a> and\u00a0Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3)<\/a>. Currently we are Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0Sage X3 customization and development services<\/a>,\u00a0integrated applications such as POS<\/a> | WMS<\/a> | Payment Gateway<\/a> | Shipping System<\/a> | Business Intelligence<\/a> | eCommerce<\/a> and have developed add-ons such as Catch \u2013 Weight <\/a>\u00a0and Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n

    Greytrix is a recognized Sage Rockstar ISV Partner<\/a> for GUMU™ Sage Enterprise Management \u2013 Sage CRM integration also listed on Sage Marketplace<\/a>; GUMU™ integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on Salesforce AppExchange<\/a>.<\/p>\n

    For more information on Sage X3 Integration and Services, please contact us at\u00a0x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To read values from a csv file using a separator and writing the required values in a new file, follow the below steps- Open the directory where the csv file is located Specify the separator(e.g. “;”) and new line(e.g. “chr$(10)”) Read the values from a file Store the required values in variables Close the directory,\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[2582,2583,1762,2584,1822,1941],"class_list":["post-16741","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-csv-file-using-a-separator","tag-reading-values-from-csv-file","tag-sage-enterprise-management","tag-sage-enterprise-management-technical","tag-sage-x3","tag-sage-x3-technical"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/16741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=16741"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/16741\/revisions"}],"predecessor-version":[{"id":16744,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/16741\/revisions\/16744"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=16741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=16741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=16741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}