{"id":744,"date":"2014-09-25T17:56:41","date_gmt":"2014-09-25T17:56:41","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=744"},"modified":"2017-11-09T19:37:40","modified_gmt":"2017-11-09T19:37:40","slug":"substring","status":"publish","type":"post","link":"https:\/\/www.minisoft.com\/support\/substring\/","title":{"rendered":"Substring"},"content":{"rendered":"<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/_YyFT-9o0uQ?rel=0\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>The Substring Function extracts a string of characters from an incoming data file or a custom-built Variable:<\/p>\n<p>1. To insert a substring, right-click the Variable and select <em>Add Function &gt; Substring<\/em>.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring1.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-745\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring1.png\" alt=\"Substring1\" width=\"421\" height=\"280\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring1.png 421w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring1-300x199.png 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring1-150x99.png 150w\" sizes=\"(max-width: 421px) 100vw, 421px\" \/><\/a><\/p>\n<p>2. From the Substring dialog box enter the starting position of the string you would like to extract and set the number of character to be extracted. Specifying a negative value (-1) in the Starting Character Position field indicates to start from the end of the string. \u20180\u2019 is the starting position of the string.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-746\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring2.png\" alt=\"Substring2\" width=\"327\" height=\"228\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring2.png 327w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring2-300x209.png 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2014\/09\/Substring2-150x104.png 150w\" sizes=\"(max-width: 327px) 100vw, 327px\" \/><\/a><\/p>\n<p><em>TIP: Specifying a negative value (-1) in the Starting Character Position field indicates to start from the end of the string. \u20180\u2019 is the starting position of the string.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Substring Function extracts a string of characters from an incoming data file or a custom-built Variable: 1. To insert a substring, right-click the Variable and select Add Function &gt; Substring. 2. From the Substring dialog box enter the starting position of the string you would like to extract and set the number of character [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,10],"tags":[101],"_links":{"self":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/744"}],"collection":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=744"}],"version-history":[{"count":4,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/744\/revisions"}],"predecessor-version":[{"id":5400,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/744\/revisions\/5400"}],"wp:attachment":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}