2023-01-23 / Add-ons /
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.

%d bloggers like this: