{"id":141292,"date":"2023-01-23T14:04:09","date_gmt":"2023-01-23T05:04:09","guid":{"rendered":"https:\/\/support.questetra.com\/?p=141292"},"modified":"2023-08-21T18:00:05","modified_gmt":"2023-08-21T09:00:05","slug":"tsv-string-filter-by-keywords-2023","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-keywords-2023\/","title":{"rendered":"TSV String, Filter by Keywords"},"content":{"rendered":"\n

TSV String, Filter by Keywords<\/strong><\/h4>\n\n\n\n

TSV \u6587\u5b57\u5217, Keywords \u30d5\u30a3\u30eb\u30bf<\/a><\/p>\n\n\n\n

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).<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA1<\/dt>
A1: Set TSV Text *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB0<\/dt>
B0: Set ID of COLUMN to be Matched (eg: “0”) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
OptionConfB1<\/dt>
B1: Select OPERATOR for Matching Condition *<\/span><\/dd>\n
StrConfB2<\/dt>
B2: Set KEYWORD for Matching Condition (Multi Rows: OR-Search) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfC1<\/dt>
C1: Select STRING that stores Narrowed Text (update)<\/dd>\n
SelectConfC2<\/dt>
C2: Select STRING that stores Removed Lines (update)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strInput         = configs.get      ( "StrConfA1" );    \/\/\/ REQUIRED\n  if( strInput       === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A1: String} is empty \\n" );\n  }\nconst strColMatchId    = configs.get      ( "StrConfB0" );    \/\/\/ REQUIRED\n  if( strColMatchId  === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {B0: String} is empty \\n" );\n  }\nconst strOperator      = configs.get      ( "OptionConfB1" ); \/\/\/ REQUIRED (SELECT_ITEM)\n  \/\/ "equals",  "conains",  "stratswith",  "endswith",\n  \/\/ "equals2", "conains2", "startswith2", "endswith2" (2:ignore case)\nconst strKeywords      = configs.get      ( "StrConfB2" );    \/\/\/ REQUIRED\n  if( strKeywords    === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {B2: String} is empty \\n" );\n  }\nconst strPocketOutput  = configs.getObject( "SelectConfC1" ); \/\/ NotRequired\nconst strPocketRemoved = configs.getObject( "SelectConfC2" ); \/\/ 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 numColMatchId    = parseInt ( strColMatchId );\n\nconst arrInput     = strInput.split( '\\n' );\nconst arrKeywords  = strKeywords.split( '\\n' );\n\nlet   arrOutput    = [];\nlet   arrRemoved   = [];\n\nif ( strOperator === "equals" ) {\n  loopInput:\n  for ( let i = 0; i < arrInput.length; i++ ) {\n    for ( let j = 0; j < arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === "" ){\n        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );\n        continue;\n      }\n      if ( arrInput[i].split( '\\t', (numColMatchId + 1) )?.[ numColMatchId ] ===\n          arrKeywords[j] ){\n          \/\/ optional chaining (?.) operator returns `undefined` instead of throwing an error.\n          \/\/ https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Operators\/Optional_chaining\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === "equals2" ) {\n  loopInput:\n  for ( let i = 0; i < arrInput.length; i++ ) {\n    for ( let j = 0; j < arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === "" ){\n        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );\n        continue;\n      }\n      if ( arrInput[i].split( '\\t', (numColMatchId + 1) )?.[ numColMatchId ].toUpperCase() ===\n           arrKeywords[j].toUpperCase() ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === "contains" ) {\n  loopInput:\n  for ( let i = 0; i < arrInput.length; i++ ) {\n    for ( let j = 0; j < arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === "" ){\n        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );\n        continue;\n      }\n      if ( arrInput[i].split( '\\t', (numColMatchId + 1) )?.[ numColMatchId ]\n           .includes( arrKeywords[j] ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === "contains2" ) {\n  loopInput:\n  for ( let i = 0; i < arrInput.length; i++ ) {\n    for ( let j = 0; j < arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === "" ){\n        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );\n        continue;\n      }\n      if ( arrInput[i].split( '\\t', (numColMatchId + 1) )?.[ numColMatchId ].toUpperCase()\n           .includes( (arrKeywords[j].toUpperCase()) ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === "startswith" ) {\n  loopInput:\n  for ( let i = 0; i < arrInput.length; i++ ) {\n    for ( let j = 0; j < arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === "" ){\n        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );\n        continue;\n      }\n      if ( arrInput[i].split( '\\t', (numColMatchId + 1) )?.[ numColMatchId ]\n           .startsWith( arrKeywords[j] ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === "startswith2" ) {\n  loopInput:\n  for ( let i = 0; i < arrInput.length; i++ ) {\n    for ( let j = 0; j < arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === "" ){\n        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );\n        continue;\n      }\n      if ( arrInput[i].split( '\\t', (numColMatchId + 1) )?.[ numColMatchId ].toUpperCase()\n           .startsWith( (arrKeywords[j].toUpperCase()) ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === "endswith" ) {\n  loopInput:\n  for ( let i = 0; i < arrInput.length; i++ ) {\n    for ( let j = 0; j < arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === "" ){\n        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );\n        continue;\n      }\n      if ( arrInput[i].split( '\\t', (numColMatchId + 1) )?.[ numColMatchId ]\n           .endsWith( arrKeywords[j] ) ){\n        arrOutput.push ( arrInput[i] );\n        continue loopInput;\n      }\n    }\n    arrRemoved.push ( arrInput[i] );\n  }\n} else if ( strOperator === "endswith2" ) {\n  loopInput:\n  for ( let i = 0; i < arrInput.length; i++ ) {\n    for ( let j = 0; j < arrKeywords.length; j++ ) {\n      if ( arrKeywords[j] === "" ){\n        engine.log( " AutomatedTask RuntimeWorning: Empty in Keywords config" );\n        continue;\n      }\n      if ( arrInput[i].split( '\\t', (numColMatchId + 1) )?.[ numColMatchId ].toUpperCase()\n           .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( "\\n AutomatedTask RuntimeError:" +\n                   " Unexpected OPERATOR \\n" );\n}\n\nlet strOutput  = arrOutput?.join( '\\n' ) ?? "";\nlet strRemoved = arrRemoved?.join( '\\n' ) ?? "";\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 "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\n\/*\nNotes:\n- When a process reaches this automated step, "TSV text" is automatically processed.\n    - Column value in each line of TSV is compared to the Keyword, and only lines matching the condition are output.\n        - If "0" is specified for the column ID, the first value of each line and Keyword are compared.\n        - If "1" is specified for the column ID, the second value of each line and Keyword are compared.\n    - The match condition can be one of the following: "equals", "contains", "starts with", or "ends with".\n    - Note that it is possible to store not only filtered-down rows, but also filtered-out rows.\n        - In other words, "does not equal", "does not contain", "does not start with" and "does not end with".\n- In case of OR search, set each Keyword separately in each line.\n    - OR search: "equals one of the Keywords", "contains one of", "starts with one of", "ends with one of"\n    - For example, if you want to extract rows containing "Tokyo" or "Kyoto"\n    - Set "Tokyo" on the first row and "Kyoto" on the second row. (OR-Search)\n- For AND search, design a workflow diagram such as "Multiple automated steps" or "Place in loop structure".\n    - For example, if you want to extract rows containing "Kyoto" and "Spa" design the process in two steps.\n        - First, extract rows containing "Kyoto".\n        - Then, extract rows containing "Spa".\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's records from server logs on a regular basis\n    - Extract only the current month'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 "Multiline String, Delete Empty Lines"\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    - "Narrowed Text" (filtered down)\n    - "Removed Lines" (filtered out)\n- Old Versions\n    - TSV String, Filter by Text\n        - https:\/\/support.questetra.com\/ja\/addons\/tsv-string-filter-by-text-2021\/\n    - TSV String, Filter Out by Text\n        - https:\/\/support.questetra.com\/ja\/addons\/tsv-string-filter-out-by-text-2021\/\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u3053\u306e\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u300cTSV\u30c6\u30ad\u30b9\u30c8\u300d\u304c\u81ea\u52d5\u7684\u306b\u52a0\u5de5\u3055\u307e\u3059\u3002\n    - TSV\u30c6\u30ad\u30b9\u30c8\u5404\u884c\u306e\u6307\u5b9a\u30ab\u30e9\u30e0\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        - \u30ab\u30e9\u30e0ID\u306b\u300c0\u300d\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u3001\u5404\u884c\u306e\u5148\u982d\u5024\u3068 Keyword \u304c\u6bd4\u8f03\u3055\u308c\u307e\u3059\u3002\n        - \u30ab\u30e9\u30e0ID\u306b\u300c1\u300d\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u3001\u5404\u884c\u306e2\u756a\u76ee\u306e\u5024\u3068 Keyword \u304c\u6bd4\u8f03\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 "\u7a7a\u884c" \u304c\u3042\u3063\u305f\u5834\u5408\u3001\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n    - "\u7a7a\u884c" \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"\u7a7a\u884c" \u306f\u5fc5\u305a\u30d5\u30a3\u30eb\u30bf\u9664\u53bb\u3055\u308c\u307e\u3059\u3002\n    - \u3042\u3089\u304b\u3058\u3081 "\u7a7a\u884c" \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    - "\u7d5e\u308a\u8fbc\u307e\u308c\u305f\u30c6\u30ad\u30b9\u30c8"\n    - "\u9664\u53bb\u3055\u308c\u305f\u884c"\n- \u4ee5\u524d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\n    - TSV\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf\n        - https:\/\/support.questetra.com\/ja\/addons\/tsv-string-filter-by-text-2021\/\n    - TSV\u6587\u5b57\u5217, \u9664\u5916\u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf\n        - https:\/\/support.questetra.com\/ja\/addons\/tsv-string-filter-out-by-text-2021\/\n\n\nTest Data for Debug:\n"Process ID"\t"Start User ID"\t"\u52e4\u52d9\u65e5"\t"\u51fa\u52e4\u6642\u523b"\t"\u9000\u52e4\u6642\u523b"\n1977470\t458\t"2023-01-13"\t"2023-01-13 09:00"\t"2023-01-13 18:00"\n1977469\t456\t"2023-01-13"\t"2023-01-13 09:00"\t"2023-01-13 19:00"\n1977468\t14\t"2023-01-13"\t"2023-01-13 08:17"\t"2023-01-13 18:05"\n1977467\t15\t"2023-01-13"\t"2023-01-13 09:00"\t"2023-01-13 18:00"\n1977466\t16\t"2023-01-13"\t"2023-01-13 09:00"\t"2023-01-13 17:00"\n1977465\t92\t"2023-01-13"\t"2023-01-13 09:00"\t"2023-01-13 17:00"\n1977462\t89\t"2023-01-13"\t"2023-01-13 09:00"\t"2023-01-13 18:00"\n1977459\t88\t"2023-01-13"\t"2023-01-13 09:00"\t"2023-01-13 18:30"\n1977451\t85\t"2023-01-13"\t"2023-01-13 09:00"\t"2023-01-13 17:00"\n1976698\t15\t"2023-01-11"\t"2023-01-11 09:00"\t"2023-01-11 18:30"\n1976697\t15\t"2023-01-10"\t"2023-01-10 09:00"\t"2023-01-10 19:00"\n1976610\t458\t"2023-01-12"\t"2023-01-12 09:00"\t"2023-01-12 18:00"\n1976609\t456\t"2023-01-12"\t"2023-01-12 09:00"\t"2023-01-12 19:00"\n1976608\t14\t"2023-01-12"\t"2023-01-12 08:16"\t"2023-01-12 18:06"\n1976607\t15\t"2023-01-12"\t"2023-01-12 09:00"\t"2023-01-12 19:00"\n1976606\t16\t"2023-01-12"\t"2023-01-12 09:00"\t"2023-01-12 17:00"\n1976601\t89\t"2023-01-12"\t"2023-01-12 09:00"\t"2023-01-12 18:00"\n1976598\t88\t"2023-01-12"\t"2023-01-12 09:00"\t"2023-01-12 18:30"\n1976589\t85\t"2023-01-12"\t"2023-01-12 09:00"\t"2023-01-12 17:00"\n1975830\t89\t"2023-01-10"\t"2023-01-10 09:00"\t"2023-01-10 18:30"\n\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n