{"id":141301,"date":"2023-01-23T14:18:15","date_gmt":"2023-01-23T05:18:15","guid":{"rendered":"https:\/\/support.questetra.com\/?p=141301"},"modified":"2023-01-23T17:18:01","modified_gmt":"2023-01-23T08:18:01","slug":"multiline-string-filter-by-keywords-2023","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-filter-by-keywords-2023\/","title":{"rendered":"Multiline String, Filter by Keywords"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-background\" style=\"background-color:#ffccff;margin-top:var(--wp--preset--spacing--30);margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><strong>Multiline String, Filter by Keywords<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-background has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#ffccff;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--30);padding-bottom:0;padding-left:var(--wp--preset--spacing--30)\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/multiline-string-filter-by-keywords-2023\/\">\u8907\u6570\u884c\u6587\u5b57\u5217, Keywords \u30d5\u30a3\u30eb\u30bf<\/a><\/p>\n\n\n\n<p class=\"has-background mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#fff0ff;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--60);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--40)\">Narrows multi-line text down to matching lines only. The match condition can be either &#8220;equals&#8221;, &#8220;contains&#8221;, &#8220;begins with&#8221;, or &#8220;ends with&#8221;. A case-insensitive filter can also be specified. It is also possible to separately store the excluded rows (filtered rows).<\/p>\n\n\n\n<figure class=\"wp-block-image alignright has-custom-border is-style-default\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADkElEQVRYR82XW0gUURjHf6NmrmWW\nlV0pxe1mdJUiootJ9djtqaJ9sCV3tQgFqbfqoYcuUvlQ7UIWXbA3IyiIILUo8MGsKPIhwYV0i7ba\n0tzUtIkz6+js7OzurCV2HmfO+f9\/853vfOcbiVEekml\/N6nI7EJiEzIrkMgCJg2s9yPjQeIFMnVI\n1OAgYEY7NsA1ptPLUcAJpJgRBboBF8mcppCP0dZEB3DhRKICGGfSWD+tC5lynLgirY8M4OYSUDxM\nY\/2yyzgoMdIyBnBRjcSef2QelJG5jZO9es1wAIMvz52Uy7a521iduZrstGxmpM4gNSk1RMv304ev\n20fzt2bqvfXUtNbQ+aszZiRCAYJ7flldZZtno2xJGUsnLyVBSqCjt4P2rna8AS8fAh8GxROlRHIm\n5DA1ZaoCZ0myEOgL8OD9A86+OkvDp4YhEJlibU4MAQSzvUVNuCPLjnAs7xh9v\/u447mjCL31vzW1\nKzuzdlK6pJS109bi+eHBVmvTQnSRjFU9HUMAbs4DparDlQ1XKFxQiKvZxcGnB00Z6yc17WrCmm5V\n1t98d1P7+gIOysSDIIAoMvBFe84FgH2hnc\/dn6l8U0nl60qjPTUEEzlzPO84O7J20NPfYwQg6sRk\nUayCAC72IRGC6F7v5sCiA0gDjEJIJJmn00NrZ6sC89z3nPTkdCVHLIkW5qfPZ874OUwcOxGRF2J8\n7\/1OydMSqluqQ2FlbDi5pUagCtivnbE7ZzcX110kY2zGsMKvLmr0NVJwr8AoeldxYFcj0ITECr1T\ncW4xJ\/JOkGnJjBtCRkaYH352OPQUqEoyL3CyUo3AV83FEmKWPzOfc2vOsXzK8sHtiEWjnhz7Y3u0\nvPHjIEMFkKOJpo1Jo2pjFeJ4JSUkRfX39\/g59fIUZ16dicUJDiRTAKrSyVUnObT4kJJ4RqOlo4Xy\nhnLueu7GNhczNAARt0CvtD1rOxVrKrBOsA6+6pf7edj2kKInRbR1tZkzB80WuDBMwkhKW2Zv4Xr+\ndaXsilHnrVMyPa6hS8KwYxhNrGBmATc23WDWuFnKtEftj9h8f3Nc\/kDIMQwrRCMOoCtEYaV4hAF0\npVi46S6jEQbQXUbCTXcdjyBAhOtYOOoakkgQf5WEERsS1c1EMyoq49bZWwfbMtEl1XprzZyCsOb0\nP2xK44iEmU8emBNnW64qj+qPiQoxqr9m2hiP2s9pHBs9nKl\/AKYYaTCS9AqCAAAAAElFTkSuQmCC\n\" alt=\"Auto Step icon\" class=\"has-border-color has-ast-global-color-6-border-color\" style=\"border-width:0.5em\"\/><\/figure>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Configs for this Auto Step<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">StrConfA1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">A1: Set Multiline Text<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">OptionConfB1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B1: Select OPERATOR for Matching Condition<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">StrConfB2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B2: Set KEYWORD for Matching Condition (Multi Rows: OR-Search)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">SelectConfC1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1: Select STRING that stores Narrowed Text (update)<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">SelectConfC2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2: Select STRING that stores Removed Lines (update)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">Script (click to open)<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strInput         = configs.get      ( &quot;StrConfA1&quot; );    \/\/\/ REQUIRED\n  if( strInput       === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A1: String} is empty \\n&quot; );\n  }\nconst strOperator      = configs.get      ( &quot;OptionConfB1&quot; ); \/\/\/ REQUIRED (SELECT_ITEM)\n  \/\/ &quot;equals&quot;,  &quot;conains&quot;,  &quot;stratswith&quot;,  &quot;endswith&quot;,\n  \/\/ &quot;equals2&quot;, &quot;conains2&quot;, &quot;startswith2&quot;, &quot;endswith2&quot; (2:ignore case)\nconst strKeywords      = configs.get      ( &quot;StrConfB2&quot; );    \/\/\/ REQUIRED\n  if( strKeywords    === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {B2: String} is empty \\n&quot; );\n  }\nconst strPocketOutput  = configs.getObject( &quot;SelectConfC1&quot; ); \/\/ NotRequired\nconst strPocketRemoved = configs.getObject( &quot;SelectConfC2&quot; ); \/\/ NotRequired\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nconst arrInput     = strInput.split( &#39;\\n&#39; );\nconst arrKeywords  = strKeywords.split( &#39;\\n&#39; );\n\nlet   arrOutput    = [];\nlet   arrRemoved   = [];\n\nif ( strOperator === &quot;equals&quot; ) {\n  loopInput:\n  for ( let i = 0; i &lt; arrInput.length; i++ ) {\n    for ( let j = 0; j &lt; arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === &quot;&quot; ){\n        engine.log( &quot; AutomatedTask RuntimeWorning: Empty in Keywords config&quot; );\n        continue;\n      }\n      if ( arrInput[i] === arrKeywords[j] ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === &quot;equals2&quot; ) {\n  loopInput:\n  for ( let i = 0; i &lt; arrInput.length; i++ ) {\n    for ( let j = 0; j &lt; arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === &quot;&quot; ){\n        engine.log( &quot; AutomatedTask RuntimeWorning: Empty in Keywords config&quot; );\n        continue;\n      }\n      if ( arrInput[i].toUpperCase() === arrKeywords[j].toUpperCase() ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === &quot;contains&quot; ) {\n  loopInput:\n  for ( let i = 0; i &lt; arrInput.length; i++ ) {\n    for ( let j = 0; j &lt; arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === &quot;&quot; ){\n        engine.log( &quot; AutomatedTask RuntimeWorning: Empty in Keywords config&quot; );\n        continue;\n      }\n      if ( arrInput[i].includes( arrKeywords[j] ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === &quot;contains2&quot; ) {\n  loopInput:\n  for ( let i = 0; i &lt; arrInput.length; i++ ) {\n    for ( let j = 0; j &lt; arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === &quot;&quot; ){\n        engine.log( &quot; AutomatedTask RuntimeWorning: Empty in Keywords config&quot; );\n        continue;\n      }\n      if ( arrInput[i].toUpperCase().includes( (arrKeywords[j].toUpperCase()) ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === &quot;startswith&quot; ) {\n  loopInput:\n  for ( let i = 0; i &lt; arrInput.length; i++ ) {\n    for ( let j = 0; j &lt; arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === &quot;&quot; ){\n        engine.log( &quot; AutomatedTask RuntimeWorning: Empty in Keywords config&quot; );\n        continue;\n      }\n      if ( arrInput[i].startsWith( arrKeywords[j] ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === &quot;startswith2&quot; ) {\n  loopInput:\n  for ( let i = 0; i &lt; arrInput.length; i++ ) {\n    for ( let j = 0; j &lt; arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === &quot;&quot; ){\n        engine.log( &quot; AutomatedTask RuntimeWorning: Empty in Keywords config&quot; );\n        continue;\n      }\n      if ( arrInput[i].toUpperCase().startsWith( (arrKeywords[j].toUpperCase()) ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === &quot;endswith&quot; ) {\n  loopInput:\n  for ( let i = 0; i &lt; arrInput.length; i++ ) {\n    for ( let j = 0; j &lt; arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === &quot;&quot; ){\n        engine.log( &quot; AutomatedTask RuntimeWorning: Empty in Keywords config&quot; );\n        continue;\n      }\n      if ( arrInput[i].endsWith( arrKeywords[j] ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === &quot;endswith2&quot; ) {\n  loopInput:\n  for ( let i = 0; i &lt; arrInput.length; i++ ) {\n    for ( let j = 0; j &lt; arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === &quot;&quot; ){\n        engine.log( &quot; AutomatedTask RuntimeWorning: Empty in Keywords config&quot; );\n        continue;\n      }\n      if ( arrInput[i].toUpperCase().endsWith( (arrKeywords[j].toUpperCase()) ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else {\n  throw new Error( &quot;\\n AutomatedTask RuntimeError:&quot; +\n                   &quot; Unexpected OPERATOR \\n&quot; );\n}\n\nlet strOutput  = arrOutput?.join( &#39;\\n&#39; ) ?? &quot;&quot;;\nlet strRemoved = arrRemoved?.join( &#39;\\n&#39; ) ?? &quot;&quot;;\n\/\/ https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Operators\/Optional_chaining\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif ( strPocketOutput !== null ) {\n  engine.setData ( strPocketOutput,  strOutput );\n}\nif ( strPocketRemoved !== null ) {\n  engine.setData ( strPocketRemoved, strRemoved );\n}\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\n\/*\nNotes:\n- When a process reaches this automated step, &quot;multi-line text&quot; is automatically processed.\n    - Each line of multiline text is compared to the Keyword, and only lines matching the condition are output.\n    - The match condition can be one of the following: &quot;equals&quot;, &quot;contains&quot;, &quot;starts with&quot;, or &quot;ends with&quot;.\n    - Note that it is possible to store not only filtered-down rows, but also filtered-out rows.\n        - In other words, &quot;does not equal&quot;, &quot;does not contain&quot;, &quot;does not start with&quot; and &quot;does not end with&quot;.\n- In case of OR search, set each Keyword separately in each line.\n    - OR search: &quot;equals one of the Keywords&quot;, &quot;contains one of&quot;, &quot;starts with one of&quot;, &quot;ends with one of&quot;\n    - For example, if you want to extract rows containing &quot;Tokyo&quot; or &quot;Kyoto&quot;\n    - Set &quot;Tokyo&quot; on the first row and &quot;Kyoto&quot; on the second row. (OR-Search)\n- For AND search, design a workflow diagram such as &quot;Multiple automated steps&quot; or &quot;Place in loop structure&quot;.\n    - For example, if you want to extract rows containing &quot;Kyoto&quot; and &quot;Spa&quot; design the process in two steps.\n        - First, extract rows containing &quot;Kyoto&quot;.\n        - Then, extract rows containing &quot;Spa&quot;.\n- You can automate the work process in various business processes (workflow).\n    - Confirm registration of product master\n    - Confirm registration of e-mail address list\n    - Extract only specific header information from mail headers\n    - Extract only specific city addresses from a customer address list\n    - Extract only the current week&#39;s records from server logs on a regular basis\n    - Extract only the current month&#39;s log from attendance logs or absence logs on a regular basis\n\nAppendix-en:\n- In the Keyword setting field, blank lines (blank character settings) are skipped.\n    - There is no way to match (extract) only blank lines.\n        - In other words, blank lines are always filtered out.\n    - If you want to remove blank lines in advance:\n        - Use &quot;Multiline String, Delete Empty Lines&quot;\n- If the amount of calculation is too large, the process will be terminated in the middle.\n    - A large number of Lines and Keywords that requires more than 30 secs will result in a termination.\n- No line feed code is inserted at the end of the output string.\n    - &quot;Narrowed Text&quot; (filtered down)\n    - &quot;Removed Lines&quot; (filtered out)\n- Old Versions\n    - Multiline String, Filter by Text\n        - https:\/\/support.questetra.com\/addons\/multiline-string-filter-by-text-2021\/\n    - Multiline String, Search by Text\n        - https:\/\/support.questetra.com\/addons\/multiline-string-search-by-text\/\n    - String, Extract Values using Line-Begin Matching\n        - https:\/\/support.questetra.com\/addons\/string-extract-values-using-line-begin-matching-2022\/\n    - String List, Check for Existence of Search String\n        - https:\/\/support.questetra.com\/addons\/string-list-check-existence-of-search-string\/\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u3053\u306e\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u300c\u8907\u6570\u884c\u30c6\u30ad\u30b9\u30c8\u300d\u304c\u81ea\u52d5\u7684\u306b\u52a0\u5de5\u3055\u307e\u3059\u3002\n    - \u8907\u6570\u884c\u30c6\u30ad\u30b9\u30c8\u306e\u5404\u884c\u304c\u305d\u308c\u305e\u308c Keyword \u3068\u6bd4\u8f03\u3055\u308c\u3001\u6761\u4ef6\u306b\u30de\u30c3\u30c1\u3057\u305f\u884c\u3060\u3051\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\n    - \u30de\u30c3\u30c1\u6761\u4ef6\u306b\u306f\u300cKeyword \u3068\u7b49\u3057\u3044\u300d\u300c\u3092\u542b\u3080\u300d\u300c\u3067\u59cb\u307e\u308b\u300d\u300c\u3067\u7d42\u308f\u308b\u300d\u306e\u3044\u305a\u308c\u304b\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\n    - \u306a\u304a\u3001\u30d5\u30a3\u30eb\u30bf\u62bd\u51fa\u3055\u308c\u305f\u884c\u3060\u3051\u3067\u306a\u304f\u3001\u30d5\u30a3\u30eb\u30bf\u9664\u53bb\u3055\u308c\u305f\u884c\u3092\u683c\u7d0d\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\n        - \u8a00\u3044\u63db\u3048\u308c\u3070\u300c\u3068\u7b49\u3057\u304f\u306a\u3044\u300d\u300c\u3092\u542b\u307e\u306a\u3044\u300d\u300c\u3067\u59cb\u307e\u3089\u306a\u3044\u300d\u300c\u3067\u7d42\u308f\u3089\u306a\u3044\u300d\u306e\u62bd\u51fa\u3082\u53ef\u80fd\u3067\u3059\u3002\n- OR \u691c\u7d22\u306e\u5834\u5408\u306f\u3001\u305d\u308c\u305e\u308c\u306e Keyword \u3092\u5404\u884c\u306b\u5206\u3051\u3066\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n    - OR \u691c\u7d22\uff1a\u300cKeywords \u306e\u3044\u305a\u308c\u304b\u3068\u7b49\u3057\u3044\u300d\u300c\u306e\u3044\u305a\u308c\u304b\u3092\u542b\u3080\u300d\u300c\u306e\u3044\u305a\u308c\u304b\u3067\u59cb\u307e\u308b\u300d\u300c\u306e\u3044\u305a\u308c\u304b\u3067\u7d42\u308f\u308b\u300d\n    - \u305f\u3068\u3048\u3070\u300c\u6771\u4eac\u90fd\u300d\u3082\u3057\u304f\u306f\u300c\u4eac\u90fd\u5e9c\u300d\u3092\u300c\u542b\u3080\u884c\u300d\u3092\u62bd\u51fa\u3057\u305f\u3044\u5834\u5408\u306f\u3001\n    - \u300c\u6771\u4eac\u90fd\u300d\u30921\u884c\u76ee\u306b\u3001\u300c\u4eac\u90fd\u5e9c\u300d\u30922\u884c\u76ee\u306b\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002(OR-Search)\n- \u306a\u304a AND \u691c\u7d22\u306f\u3001\u300c\u81ea\u52d5\u5de5\u7a0b\u3092\u8907\u6570\u914d\u7f6e\u300d\u3084\u300c\u30eb\u30fc\u30d7\u69cb\u9020\u5185\u306b\u914d\u7f6e\u300d\u3068\u3044\u3063\u305f\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u56f3\u3092\u8a2d\u8a08\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n    - \u305f\u3068\u3048\u3070\u300c\u4eac\u90fd\u5e9c\u300d\u304b\u3064\u300c\u92ad\u6e6f\u300d\u3092\u542b\u3080\u884c\u3092\u62bd\u51fa\u3057\u305f\u3044\u5834\u5408\u306f\u30012\u6bb5\u968e\u3067\u51e6\u7406\u3055\u308c\u308b\u3088\u3046\u306b\u8a2d\u8a08\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n        - \u307e\u305a\u300c\u4eac\u90fd\u5e9c\u300d\u3092\u542b\u3080\u884c\u3092\u62bd\u51fa\u3059\u308b\n        - \u3055\u3089\u306b\u300c\u92ad\u6e6f\u300d\u3092\u542b\u3080\u884c\u3092\u62bd\u51fa\u3059\u308b\n- \u69d8\u3005\u306a\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\uff08\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\uff09\u3067\u3001\u4f5c\u696d\u5de5\u7a0b\u3092\u81ea\u52d5\u5316\uff08\u7121\u4eba\u5316\uff09\u3067\u304d\u307e\u3059\u3002\n    - \u5546\u54c1\u30de\u30b9\u30bf\u30fc\u306e\u767b\u9332\u3092\u78ba\u8a8d\u3059\u308b\n    - \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u30ea\u30b9\u30c8\u306e\u767b\u9332\u3092\u78ba\u8a8d\u3059\u308b\n    - \u30e1\u30fc\u30eb\u30d8\u30c3\u30c0\u304b\u3089\u7279\u5b9a\u306e\u30d8\u30c3\u30c0\u60c5\u5831\u3060\u3051\u3092\u62bd\u51fa\u3059\u308b\n    - \u9867\u5ba2\u4f4f\u6240\u30ea\u30b9\u30c8\u304b\u3089\u7279\u5b9a\u90fd\u5e02\u306e\u4f4f\u6240\u3060\u3051\u3092\u62bd\u51fa\u3059\u308b\n    - \u30b5\u30fc\u30d0\u30fc\u30ed\u30b0\u304b\u3089\u5f53\u9031\u30ec\u30b3\u30fc\u30c9\u3060\u3051\u3092\u5b9a\u6642\u62bd\u51fa\u3059\u308b\n    - \u51fa\u9000\u52e4\u30ed\u30b0\u3084\u6b20\u52e4\u7533\u8acb\u30ed\u30b0\u304b\u3089\u5f53\u6708\u30ed\u30b0\u3060\u3051\u3092\u5b9a\u6642\u62bd\u51fa\u3059\u308b\n\nAppendix-ja:\n- Keyword \u8a2d\u5b9a\u6b04\u306b &quot;\u7a7a\u884c&quot; \u304c\u3042\u3063\u305f\u5834\u5408\u3001\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n    - &quot;\u7a7a\u884c&quot; \u3060\u3051\u306b\u30de\u30c3\u30c1\u3055\u305b\u308b\u8a2d\u5b9a\u65b9\u6cd5\uff08\u7a7a\u884c\u3060\u3051\u3092\u62bd\u51fa\u3059\u308b\u8a2d\u5b9a\u65b9\u6cd5\uff09\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n        - \u8a00\u3044\u63db\u3048\u308c\u3070\u3001&quot;\u7a7a\u884c&quot; \u306f\u5fc5\u305a\u30d5\u30a3\u30eb\u30bf\u9664\u53bb\u3055\u308c\u307e\u3059\u3002\n    - \u3042\u3089\u304b\u3058\u3081 &quot;\u7a7a\u884c&quot; \u3092\u9664\u53bb\u3057\u3066\u304a\u304d\u305f\u3044\u5834\u5408\uff1a\n        - \u300e\u8907\u6570\u884c\u6587\u5b57\u5217, \u7a7a\u884c\u306e\u524a\u9664\u300f\n- \u8a08\u7b97\u91cf\u304c\u591a\u3059\u304e\u308b\u5834\u5408\u3001\u9014\u4e2d\u7d42\u4e86\u3057\u307e\u3059\u3002\n    - \u884c\u6570\u304c\u591a\u3044\u30fbKeyword\u304c\u591a\u3044\u306a\u3069\u300130\u79d2\u3092\u8d85\u3048\u308b\u3088\u3046\u306a\u51e6\u7406\u306f\u9014\u4e2d\u3067\u7d42\u4e86\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\n- \u51fa\u529b\u6587\u5b57\u5217\u306e\u672b\u5c3e\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u633f\u5165\u3055\u308c\u307e\u305b\u3093\u3002\n    - &quot;\u7d5e\u308a\u8fbc\u307e\u308c\u305f\u30c6\u30ad\u30b9\u30c8&quot;\n    - &quot;\u9664\u53bb\u3055\u308c\u305f\u884c&quot;\n- \u4ee5\u524d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\n    - \u8907\u6570\u884c\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf\n        - https:\/\/support.questetra.com\/ja\/addons\/multiline-string-filter-by-text-2021\/\n    - \u8907\u6570\u884c\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u691c\u7d22\n        - https:\/\/support.questetra.com\/ja\/addons\/multiline-string-search-by-text\/\n    - \u6587\u5b57\u5217\u62bd\u51fa,\u884c\u59cb\u307e\u308a\u6587\u5b57\u5217\u30de\u30c3\u30c1\u30f3\u30b0\n        - https:\/\/support.questetra.com\/ja\/addons\/string-extract-values-using-line-begin-matching-2022\/\n    - \u6587\u5b57\u5217\u30ea\u30b9\u30c8, \u691c\u7d22\u6587\u5b57\u306e\u5b58\u5728\u30c1\u30a7\u30c3\u30af\n        - https:\/\/support.questetra.com\/ja\/addons\/string-list-check-existence-of-search-string\/\n\nTest Data for Debug:\ndate,http_version,request_type,scheme,status,timestamp,type,user_ip\n2022-12-14T00:00:00.339Z,HTTP\/1.1,GET,http,200,1670976000,nginx_json,10.46.13.218\n2022-12-14T00:00:37.119Z,HTTP\/1.1,GET,http,200,1670976037,nginx_json,10.138.192.60\n2022-12-14T00:00:38.039Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.063Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.070Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.085Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.154Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.155Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.155Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.168Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.168Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.168Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.169Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.241Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.241Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.241Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.242Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:38.558Z,HTTP\/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60\n2022-12-14T00:00:39.381Z,HTTP\/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60\n2022-12-14T00:00:39.381Z,HTTP\/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60\n2022-12-14T00:00:39.498Z,HTTP\/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60\n2022-12-14T00:00:39.545Z,HTTP\/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60\n2022-12-14T00:00:39.618Z,HTTP\/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60\n2022-12-14T00:00:39.862Z,HTTP\/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60\n2022-12-14T00:00:41.246Z,HTTP\/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60\n2022-12-14T00:00:41.247Z,HTTP\/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60\n2022-12-14T00:00:41.772Z,HTTP\/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60\n2022-12-14T00:00:41.922Z,HTTP\/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60\n2022-12-14T00:00:41.922Z,HTTP\/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60\n2022-12-14T00:00:42.135Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.223Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.387Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.412Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.472Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.499Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.516Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.524Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.604Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:42.733Z,HTTP\/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60\n2022-12-14T00:00:49.214Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.556Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.557Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.557Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.559Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.559Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.561Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.561Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.561Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.562Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.562Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.562Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.562Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.563Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.563Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.563Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.564Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.564Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.564Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.567Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.568Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.569Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.572Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.573Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.574Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.575Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.576Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.576Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.581Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.587Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.739Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.890Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:49.912Z,HTTP\/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134\n2022-12-14T00:00:50.067Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.090Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.144Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.188Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.255Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.444Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.634Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.672Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.781Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.948Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:50.965Z,HTTP\/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134\n2022-12-14T00:00:57.073Z,HTTP\/1.1,GET,http,302,1670976057,nginx_json,10.77.167.10\n2022-12-14T00:00:58.475Z,HTTP\/1.1,GET,http,200,1670976058,nginx_json,10.77.167.10\n2022-12-14T00:00:59.438Z,HTTP\/1.1,GET,http,200,1670976059,nginx_json,10.77.167.10\n\n&quot;Process ID&quot;,&quot;Start User ID&quot;,&quot;\u52e4\u52d9\u65e5&quot;,&quot;\u51fa\u52e4\u6642\u523b&quot;,&quot;\u9000\u52e4\u6642\u523b&quot;\n1977470,458,&quot;2023-01-13&quot;,&quot;2023-01-13 09:00&quot;,&quot;2023-01-13 18:00&quot;\n1977469,456,&quot;2023-01-13&quot;,&quot;2023-01-13 09:00&quot;,&quot;2023-01-13 19:00&quot;\n1977468,14,&quot;2023-01-13&quot;,&quot;2023-01-13 08:17&quot;,&quot;2023-01-13 18:05&quot;\n1977467,15,&quot;2023-01-13&quot;,&quot;2023-01-13 09:00&quot;,&quot;2023-01-13 18:00&quot;\n1977466,16,&quot;2023-01-13&quot;,&quot;2023-01-13 09:00&quot;,&quot;2023-01-13 17:00&quot;\n1977465,92,&quot;2023-01-13&quot;,&quot;2023-01-13 09:00&quot;,&quot;2023-01-13 17:00&quot;\n1977462,89,&quot;2023-01-13&quot;,&quot;2023-01-13 09:00&quot;,&quot;2023-01-13 18:00&quot;\n1977459,88,&quot;2023-01-13&quot;,&quot;2023-01-13 09:00&quot;,&quot;2023-01-13 18:30&quot;\n1977451,85,&quot;2023-01-13&quot;,&quot;2023-01-13 09:00&quot;,&quot;2023-01-13 17:00&quot;\n1976698,15,&quot;2023-01-11&quot;,&quot;2023-01-11 09:00&quot;,&quot;2023-01-11 18:30&quot;\n1976697,15,&quot;2023-01-10&quot;,&quot;2023-01-10 09:00&quot;,&quot;2023-01-10 19:00&quot;\n1976610,458,&quot;2023-01-12&quot;,&quot;2023-01-12 09:00&quot;,&quot;2023-01-12 18:00&quot;\n1976609,456,&quot;2023-01-12&quot;,&quot;2023-01-12 09:00&quot;,&quot;2023-01-12 19:00&quot;\n1976608,14,&quot;2023-01-12&quot;,&quot;2023-01-12 08:16&quot;,&quot;2023-01-12 18:06&quot;\n1976607,15,&quot;2023-01-12&quot;,&quot;2023-01-12 09:00&quot;,&quot;2023-01-12 19:00&quot;\n1976606,16,&quot;2023-01-12&quot;,&quot;2023-01-12 09:00&quot;,&quot;2023-01-12 17:00&quot;\n1976601,89,&quot;2023-01-12&quot;,&quot;2023-01-12 09:00&quot;,&quot;2023-01-12 18:00&quot;\n1976598,88,&quot;2023-01-12&quot;,&quot;2023-01-12 09:00&quot;,&quot;2023-01-12 18:30&quot;\n1976589,85,&quot;2023-01-12&quot;,&quot;2023-01-12 09:00&quot;,&quot;2023-01-12 17:00&quot;\n1975830,89,&quot;2023-01-10&quot;,&quot;2023-01-10 09:00&quot;,&quot;2023-01-10 18:30&quot;\n1975768,458,&quot;2023-01-11&quot;,&quot;2023-01-11 09:00&quot;,&quot;2023-01-11 18:00&quot;\n1975767,456,&quot;2023-01-11&quot;,&quot;2023-01-11 09:00&quot;,&quot;2023-01-11 19:00&quot;\n1975766,14,&quot;2023-01-11&quot;,&quot;2023-01-11 08:16&quot;,&quot;2023-01-11 18:13&quot;\n1975764,16,&quot;2023-01-11&quot;,&quot;2023-01-11 09:00&quot;,&quot;2023-01-11 17:00&quot;\n1975763,92,&quot;2023-01-11&quot;,&quot;2023-01-11 09:00&quot;,&quot;2023-01-11 17:40&quot;\n1975761,89,&quot;2023-01-11&quot;,&quot;2023-01-11 09:00&quot;,&quot;2023-01-11 18:00&quot;\n1975758,88,&quot;2023-01-11&quot;,&quot;2023-01-11 09:00&quot;,&quot;2023-01-11 18:15&quot;\n1975749,85,&quot;2023-01-11&quot;,&quot;2023-01-11 09:00&quot;,&quot;2023-01-11 17:00&quot;\n1974867,458,&quot;2023-01-10&quot;,&quot;2023-01-10 09:00&quot;,&quot;2023-01-10 17:33&quot;\n1974866,456,&quot;2023-01-10&quot;,&quot;2023-01-10 09:00&quot;,&quot;2023-01-10 19:00&quot;\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Download<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1SdptJbQ3GrnX9XxoakCP9Hi-dISEFA-v\/view?usp=drivesdk\" target=\"_blank\">multiline-string-filter-by-keywords-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-01-20 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"has-small-font-size\" style=\"text-align: right;\"><div style=\"display: inline-block; background: #FBE7DD; text-align: center;\">\n<span class=\"material-icons\">warning<\/span> Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<br>\n(Installing <em><strong>Addon Auto-Steps<\/strong><\/em> are available only on the <em><strong><span style=\"color: #1970B9\">Professional<\/span><\/strong><\/em> edition.)\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Notes<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When a process reaches this automated step, multi-line text is automatically processed.\n<ul class=\"wp-block-list\">\n<li>Each line of multiline text is compared to the Keyword, and only lines matching the condition are output.<\/li>\n\n\n\n<li>The match condition can be one of the following: &#8220;equals&#8221;, &#8220;contains&#8221;, &#8220;starts with&#8221;, or &#8220;ends with&#8221;.<\/li>\n\n\n\n<li>Note that it is possible to store not only filtered-down rows, but also filtered-out rows.\n<ul class=\"wp-block-list\">\n<li>In other words, &#8220;does not equal&#8221;, &#8220;does not contain&#8221;, &#8220;does not start with&#8221; and &#8220;does not end with&#8221;.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>In case of OR search, set each Keyword separately in each line.\n<ul class=\"wp-block-list\">\n<li>OR search: &#8220;equals one of the Keywords&#8221;, &#8220;contains one of&#8221;, &#8220;starts with one of&#8221;, &#8220;ends with one of&#8221;<\/li>\n\n\n\n<li>For example, if you want to extract rows containing &#8220;Tokyo&#8221; or &#8220;Kyoto&#8221;<\/li>\n\n\n\n<li>Set &#8220;Tokyo&#8221; on the first row and &#8220;Kyoto&#8221; on the second row. (OR-Search)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>For AND searches, please design a workflow diagram with multiple automatic processes or place them in a loop structure.\n<ul class=\"wp-block-list\">\n<li>For example, if you want to extract rows containing &#8220;Kyoto&#8221; and &#8220;Spa&#8221; design the process in two steps.\n<ul class=\"wp-block-list\">\n<li>First, extract rows containing &#8220;Kyoto&#8221;.<\/li>\n\n\n\n<li>Then, extract rows containing &#8220;Spa&#8221;.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>You can automate the work process in various business processes (workflow).\n<ul class=\"wp-block-list\">\n<li>Confirm registration of product master<\/li>\n\n\n\n<li>Confirm registration of email address list<\/li>\n\n\n\n<li>Extract only specific header information from mail headers<\/li>\n\n\n\n<li>Extract only specific city addresses from a customer address list<\/li>\n\n\n\n<li>Extract only the current week&#8217;s records from server logs on a regular basis<\/li>\n\n\n\n<li>Extract only the current month&#8217;s log from attendance logs or absence logs on a regular basis<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Capture<\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"141295\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/climber-webinvoice-file-upload\/attachment\/multiline-string-filter-by-keywords-2023-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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=\"multiline-string-filter-by-keywords-2023-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Narrows down to just the matched lines from the multiline text. The match condition operator can be set to &quot;equals&quot;, &quot;contains&quot;, &quot;starts with&quot;, or &quot;ends with&quot;. Case-insensitive also available. Also stores the filtered-out lines (removed lines).\" class=\"wp-image-141295\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-rounded is-style-rounded--1\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-config-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"509\" height=\"630\" data-attachment-id=\"141297\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/climber-webinvoice-file-upload\/attachment\/multiline-string-filter-by-keywords-2023-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-config-en.png?fit=897%2C1110&amp;ssl=1\" data-orig-size=\"897,1110\" 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=\"multiline-string-filter-by-keywords-2023-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-config-en.png?fit=509%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-config-en-509x630.png?resize=509%2C630&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-141297\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-config-en.png?resize=509%2C630&amp;ssl=1 509w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-config-en.png?resize=255%2C315&amp;ssl=1 255w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-config-en.png?resize=768%2C950&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-config-en.png?w=897&amp;ssl=1 897w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Appendix<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the Keyword setting field, blank lines (blank character settings) are skipped.\n<ul class=\"wp-block-list\">\n<li>There is no way to match (extract) only blank lines.\n<ul class=\"wp-block-list\">\n<li>In other words, blank lines are always filtered out.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If you want to remove blank lines in advance:\n<ul class=\"wp-block-list\">\n<li>Use &#8220;Multiline String, Delete Empty Lines&#8221;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If the amount of calculation is too large, the process will be terminated in the middle.\n<ul class=\"wp-block-list\">\n<li>A large number of Lines and Keywords that requires more than 30 secs will result in a termination.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>No line feed code is inserted at the end of the output string.\n<ul class=\"wp-block-list\">\n<li>&#8220;Narrowed Text&#8221; (filtered down)<\/li>\n\n\n\n<li>&#8220;Removed Lines&#8221; (filtered out)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Old Versions\n<ul class=\"wp-block-list\">\n<li>Multiline String, Filter by Text\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/addons\/multiline-string-filter-by-text-2021\/\">https:\/\/support.questetra.com\/addons\/multiline-string-filter-by-text-2021\/<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Multiline String, Search by Text\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/addons\/multiline-string-search-by-text\/\">https:\/\/support.questetra.com\/addons\/multiline-string-search-by-text\/<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>String, Extract Values using Line-Begin Matching\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/addons\/string-extract-values-using-line-begin-matching-2022\/\">https:\/\/support.questetra.com\/addons\/string-extract-values-using-line-begin-matching-2022\/<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>String List, Check for Existence of Search String\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/addons\/string-list-check-existence-of-search-string\/\">https:\/\/support.questetra.com\/addons\/string-list-check-existence-of-search-string\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">See Also<\/span><\/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=\"kyOl8i14aa\"><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=Y5htKGU5h9#?secret=kyOl8i14aa\" data-secret=\"kyOl8i14aa\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Narrows multi-line text down to matching lines only. The match condition can be either &#8220;equals&#8221;, &#8220;contains&#8221;, &#8220;begins with&#8221;, or &#8220;ends with&#8221;. A case-insensitive filter can also be specified. It is also possible to separately store the excluded rows (filtered rows).<\/p>\n","protected":false},"author":2,"featured_media":141295,"comment_status":"open","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":[2535],"class_list":["post-141301","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-workflow-automation"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-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\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/multiline-string-filter-by-keywords-2023-capture-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":2,"uagb_excerpt":"Narrows multi-line text down to matching lines only. The match condition can be either \"equals\", \"contains\", \"begins with\", or \"ends with\". A case-insensitive filter can also be specified. It is also possible to separately store the excluded rows (filtered rows).","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-AL3","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":82229,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-filter-by-text\/","url_meta":{"origin":141301,"position":0},"title":"Multiline String, Filter by Text","author":"IMAMURA, Genichi","date":"2019-11-22","format":false,"excerpt":"Filters multiple-line string with any search text. Only lines that contain the search text 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":"Multiline String, Filter by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-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\/Multiline-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\/Multiline-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\/Multiline-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\/Multiline-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":116874,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-search-by-text\/","url_meta":{"origin":141301,"position":1},"title":"Multiline String, Search by Text","author":"Peter Glover","date":"2021-11-16","format":false,"excerpt":"Searches a multiple-line string with any search text. Only lines that exactly matches the search text are output.","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\/2021\/11\/multiline-string-search-by-text-fi-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\/2021\/11\/multiline-string-search-by-text-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/multiline-string-search-by-text-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/multiline-string-search-by-text-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/multiline-string-search-by-text-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":141292,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-keywords-2023\/","url_meta":{"origin":141301,"position":2},"title":"TSV String, Filter by Keywords","author":"IMAMURA, Genichi","date":"2023-01-23","format":false,"excerpt":"Filters TSV text to column-matched lines only. The match condition can be either \"equals\", \"contains\", \"begins with\", or \"ends with\". A case-insensitive filter can also be specified. It is also possible to separately store the excluded rows (filtered rows).","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 Keywords","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/tsv-string-filter-by-keywords-2023-capture-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\/2023\/01\/tsv-string-filter-by-keywords-2023-capture-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/tsv-string-filter-by-keywords-2023-capture-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/tsv-string-filter-by-keywords-2023-capture-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/01\/tsv-string-filter-by-keywords-2023-capture-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82236,"url":"https:\/\/support.questetra.com\/ja\/addons\/multiline-string-filter-by-text\/","url_meta":{"origin":141301,"position":3},"title":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf","author":"IMAMURA, Genichi","date":"2019-11-22","format":false,"excerpt":"\u4efb\u610f\u306e\u691c\u7d22\u30c6\u30ad\u30b9\u30c8\u3067\u8907\u6570\u884c\u306e\u6587\u5b57\u5217\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u307e\u3059\u3002\u691c\u7d22\u30c6\u30ad\u30b9\u30c8\u304c\u542b\u307e\u308c\u308b\u884c\u306e\u307f\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\u8907\u6570\u30c6\u30ad\u30b9\u30c8\u306b\u3088\u308b OR \u691c\u7d22\u3092\u3057\u305f\u3044\u5834\u5408\u306f \"USA,U.S.,United States\" \u306e\u3088\u3046\u306b\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.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\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":109269,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-filter-by-text-2021\/","url_meta":{"origin":141301,"position":4},"title":"Multiline String, Filter by Text","author":"IMAMURA, Genichi","date":"2021-07-12","format":false,"excerpt":"Filters multiple-line string with any search text. Only lines that contain the search text 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":"Multiline String, Filter by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-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\/Multiline-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\/Multiline-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\/Multiline-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\/Multiline-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":117198,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-multiline-string-to-singleline-csv-string-2021\/","url_meta":{"origin":141301,"position":5},"title":"Converter: Multiline-String to Singleline-CSV-String","author":"IMAMURA, Genichi","date":"2021-11-22","format":false,"excerpt":"Converts a multiline string to a CSV string. Converts each row of a multiline string as the value of each cell in the CSV. If commas are included they will be deleted in advance. Lines with only line feed code are recognized as empty data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter, Multiline-String to Singleline-CSV-String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-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\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.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\/141301","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=141301"}],"version-history":[{"count":4,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/141301\/revisions"}],"predecessor-version":[{"id":141350,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/141301\/revisions\/141350"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/141295"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=141301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=141301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=141301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}