{"id":140897,"date":"2023-01-11T11:15:05","date_gmt":"2023-01-11T02:15:05","guid":{"rendered":"https:\/\/support.questetra.com\/?p=140897"},"modified":"2023-01-11T11:15:06","modified_gmt":"2023-01-11T02:15:06","slug":"multiline-string-remove-duplicate-lines-2023","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-remove-duplicate-lines-2023\/","title":{"rendered":"Multiline String, Remove Duplicate Lines"},"content":{"rendered":"\n

Multiline String, Remove Duplicate Lines<\/strong><\/h4>\n\n\n\n

\u8907\u6570\u884c\u6587\u5b57\u5217, \u91cd\u8907\u884c\u306e\u524a\u9664<\/a><\/p>\n\n\n\n

Extracts and deletes all duplicate rows. In forward order mode, the first row is retained; in reverse order mode, the last row is retained. Note that “ABC” and “Abc” are recognized as different columns. (case sensitive)<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA1<\/dt>
A1: Set Input Text *<\/span>#{EL}<\/sup><\/span><\/dd>\n
BoolConfB1<\/dt>
B1: Forward mode or Reverse mode<\/dd>\n
SelectConfC1<\/dt>
C1: Select STRING DATA for Output TSV Text (update)<\/dd>\n
SelectConfC2<\/dt>
C2: Select STRING DATA for 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 boolReverseMode  = configs.getObject( "BoolConfB1" );   \/\/\/ TOGGLE\n  \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300 "Boolean object"\n  if( boolReverseMode ){ \/\/ true\n    engine.log( " AutomatedTask Config: Reverse order Search");\n  }else{\n    engine.log( " AutomatedTask Config: Forward order Search");\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 arrInput     = strInput.split( '\\n' );\n\nlet   arrOutput    = [];\nlet   arrRemoved   = [];\nlet   setUniqKeys  = new Set();\n\/\/ The Set object lets you store unique values of any type. Require ES2015(ES6)\n\/\/ https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Set\n\/\/ https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Set\n\nif ( boolReverseMode ) {\n  arrInput.reverse(); \/\/ [ "line0", "line1", "line2" ] \u21d2 [ "line2", "line1", "line0" ]\n}\nfor ( let i = 0; i < arrInput.length; i++ ) {\n  let strKey = arrInput[i];\n  \/\/ engine.log( " AutomatedTask StrKey: " + strKey );\n  if ( setUniqKeys.has ( strKey ) ) {\n    \/\/ engine.log( " AutomatedTask SetUniqKeys has: " + strKey + " (line: " + i + ")" );\n    arrRemoved.push ( strKey );\n  } else {\n    arrOutput.push  ( strKey );\n    setUniqKeys.add ( strKey );\n  }\n}\nif ( boolReverseMode ) {\n  if ( arrOutput.length !== 0 ){\n       arrOutput.reverse(); \/\/ [ "line2", "line1", "line0" ] \u21d2 [ "line0", "line1", "line2" ]\n  }\n  if ( arrRemoved.length !== 0 ){\n       arrRemoved.reverse();\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 the process reaches the automated step, the "Multiline text" will be automatically evaluated.\n    - In Forward mode, the first occurrence of a row is retained.\n    - And the second and subsequent occurrences are deleted.\n- If the "Output Text" is empty, the string type data item is updated with empty characters.\n- If the "delete line" is empty, the string type data item is updated with an empty string.\nAppendix-en:\n- In computer science, a `Set` is an abstract data type:\n    - that can store unique values, without any particular order.\n    - It is a computer implementation of the mathematical concept of a finite set.\n    - https:\/\/en.wikipedia.org\/wiki\/Set_(abstract_data_type)\n    - https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Set\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u300c\u8907\u6570\u884c\u30c6\u30ad\u30b9\u30c8\u300d\u304c\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\n    - \u6b63\u9806\u30e2\u30fc\u30c9\uff08Forward mode\uff09\u306e\u5834\u5408\u3001\u6700\u521d\u306b\u51fa\u73fe\u3057\u305f\u884c\u304c\u4fdd\u6301\u3055\u308c\u30012\u56de\u76ee\u4ee5\u964d\u306b\u51fa\u73fe\u3059\u308b\u884c\u306f\u524a\u9664\u3055\u308c\u307e\u3059\u3002\n- \u3082\u3057\u300c\u51fa\u529b\u30c6\u30ad\u30b9\u30c8\u300d\u304c\u7a7a\u306e\u5834\u5408\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306f\u3001\u7a7a\u6587\u5b57\u3067\u66f4\u65b0\u3055\u308c\u307e\u3059\u3002\n- \u3082\u3057\u300c\u524a\u9664\u884c\u300d\u304c\u7a7a\u306e\u5834\u5408\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306f\u3001\u7a7a\u6587\u5b57\u3067\u66f4\u65b0\u3055\u308c\u307e\u3059\u3002\nAppendix-ja:\n- `Set` \u3068\u306f\u3001\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3067\u7528\u3044\u3089\u308c\u308b\u62bd\u8c61\u30c7\u30fc\u30bf\u578b\u306e\u4e00\u7a2e\u3002\n    - \u9806\u5e8f\u306e\u306a\u3044\u30c7\u30fc\u30bf\u306e\u96c6\u307e\u308a\uff08\u6709\u9650\u96c6\u5408\uff09\u3092\u8868\u73fe\u3059\u308b\u62bd\u8c61\u30c7\u30fc\u30bf\u578b\u3002\n    - \u540c\u4e00\u306e\u30c7\u30fc\u30bf\u306f\u4e00\u3064\u3057\u304b\u542b\u307e\u308c\u306a\u3044\u3053\u3068\u304c\u4fdd\u8a3c\u3055\u308c\u308b\u3002\n    - https:\/\/w.wiki\/6DCr\n    - https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Set\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n