{"id":138862,"date":"2022-11-21T17:06:05","date_gmt":"2022-11-21T08:06:05","guid":{"rendered":"https:\/\/support.questetra.com\/?p=138862"},"modified":"2022-11-24T18:11:06","modified_gmt":"2022-11-24T09:11:06","slug":"string-list-check-existence-of-search-string","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/string-list-check-existence-of-search-string\/","title":{"rendered":"String List, Check for Existence of Search String"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">String List, Check for Existence of Search String<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Checks for the existence of string elements in the list that match the search string.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C1:Set multiline type list Data.<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C2:Set CSV type list data.<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C3:Set search strings.<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-toggle-off fa-lg\"><\/i><\/span> C4:Case-sensitive search of alphabetic characters<\/li>\n<li> C5:Select STRING type item for search result(&#8216;true&#8217; &#8216;false&#8217;).<\/li>\n<li> C6:Select NUMERIC type item for number of search result.<\/li>\n<li> C7:Select STRING type item for element indexes of search result.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\nmain();\n\nfunction main(){\n\n    const multilineList = configs.get(&#39;conf_multilineList&#39;);\n    const csvList = configs.get(&#39;conf_csvList&#39;);\n    const keyWord = configs.get(&#39;conf_keyWord&#39;);\n    const caseSensitive = configs.get(&#39;conf_caseSensitive&#39;);\n    const conf_searchResultBoolean = configs.get(&#39;conf_searchResultBoolean&#39;);\n    const conf_searchResultNum = configs.get(&#39;conf_searchResultNum&#39;);\n    const conf_searchResultElementIndexes = configs.get(&#39;conf_searchResultElementIndexes&#39;);\n\n    if(multilineList === &#39;&#39; && csvList === &#39;&#39;){\n        throw &#39;Either Multiline List or CSV List is required.&#39;;\n    }\n\n    \/\/Search Type\n    let  searchType = caseSensitive +&#39;%&#39;;\n\n    \/\/\u691c\u7d22\u7d50\u679c\u306e\u4ef6\u6570\u3001\u884c\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u3044\u305a\u308c\u304b\u304c\u6c42\u3081\u3089\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u5168\u4ef6\u691c\u7d22\n    if(conf_searchResultNum !== &#39;&#39; || conf_searchResultElementIndexes !== &#39;&#39;){\n        searchType += &#39;true&#39;;\n    }else{\n        searchType += &#39;false&#39;;\n    }\n\n    let searchResult;\n    if(multilineList !== &#39;&#39;){\n        engine.log(&#39;Multiline List &lt;- key word: &#39; + keyWord);\n        searchResult = search(multilineList, keyWord, &#39;\\n&#39;, searchType);\n    }else{\n        engine.log(&#39;CSV List &lt;- key word: &#39; + keyWord);\n        searchResult = search(csvList, keyWord, &#39;,&#39;, searchType);\n    }\n\n    engine.log(&#39;Search Result: &#39; + JSON.stringify(searchResult));\n\n    if(conf_searchResultBoolean !== &#39;&#39;){\n        engine.setDataByNumber(conf_searchResultBoolean, searchResult.num &gt; 0 ? &#39;true&#39; : &#39;false&#39;);\n    }\n\n    if(conf_searchResultNum !== &#39;&#39;){\n        engine.setDataByNumber(conf_searchResultNum, new java.math.BigDecimal(searchResult.num));\n    }\n\n    if(conf_searchResultElementIndexes !== &#39;&#39;){\n        engine.setDataByNumber(conf_searchResultElementIndexes, searchResult.elementIndexes);\n    }\n\n}\n\n\/*\n@param list {string} String List\n@param keyWord {string} Search String\n@param delimiter {string}\n@param searchType {string} Case Sensitive (true or false)%All Search(true or false)\n@return result {JSON Object {&quot;num&quot;,&quot;elementIndexes&quot;}}\n*\/\nfunction search(list, keyWord, delimiter, searchType){\n\n    const searchTypeArr = searchType.split(&#39;%&#39;);\n    const sensitiveFlag = searchTypeArr[0] === &#39;true&#39; ? true : false ;\n    const searchAllFlag = searchTypeArr[1] === &#39;true&#39; ? true : false ;\n\n    const result = {};\n    let num = 0;\n    let elementIndexes = &#39;&#39;;\n\n    const array = list.split(delimiter);\n    for( let i = 0 ; i &lt; array.length ; i++ ){\n\n        \/\/\u8981\u7d20\u3068\u691c\u7d22\u6587\u5b57\u5217\u306e\u6bd4\u8f03\u3067\u5927\u6587\u5b57\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3059\u308b\u5834\u5408\n        if((sensitiveFlag && array[i] === keyWord) ||\n           \/\/\u8981\u7d20\u3068\u691c\u7d22\u6587\u5b57\u5217\u306e\u6bd4\u8f03\u3067\u5927\u6587\u5b57\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3057\u306a\u3044\u5834\u5408\n           (! sensitiveFlag && array[i].toUpperCase() === keyWord.toUpperCase())\n        ){\n            num += 1;\n            elementIndexes += String(i) + &#39;,&#39;;\n        }\n\n        \/\/searchAllFlag === false \u306e\u5834\u5408\u3001\u691c\u7d22\u6587\u5b57\u5217\u3068\u4e00\u81f4\u3059\u308b\u8981\u7d20\u304c\u898b\u3064\u304b\u3063\u305f\u6642\u70b9\u3067\u691c\u7d22\u3092\u7d42\u4e86\n        if(num &gt; 0 && ! searchAllFlag){\n            result.num = num;\n            result.elementIndexes = elementIndexes.slice(0,-1);\n            return result;\n        }\n\n    }\n\n    result.num = num;\n    result.elementIndexes = elementIndexes.slice(0,-1);\n\n    return result;\n}\n\n\/*\n- \u30ea\u30b9\u30c8\u30c7\u30fc\u30bf\u306f\u8981\u7d20\u3068\u8981\u7d20\u3092\u6539\u884c\u307e\u305f\u306f\u30b3\u30f3\u30de\u3067\u533a\u5207\u3089\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u60f3\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059\u3002\n- \u30ea\u30b9\u30c8\u30c7\u30fc\u30bf\u306b\u3064\u3044\u3066\u3001\u8907\u6570\u884c\u3001CSV\u306e\u4e21\u65b9\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u8907\u6570\u884c\u5f62\u5f0f\u306e\u3082\u306e\u304c\u691c\u7d22\u5bfe\u8c61\u306b\u306a\u308a\u307e\u3059\u3002\n- \u5148\u982d\u8981\u7d20\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u30bc\u30ed\u3067\u3059\u3002\u691c\u7d22\u7d50\u679c\u306e\u4ef6\u6570\u304c2\u4ee5\u4e0a\u306e\u5834\u5408\u3001\u8981\u7d20\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u5165\u529b\u3055\u308c\u307e\u3059\u3002\n- C6, C7 \u306e\u8a2d\u5b9a\u304c\u7701\u7565\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u691c\u7d22\u306f\u691c\u7d22\u6587\u5b57\u5217\u3068\u4e00\u81f4\u3059\u308b\u8981\u7d20\u304c\u898b\u3064\u304b\u3063\u305f\u6642\u70b9\u3067\u7d42\u4e86\u3055\u308c\u307e\u3059\u3002\n    - \u691c\u7d22\u6587\u5b57\u5217\u3068\u4e00\u81f4\u3059\u308b\u8981\u7d20\u306e &quot;\u5b58\u5728\u306e\u307f&quot; \u3092\u78ba\u8a8d\u3057\u305f\u3044\u5834\u5408\u3001C6,C7 \u8a2d\u5b9a\u306e\u7701\u7565\u304c\u63a8\u5968\u3055\u308c\u307e\u3059\u3002\n- The list data is expected to be separated from elements by line breaks or commas.\n- If both multi-line and CSV are entered for the list data, the multi-line type is the target of the search.\n- The index of the first element is zero. If the number of search results is 2 or more, the element indexes are entered comma-separated.\n- If the C6 and C7 settings are skipped, the search terminates when an element matching the search string is found.\n    - If you want to check &quot;existence only&quot; of elements matching the search string, omitting C6 and C7 settings is recommended.\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAA5BJREFUWEfF\nl1tIFFEYx3\/jLSu7aBERdgFFKzbJghJ82C5CSZYQQSX1sBXuughZG2gP9ZwgJSG5RuZDYfsUdJEu\n5JbgkhUkbJkVPmRZZLe1crXyMjGzTbtuuztno9jzNjPn+5\/\/+c7\/+\/5nJGI8JOH1G5iCzFYk1iKT\ni8QiIPVXvAeZF0h0InMbiYuYGRLB1ifQxFx+UAlYgGQRUOAbYCeJaky8jRQTmYAdCxI1wFTBhYOn\neZE5hAV7uPjwBBo4BZT95cLBYfWYsYbCCk3ATjMSO\/\/R4j4YmQtYKAnG\/JPAv925biYmEvCdeb3I\nzjct2ERyfDI3+27ydeSrSIiWibJATfgJ+NTeIyK4kswS6vLrSIxLpPJeJaeeKHIRHl6SyNSqw0+g\ngRNAhQhMo7ERU7YJCYnW160UtBSIhAXOqcXMAeWFj4DSZOCjSJ1nzcji8obLZM\/MVkM93z2Uu8pp\n7mmOhoTSJ2YpzcpHwM4uJM6JIBxefpijK4+q5+8Tt4yjx0GJ8w+BR4aT2Y2F81oGGoE9IgSubrzK\nunnrGJPHSElMUUN6B3vZcWsHHe86RCC0OWcxs1fLwEMkcvWiC+cX0rSmieefnzPwfYCihUWqDkbG\nRzjuPk7V\/So9CP93mU4srNAy8CnAWMKCKMrft3gftY9qcX9yq5WQOsnnR50fOjFeMUZTkh7MpGkE\nZD3q0xKn0ba5jbTkNDXdXZ4u9Tl3ti9xgyOD0ZekGUmYgHWplerV1TjfOCm+UawuWpNXw37DfhLi\nEtTnlpctFF0v0tuL\/3sAAd0jcKx3sD1je0Tw\/uF+THdMXHt1TYREwBHYiSjCvDl5OAocjI2P4ep3\nTQA3pBp+H8O4PM7p7tOUtQuYaJAII5bhsVXHqFhWwZmnZ9SmEzi0o9FK8tnAM7bc2KJWis6YUIYR\nG5Gr2EXG9IyQ6dXEqYnRO+ql6l4VdV11UTWisK1YM57ugW7yL+WHBFUydDDnoGpOgmIMasVKVAgz\nUjrekRVHMM4z0v62HdtdGw\/eP5hAIn1qOqVLSrHl2JiSoOwDtRecfHwS+xM7fd6+UKSDzEiZEmTH\n7m1uDGkGhkaHUMQVJ8WpCzhfO3+7n0JO8Yak+CSGR4dVX1BGvBTP5ITJfPnxBWu7NdiowtixEhnF\nhURPYWG\/y4S5kGgRMb2SaSRiein9P5mI8lruz0QMf0w0EjH9NQuUcsx+Tv+63sQCfwL9gFkwfk0h\nYgAAAABJRU5ErkJggg==\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1QbSjcp0SislNPb86qW6p26bE8AeDyaXU\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">string-list-check-existence-of-search-string-20221116.xml<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2022-11-16 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/string-list-check-existence-of-search-string\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/support.questetra.com\/addons\/string-list-check-existence-of-search-string\/<\/a><br><svg class=\"svg-inline--fa fa-info-circle\" aria-hidden=\"true\" focusable=\"false\" data-prefix=\"fal\" data-icon=\"info-circle\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" data-fa-i2svg=\"\"><path fill=\"currentColor\" d=\"M256 0C114.6 0 0 114.6 0 256s114.6 256 256 256s256-114.6 256-256S397.4 0 256 0zM256 480c-123.5 0-224-100.5-224-224s100.5-224 224-224s224 100.5 224 224S379.5 480 256 480zM256 184c13.25 0 24-10.74 24-24c0-13.25-10.75-24-24-24S232 146.7 232 160C232 173.3 242.7 184 256 184zM304 352h-32V240C272 231.2 264.8 224 256 224H224C215.2 224 208 231.2 208 240S215.2 256 224 256h16v96h-32C199.2 352 192 359.2 192 368C192 376.8 199.2 384 208 384h96c8.836 0 16-7.164 16-16C320 359.2 312.8 352 304 352z\"><\/path><\/svg><\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The list data is expected to be separated from elements by line breaks or commas.<\/li>\n\n\n\n<li>If both multi-line and CSV are entered for the list data, the multi-line type is the target of the search.<\/li>\n\n\n\n<li>The index of the first element is zero. If the number of search results is 2 or more, the element indexes are entered comma-separated.<\/li>\n\n\n\n<li>If the C6 and C7 settings are skipped, the search terminates when an element matching the search string is found.\n<ul class=\"wp-block-list\">\n<li>If you want to check &#8220;existence only&#8221; of elements matching the search string, omitting C6 and C7 settings is recommended.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default q-box\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-existence-of-search-string-cap1-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-attachment-id=\"138871\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/climber-webinvoice-file-upload\/attachment\/string-list-check-for-existence-of-search-string-cap1-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-existence-of-search-string-cap1-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"string-list-check-for-existence-of-search-string-cap1-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-existence-of-search-string-cap1-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-existence-of-search-string-cap1-en-1024x576.png?resize=1024%2C576&#038;ssl=1\" alt=\"\" class=\"wp-image-138871\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-existence-of-search-string-cap1-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-existence-of-search-string-cap1-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-existence-of-search-string-cap1-en.png?resize=768%2C432&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-existence-of-search-string-cap1-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default q-box\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-cap2-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"353\" height=\"630\" data-attachment-id=\"138867\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/climber-webinvoice-file-upload\/attachment\/string-list-check-for-exisence-of-search-string-cap2-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-cap2-en.png?fit=554%2C988&amp;ssl=1\" data-orig-size=\"554,988\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"string-list-check-for-exisence-of-search-string-cap2-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-cap2-en.png?fit=353%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-cap2-en-353x630.png?resize=353%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-138867\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-cap2-en.png?resize=353%2C630&amp;ssl=1 353w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-cap2-en.png?resize=177%2C315&amp;ssl=1 177w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-cap2-en.png?w=554&amp;ssl=1 554w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"wreDw1JQCX\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/string-replace-all\/\">String, Replace All<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;String, Replace All&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/string-replace-all\/embed\/#?secret=9YTWGgYpah#?secret=wreDw1JQCX\" data-secret=\"wreDw1JQCX\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"jDrJv6r24m\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/string-batch-replace-to-uppercase-2022\/\">String, Batch Replace to UpperCase<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;String, Batch Replace to UpperCase&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/string-batch-replace-to-uppercase-2022\/embed\/#?secret=tgph9KWWLk#?secret=jDrJv6r24m\" data-secret=\"jDrJv6r24m\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"OQ3HkYGiKC\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/string-batch-replace-to-lowercase-2022\/\">String, Batch Replace to LowerCase<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;String, Batch Replace to LowerCase&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/string-batch-replace-to-lowercase-2022\/embed\/#?secret=PZ2AzvOVZV#?secret=OQ3HkYGiKC\" data-secret=\"OQ3HkYGiKC\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Checks for the existence of string elements in the list that match the search string.<\/p>\n","protected":false},"author":7,"featured_media":138863,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[389],"class_list":["post-138862","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/string-list-check-for-exisence-of-search-string-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hajime Yahagi","author_link":"https:\/\/support.questetra.com\/en\/author\/hyahagi\/"},"uagb_comment_info":1,"uagb_excerpt":"Checks for the existence of string elements in the list that match the search string.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-A7I","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":81701,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-concat-all-strings\/","url_meta":{"origin":138862,"position":0},"title":"Questetra BPMS: Process, Concat All Strings","author":"IMAMURA, Genichi","date":"2019-11-06","format":false,"excerpt":"Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each data. It is used for checking the existence of keywords.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79731,"url":"https:\/\/support.questetra.com\/en\/data-items\/select-type\/","url_meta":{"origin":138862,"position":1},"title":"Select-Type","author":"Peter Glover","date":"2019-09-30","format":false,"excerpt":"Displays a list of options that can be selected by the person in charge of processing, and stores the selection results.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67497,"url":"https:\/\/support.questetra.com\/en\/addons\/nhk-programsearch\/","url_meta":{"origin":138862,"position":2},"title":"NHK Program Search","author":"Hirotaka NISHI","date":"2017-04-13","format":false,"excerpt":"Download Nhk-programSearch.xmlSince Rhino (deprecated) is specified as the script engine, a setting error will occur even if you install this in a workflow AppTo use this Add-on, you need to change the script engine and modify the script accordinglyPlease refer to Notice Concerning Deprecation of Rhino for the method for\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/04\/nhk-program-search-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/04\/nhk-program-search-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/04\/nhk-program-search-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/04\/nhk-program-search-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/04\/nhk-program-search-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":83123,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-out-by-text\/","url_meta":{"origin":138862,"position":3},"title":"TSV String, Filter Out by Text","author":"IMAMURA, Genichi","date":"2019-12-26","format":false,"excerpt":"Filters out TSV lines by any search text (Exclude Filter). Only lines that DO NOT contain the search text in the specified column are output. If OR search with multiple texts, specify them as a comma-separated list such as \"USA,U.S.,United States\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Filter Out by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-Out-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-Out-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-Out-by-Text-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-Out-by-Text-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-Out-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82245,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/","url_meta":{"origin":138862,"position":4},"title":"TSV String, Filter by Text","author":"IMAMURA, Genichi","date":"2019-11-25","format":false,"excerpt":"Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as \"USA,U.S.,United States\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Filter by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69321,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/receive-task-form-1170\/","url_meta":{"origin":138862,"position":5},"title":"How to Utilize a Receive Task (Form) &#8211; Email Address Verification through a Webform Application","author":"HatanakaAkihiro","date":"2018-05-31","format":false,"excerpt":"Hi there! Today, I would like to talk about how to utilize the Receive Task, a new feature added to version 11.7. https:\/\/support.questetra.com\/versions\/version-1170\/ Questetra already has a function for receiving applications from people outside of the system, the Message Start Event (Form). For the details of this feature, please see\u2026","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/05\/receive-task-form-1200-675.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/05\/receive-task-form-1200-675.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/05\/receive-task-form-1200-675.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/05\/receive-task-form-1200-675.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/05\/receive-task-form-1200-675.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/138862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=138862"}],"version-history":[{"count":9,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/138862\/revisions"}],"predecessor-version":[{"id":138888,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/138862\/revisions\/138888"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/138863"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=138862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=138862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=138862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}