In Sage X3, you may come across various scenarios where you need to get a sub-string from an existing string. You can derive sub-string from both the ends i.e. from the left or the right or starting from any particular position of a given string.<\/p>\n
This blog will help you to extract the leftmost sub-string from a given string i.e. We can derive a sub-string with any number of characters from the left of the given string.<\/p>\n
Sage X3 provides the below special function to achieve the same:<\/p>\n
left$ (string,nb_char)<\/em><\/strong><\/p>\n This function is used to extract a sub-string starting from the left-hand side first letter of an original string to the letter ending with specified number of characters.<\/p>\n Where,<\/p>\n string -> Original string with an alphanumeric expression<\/em> Let\u2019s consider the following example for extraction of sub-string with 4 letters from left to better understand the working of left$<\/em><\/strong> function.<\/p>\n Kindly refer to the below snippet of code for better understanding.<\/p>\n Local Char YSTRING(50) The above snippet of code will give the output as \u201cJACK<\/strong>\u201d.<\/p>\n Hope this blog helps!<\/p>\n About Us<\/strong><\/span> 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":" In Sage X3, you may come across various scenarios where you need to get a sub-string from an existing string. You can derive sub-string from both the ends i.e. from the left or the right or starting from any particular position of a given string. This blog will help you to extract the leftmost sub-string\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[571,777,778,1870,1942,1943],"class_list":["post-10188","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-derive-sub-string-in-sage-x3","tag-extract-left-sub-string","tag-extract-left-substring-in-sage-x3","tag-sage-x3-feature","tag-sage-x3-technical-assistance","tag-sage-x3-technical-blog"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/10188","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=10188"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/10188\/revisions"}],"predecessor-version":[{"id":17728,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/10188\/revisions\/17728"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=10188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=10188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=10188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nnb_char -> Numerical integer expression for the length of a string to be extracted.<\/em><\/p>\n
\n<\/em>YSTRING = “JACKFRUIT”
\n<\/em>Infbox left$(YSTRING, 4)<\/em><\/p>\n
\nGreytrix<\/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