Multiline String, Filter by Keywords

/ Add-ons / Workflow Automation
Multiline String, Filter by Keywords

Multiline String, Filter by Keywords

複数行文字列, Keywords フィルタ

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).

Auto Step icon
Configs for this Auto Step
StrConfA1
A1: Set Multiline Text *#{EL}
OptionConfB1
B1: Select OPERATOR for Matching Condition *
StrConfB2
B2: Set KEYWORD for Matching Condition (Multi Rows: OR-Search) *#{EL}
SelectConfC1
C1: Select STRING that stores Narrowed Text (update)
SelectConfC2
C2: Select STRING that stores Removed Lines (update)
Script (click to open)
// GraalJS Script (engine type: 2)

//////// START "main()" ////////////////////////////////////////////////////////////////
main();
function main(){ 

//// == Config Retrieving / 工程コンフィグの参照 ==
const strInput         = configs.get      ( "StrConfA1" );    /// REQUIRED
  if( strInput       === "" ){
    throw new Error( "\n AutomatedTask ConfigError:" +
                     " Config {A1: String} is empty \n" );
  }
const strOperator      = configs.get      ( "OptionConfB1" ); /// REQUIRED (SELECT_ITEM)
  // "equals",  "conains",  "stratswith",  "endswith",
  // "equals2", "conains2", "startswith2", "endswith2" (2:ignore case)
const strKeywords      = configs.get      ( "StrConfB2" );    /// REQUIRED
  if( strKeywords    === "" ){
    throw new Error( "\n AutomatedTask ConfigError:" +
                     " Config {B2: String} is empty \n" );
  }
const strPocketOutput  = configs.getObject( "SelectConfC1" ); // NotRequired
const strPocketRemoved = configs.getObject( "SelectConfC2" ); // NotRequired


//// == Data Retrieving / ワークフローデータの参照 ==
// (Nothing. Retrieved via Expression Language in Config Retrieving)


//// == Calculating / 演算 ==
const arrInput     = strInput.split( '\n' );
const arrKeywords  = strKeywords.split( '\n' );

let   arrOutput    = [];
let   arrRemoved   = [];

if ( strOperator === "equals" ) {
  loopInput:
  for ( let i = 0; i < arrInput.length; i++ ) {
    for ( let j = 0; j < arrKeywords.length; j++ ) {
      if ( arrKeywords[j] === "" ){
        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );
        continue;
      }
      if ( arrInput[i] === arrKeywords[j] ){
        arrOutput.push ( arrInput[i] );
        continue loopInput;
      }
    }
    arrRemoved.push ( arrInput[i] );
  }
} else if ( strOperator === "equals2" ) {
  loopInput:
  for ( let i = 0; i < arrInput.length; i++ ) {
    for ( let j = 0; j < arrKeywords.length; j++ ) {
      if ( arrKeywords[j] === "" ){
        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );
        continue;
      }
      if ( arrInput[i].toUpperCase() === arrKeywords[j].toUpperCase() ){
        arrOutput.push ( arrInput[i] );
        continue loopInput;
      }
    }
    arrRemoved.push ( arrInput[i] );
  }
} else if ( strOperator === "contains" ) {
  loopInput:
  for ( let i = 0; i < arrInput.length; i++ ) {
    for ( let j = 0; j < arrKeywords.length; j++ ) {
      if ( arrKeywords[j] === "" ){
        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );
        continue;
      }
      if ( arrInput[i].includes( arrKeywords[j] ) ){
        arrOutput.push ( arrInput[i] );
        continue loopInput;
      }
    }
    arrRemoved.push ( arrInput[i] );
  }
} else if ( strOperator === "contains2" ) {
  loopInput:
  for ( let i = 0; i < arrInput.length; i++ ) {
    for ( let j = 0; j < arrKeywords.length; j++ ) {
      if ( arrKeywords[j] === "" ){
        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );
        continue;
      }
      if ( arrInput[i].toUpperCase().includes( (arrKeywords[j].toUpperCase()) ) ){
        arrOutput.push ( arrInput[i] );
        continue loopInput;
      }
    }
    arrRemoved.push ( arrInput[i] );
  }
} else if ( strOperator === "startswith" ) {
  loopInput:
  for ( let i = 0; i < arrInput.length; i++ ) {
    for ( let j = 0; j < arrKeywords.length; j++ ) {
      if ( arrKeywords[j] === "" ){
        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );
        continue;
      }
      if ( arrInput[i].startsWith( arrKeywords[j] ) ){
        arrOutput.push ( arrInput[i] );
        continue loopInput;
      }
    }
    arrRemoved.push ( arrInput[i] );
  }
} else if ( strOperator === "startswith2" ) {
  loopInput:
  for ( let i = 0; i < arrInput.length; i++ ) {
    for ( let j = 0; j < arrKeywords.length; j++ ) {
      if ( arrKeywords[j] === "" ){
        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );
        continue;
      }
      if ( arrInput[i].toUpperCase().startsWith( (arrKeywords[j].toUpperCase()) ) ){
        arrOutput.push ( arrInput[i] );
        continue loopInput;
      }
    }
    arrRemoved.push ( arrInput[i] );
  }
} else if ( strOperator === "endswith" ) {
  loopInput:
  for ( let i = 0; i < arrInput.length; i++ ) {
    for ( let j = 0; j < arrKeywords.length; j++ ) {
      if ( arrKeywords[j] === "" ){
        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );
        continue;
      }
      if ( arrInput[i].endsWith( arrKeywords[j] ) ){
        arrOutput.push ( arrInput[i] );
        continue loopInput;
      }
    }
    arrRemoved.push ( arrInput[i] );
  }
} else if ( strOperator === "endswith2" ) {
  loopInput:
  for ( let i = 0; i < arrInput.length; i++ ) {
    for ( let j = 0; j < arrKeywords.length; j++ ) {
      if ( arrKeywords[j] === "" ){
        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );
        continue;
      }
      if ( arrInput[i].toUpperCase().endsWith( (arrKeywords[j].toUpperCase()) ) ){
        arrOutput.push ( arrInput[i] );
        continue loopInput;
      }
    }
    arrRemoved.push ( arrInput[i] );
  }
} else {
  throw new Error( "\n AutomatedTask RuntimeError:" +
                   " Unexpected OPERATOR \n" );
}

