{"id":7188,"date":"2018-12-18T22:36:44","date_gmt":"2018-12-18T22:36:44","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=7188"},"modified":"2018-12-18T22:36:48","modified_gmt":"2018-12-18T22:36:48","slug":"isolate-one-line-of-a-multi-line-variable","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/isolate-one-line-of-a-multi-line-variable\/","title":{"rendered":"Isolate one line of a multi-line variable"},"content":{"rendered":"\n<p>Capturing an area of text from a file that includes multiple lines creates an arrayed variable with each line being an element in the array. For example, the following lines are captured in the variable, CustName:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"774\" height=\"102\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley.jpg\" alt=\"\" class=\"wp-image-7189\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley.jpg 774w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley-300x40.jpg 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley-768x101.jpg 768w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley-150x20.jpg 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley-250x33.jpg 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley-550x72.jpg 550w\" sizes=\"(max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<p>The email address might not be on the same line for every record, so capturing the email address and setting an EmailAddress variable takes a couplesteps.<\/p>\n\n\n\n<ol><li>Create a variable EmailAddress to hold the value.<\/li><li>Create a Set Variable procedure. Enter a name for the procedure and use the variable that contains multiple lines. This example uses CustName: &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img decoding=\"async\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley2.jpg\" alt=\"\"><\/li><li>In the Set Variable window, select the EmailAddress variable. The EmailAddress variable has a value of the last line of CustName.<\/li><li>To capture the email address, right click the procedure &gt; Add AND Condition &gt; Contains. Make sure the CustName variable is selected. In the value field, type the at sign (@). We know that every email address includes an at sign, and addresses in our data do not contain at signs.<\/li><li>The condition requires that the value must include the at sign, which populates the email address to the variable EmailAddress:<\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" loading=\"lazy\" width=\"284\" height=\"115\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley4.jpg\" alt=\"\" class=\"wp-image-7193\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley4.jpg 284w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley4-150x61.jpg 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2018\/12\/HillValley4-250x101.jpg 250w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Capturing an area of text from a file that includes multiple lines creates an arrayed variable with each line being an element in the array. For example, the following lines are captured in the variable, CustName: The email address might not be on the same line for every record, so capturing the email address and [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/7188"}],"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=7188"}],"version-history":[{"count":3,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/7188\/revisions"}],"predecessor-version":[{"id":7195,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/7188\/revisions\/7195"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=7188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=7188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=7188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}