2023-01-23 / Add-ons /
Multiline String, Search by Text
Searches a multiple-line string with any search text. Only lines that exactly matches the search text are output.
Configs
  • A: Select STRING DATA for Multiline String *
  • B: Set Search Texts *#{EL}
  • C: Select STRING DATA for Matched String (update) *
Script (click to open)
// GraalJS Script (engine type: 2)
// (c) 2021, Questetra, Inc. (the MIT License)


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

//// == Config Retrieving / 工程コンフィグの参照 ==
const dataIdA    = configs.get( "conf_DataIdA" ) + "";     // config required
const searchText = configs.get( "conf_SearchText" ) + "";  // config required
const dataIdC    = configs.get( "conf_DataIdC" ) + "";     // config required

if( searchText === "" ){
  throw new Error( "\n AutomatedTask ConfigError:" +
                   " Config {Search Text} is empty \n" );
}


//// == Data Retrieving / ワークフローデータの参照 ==
const inputString = engine.findDataByNumber( dataIdA ) + "";
const arrInputString = inputString.split("\n");
engine.log( " AutomatedTask MultilineString:" + 
            " String {A}, number of lines: " + arrInputString.length );


//// == Calculating / 演算 ==
let   outputString = "";
for( let i = 0; i < arrInputString.length; i++ ){
    if( searchText === arrInputString[i] ){
      outputString += arrInputString[i];
      break;
    }
}

//// == Data Updating / ワークフローデータへの代入 ==
if( outputString === "" ){
  engine.log( " AutomatedTask DataUpdating: Output Text empty" );
}
engine.setDataByNumber( dataIdC, outputString );

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

Download

2021-11-12 (C) Questetra, Inc. (MIT License)
https://support.questetra.com/addons/multiline-string-search-by-text/
The Add-on import feature is available with Professional edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.

Notes

  • The intended use is to check if the String-type (multiple lines) data (retrieved by [Master Table, Get Options Data]) contains rows that exactly match the specified string.

Capture

%d