let strOutput  = arrOutput?.join( '\n' ) ?? "";
let strRemoved = arrRemoved?.join( '\n' ) ?? "";
// https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Optional_chaining


//// == Data Updating / ワークフローデータへの代入 ==
if ( strPocketOutput !== null ) {
  engine.setData ( strPocketOutput,  strOutput );
}
if ( strPocketRemoved !== null ) {
  engine.setData ( strPocketRemoved, strRemoved );
}

} //////// END "main()" /////////////////////////////////////////////////////////////////



/*
Notes:
- When a process reaches this automated step, "multi-line text" is automatically processed.
    - Each line of multiline text is compared to the Keyword, and only lines matching the condition are output.
    - The match condition can be one of the following: "equals", "contains", "starts with", or "ends with".
    - Note that it is possible to store not only filtered-down rows, but also filtered-out rows.
        - In other words, "does not equal", "does not contain", "does not start with" and "does not end with".
- In case of OR search, set each Keyword separately in each line.
    - OR search: "equals one of the Keywords", "contains one of", "starts with one of", "ends with one of"
    - For example, if you want to extract rows containing "Tokyo" or "Kyoto"
    - Set "Tokyo" on the first row and "Kyoto" on the second row. (OR-Search)
- For AND search, design a workflow diagram such as "Multiple automated steps" or "Place in loop structure".
    - For example, if you want to extract rows containing "Kyoto" and "Spa" design the process in two steps.
        - First, extract rows containing "Kyoto".
        - Then, extract rows containing "Spa".
- You can automate the work process in various business processes (workflow).
    - Confirm registration of product master
    - Confirm registration of e-mail address list
    - Extract only specific header information from mail headers
    - Extract only specific city addresses from a customer address list
    - Extract only the current week's records from server logs on a regular basis
    - Extract only the current month's log from attendance logs or absence logs on a regular basis

Appendix-en:
- In the Keyword setting field, blank lines (blank character settings) are skipped.
    - There is no way to match (extract) only blank lines.
        - In other words, blank lines are always filtered out.
    - If you want to remove blank lines in advance:
        - Use "Multiline String, Delete Empty Lines"
- If the amount of calculation is too large, the process will be terminated in the middle.
    - A large number of Lines and Keywords that requires more than 30 secs will result in a termination.
- No line feed code is inserted at the end of the output string.
    - "Narrowed Text" (filtered down)
    - "Removed Lines" (filtered out)
- Old Versions
    - Multiline String, Filter by Text
        - https://support.questetra.com/addons/multiline-string-filter-by-text-2021/
    - Multiline String, Search by Text
        - https://support.questetra.com/addons/multiline-string-search-by-text/
    - String, Extract Values using Line-Begin Matching
        - https://support.questetra.com/addons/string-extract-values-using-line-begin-matching-2022/
    - String List, Check for Existence of Search String
        - https://support.questetra.com/addons/string-list-check-existence-of-search-string/

Notes-ja:
- 案件がこの自動工程に到達した際、「複数行テキスト」が自動的に加工さます。
    - 複数行テキストの各行がそれぞれ Keyword と比較され、条件にマッチした行だけが出力されます。
    - マッチ条件には「Keyword と等しい」「を含む」「で始まる」「で終わる」のいずれかを指定します。
    - なお、フィルタ抽出された行だけでなく、フィルタ除去された行を格納することも可能です。
        - 言い換えれば「と等しくない」「を含まない」「で始まらない」「で終わらない」の抽出も可能です。
- OR 検索の場合は、それぞれの Keyword を各行に分けて設定してください。
    - OR 検索：「Keywords のいずれかと等しい」「のいずれかを含む」「のいずれかで始まる」「のいずれかで終わる」
    - たとえば「東京都」もしくは「京都府」を「含む行」を抽出したい場合は、
    - 「東京都」を1行目に、「京都府」を2行目に設定してください。(OR-Search)
- なお AND 検索は、「自動工程を複数配置」や「ループ構造内に配置」といったワークフロー図を設計してください。
    - たとえば「京都府」かつ「銭湯」を含む行を抽出したい場合は、2段階で処理されるように設計してください。
        - まず「京都府」を含む行を抽出する
        - さらに「銭湯」を含む行を抽出する
- 様々な業務プロセス（ワークフロー）で、作業工程を自動化（無人化）できます。
    - 商品マスターの登録を確認する
    - メールアドレスリストの登録を確認する
    - メールヘッダから特定のヘッダ情報だけを抽出する
    - 顧客住所リストから特定都市の住所だけを抽出する
    - サーバーログから当週レコードだけを定時抽出する
    - 出退勤ログや欠勤申請ログから当月ログだけを定時抽出する

Appendix-ja:
- Keyword 設定欄に "空行" があった場合、無視されます。
    - "空行" だけにマッチさせる設定方法（空行だけを抽出する設定方法）はありません。
        - 言い換えれば、"空行" は必ずフィルタ除去されます。
    - あらかじめ "空行" を除去しておきたい場合：
        - 『複数行文字列, 空行の削除』
- 計算量が多すぎる場合、途中終了します。
    - 行数が多い・Keywordが多いなど、30秒を超えるような処理は途中で終了する可能性があります。
- 出力文字列の末尾に改行コードは挿入されません。
    - "絞り込まれたテキスト"
    - "除去された行"
- 以前のバージョン
    - 複数行文字列, テキストフィルタ
        - https://support.questetra.com/ja/addons/multiline-string-filter-by-text-2021/
    - 複数行文字列, テキスト検索
        - https://support.questetra.com/ja/addons/multiline-string-search-by-text/
    - 文字列抽出,行始まり文字列マッチング
        - https://support.questetra.com/ja/addons/string-extract-values-using-line-begin-matching-2022/
    - 文字列リスト, 検索文字の存在チェック
        - https://support.questetra.com/ja/addons/string-list-check-existence-of-search-string/

Test Data for Debug:
date,http_version,request_type,scheme,status,timestamp,type,user_ip
2022-12-14T00:00:00.339Z,HTTP/1.1,GET,http,200,1670976000,nginx_json,10.46.13.218
2022-12-14T00:00:37.119Z,HTTP/1.1,GET,http,200,1670976037,nginx_json,10.138.192.60
2022-12-14T00:00:38.039Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.063Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.070Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.085Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.154Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.155Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.155Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.168Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.168Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.168Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.169Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.241Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.241Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.241Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.242Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:38.558Z,HTTP/1.1,GET,http,200,1670976038,nginx_json,10.138.192.60
2022-12-14T00:00:39.381Z,HTTP/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60
2022-12-14T00:00:39.381Z,HTTP/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60
2022-12-14T00:00:39.498Z,HTTP/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60
2022-12-14T00:00:39.545Z,HTTP/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60
2022-12-14T00:00:39.618Z,HTTP/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60
2022-12-14T00:00:39.862Z,HTTP/1.1,GET,http,200,1670976039,nginx_json,10.138.192.60
2022-12-14T00:00:41.246Z,HTTP/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60
2022-12-14T00:00:41.247Z,HTTP/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60
2022-12-14T00:00:41.772Z,HTTP/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60
2022-12-14T00:00:41.922Z,HTTP/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60
2022-12-14T00:00:41.922Z,HTTP/1.1,GET,http,200,1670976041,nginx_json,10.138.192.60
2022-12-14T00:00:42.135Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.223Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.387Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.412Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.472Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.499Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.516Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.524Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.604Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:42.733Z,HTTP/1.1,GET,http,200,1670976042,nginx_json,10.138.192.60
2022-12-14T00:00:49.214Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.556Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.557Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.557Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.559Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.559Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.561Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.561Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.561Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.562Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.562Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.562Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.562Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.563Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.563Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.563Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.564Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.564Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.564Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.567Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.568Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.569Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.572Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.573Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.574Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.575Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.576Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.576Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.581Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.587Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.739Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.890Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:49.912Z,HTTP/1.1,GET,http,200,1670976049,nginx_json,10.167.150.134
2022-12-14T00:00:50.067Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.090Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.144Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.188Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.255Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.444Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.634Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.672Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.781Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.948Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:50.965Z,HTTP/1.1,GET,http,200,1670976050,nginx_json,10.167.150.134
2022-12-14T00:00:57.073Z,HTTP/1.1,GET,http,302,1670976057,nginx_json,10.77.167.10
2022-12-14T00:00:58.475Z,HTTP/1.1,GET,http,200,1670976058,nginx_json,10.77.167.10
2022-12-14T00:00:59.438Z,HTTP/1.1,GET,http,200,1670976059,nginx_json,10.77.167.10

"Process ID","Start User ID","勤務日","出勤時刻","退勤時刻"
1977470,458,"2023-01-13","2023-01-13 09:00","2023-01-13 18:00"
1977469,456,"2023-01-13","2023-01-13 09:00","2023-01-13 19:00"
1977468,14,"2023-01-13","2023-01-13 08:17","2023-01-13 18:05"
1977467,15,"2023-01-13","2023-01-13 09:00","2023-01-13 18:00"
1977466,16,"2023-01-13","2023-01-13 09:00","2023-01-13 17:00"
1977465,92,"2023-01-13","2023-01-13 09:00","2023-01-13 17:00"
1977462,89,"2023-01-13","2023-01-13 09:00","2023-01-13 18:00"
1977459,88,"2023-01-13","2023-01-13 09:00","2023-01-13 18:30"
1977451,85,"2023-01-13","2023-01-13 09:00","2023-01-13 17:00"
1976698,15,"2023-01-11","2023-01-11 09:00","2023-01-11 18:30"
1976697,15,"2023-01-10","2023-01-10 09:00","2023-01-10 19:00"
1976610,458,"2023-01-12","2023-01-12 09:00","2023-01-12 18:00"
1976609,456,"2023-01-12","2023-01-12 09:00","2023-01-12 19:00"
1976608,14,"2023-01-12","2023-01-12 08:16","2023-01-12 18:06"
1976607,15,"2023-01-12","2023-01-12 09:00","2023-01-12 19:00"
1976606,16,"2023-01-12","2023-01-12 09:00","2023-01-12 17:00"
1976601,89,"2023-01-12","2023-01-12 09:00","2023-01-12 18:00"
1976598,88,"2023-01-12","2023-01-12 09:00","2023-01-12 18:30"
1976589,85,"2023-01-12","2023-01-12 09:00","2023-01-12 17:00"
1975830,89,"2023-01-10","2023-01-10 09:00","2023-01-10 18:30"
1975768,458,"2023-01-11","2023-01-11 09:00","2023-01-11 18:00"
1975767,456,"2023-01-11","2023-01-11 09:00","2023-01-11 19:00"
1975766,14,"2023-01-11","2023-01-11 08:16","2023-01-11 18:13"
1975764,16,"2023-01-11","2023-01-11 09:00","2023-01-11 17:00"
1975763,92,"2023-01-11","2023-01-11 09:00","2023-01-11 17:40"
1975761,89,"2023-01-11","2023-01-11 09:00","2023-01-11 18:00"
1975758,88,"2023-01-11","2023-01-11 09:00","2023-01-11 18:15"
1975749,85,"2023-01-11","2023-01-11 09:00","2023-01-11 17:00"
1974867,458,"2023-01-10","2023-01-10 09:00","2023-01-10 17:33"
1974866,456,"2023-01-10","2023-01-10 09:00","2023-01-10 19:00"
*/

Download

warning Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.
(Installing Addon Auto-Steps are available only on the Professional edition.)

Notes

  • When a process reaches this automated step, multi-line text is automatically processed.
    • Each line of multiline text is compared to the Keyword, and only lines matching the condition are output.
    • The match condition can be one of the following: “equals”, “contains”, “starts with”, or “ends with”.
    • Note that it is possible to store not only filtered-down rows, but also filtered-out rows.
      • In other words, “does not equal”, “does not contain”, “does not start with” and “does not end with”.
  • In case of OR search, set each Keyword separately in each line.
    • OR search: “equals one of the Keywords”, “contains one of”, “starts with one of”, “ends with one of”
    • For example, if you want to extract rows containing “Tokyo” or “Kyoto”
    • Set “Tokyo” on the first row and “Kyoto” on the second row. (OR-Search)
  • For AND searches, please design a workflow diagram with multiple automatic processes or place them in a loop structure.
    • For example, if you want to extract rows containing “Kyoto” and “Spa” design the process in two steps.
      • First, extract rows containing “Kyoto”.
      • Then, extract rows containing “Spa”.
  • You can automate the work process in various business processes (workflow).
    • Confirm registration of product master
    • Confirm registration of email address list
    • Extract only specific header information from mail headers
    • Extract only specific city addresses from a customer address list
    • Extract only the current week’s records from server logs on a regular basis
    • Extract only the current month’s log from attendance logs or absence logs on a regular basis

Capture

Narrows down to just the matched lines from the multiline text. The match condition operator can be set to "equals", "contains", "starts with", or "ends with". Case-insensitive also available. Also stores the filtered-out lines (removed lines).

Appendix

See Also

String, Replace All

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top

Discover more from Questetra Support

Subscribe now to keep reading and get access to the full archive.

Continue reading