TSV String, Verify Rectangle<\/div>
Verifies that the cells are in a matrix format. If the number of cell values are different for each row, tabs will be added. It is also possible to get the number of rows and columns after formatting. No trailing newline will be added to the verified TSV.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> A1: Set TSV *<\/span>#{EL}<\/sup><\/span><\/li>\n
- B1: Select STRING DATA that stores Output TSV (update)<\/li>\n
- B2: Select NUMERIC DATA that stores Number of Rows (update)<\/li>\n
- B3: Select NUMERIC DATA that stores Number of Columns (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\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 strTsv = configs.get( "StrConfA1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\n if( strTsv === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: Tsv} is empty \\n" );\n }\n const arr2dTsv = parseAsRectangular( strTsv );\nconst strPocketOutput = configs.getObject( "SelectConfB1" ); \/\/ NotRequired \/\/\/\/\/\nconst numPocketNumOfRows = configs.getObject( "SelectConfB2" ); \/\/ NotRequired \/\/\/\/\/\nconst numPocketNumOfColumns = configs.getObject( "SelectConfB3" ); \/\/ 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 ==\n\n\/\/ output TSV\nlet strOutput = "";\nfor( let i = 0; i < arr2dTsv.length; i++ ){\n strOutput += arr2dTsv[i].join("\\t") + "\\n";\n}\nstrOutput = strOutput.slice( 0, -1 ); \/\/ delete last "\\n"\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( numPocketNumOfRows !== null ){\n engine.setData( numPocketNumOfRows, new java.math.BigDecimal( arr2dTsv.length ) );\n}\nif( numPocketNumOfColumns !== null ){\n engine.setData( numPocketNumOfColumns, new java.math.BigDecimal( arr2dTsv[0].length ) );\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/ Parses TSV string as two-dimensional rectangular data matrix and creates a 2D array.\nfunction parseAsRectangular( strTsv ){\n const arrTsv = strTsv.split("\\n");\n\n \/\/\/ Get numMinWidth and numMaxWidth (blank lines are excluded)\n let numMinWidth = Infinity; \/\/ cf. String-Type Max: 1 million\n let numMaxWidth = 0;\n let numBlanklines = 0;\n for( let i = 0; i < arrTsv.length; i++ ){\n if( arrTsv[i] === "" ){ \/\/ Skip blank lines\n numBlanklines += 1;\n continue;\n }\n let arrCells = arrTsv[i].split("\\t");\n if( numMinWidth > arrCells.length ){ numMinWidth = arrCells.length; }\n if( numMaxWidth < arrCells.length ){ numMaxWidth = arrCells.length; }\n }\n engine.log( " AutomatedTask TsvDataCheck:" + \n " MinWidth:" + numMinWidth +\n " MaxWidth:" + numMaxWidth +\n " Lines:" + arrTsv.length +\n " (BlankLines:" + numBlanklines + ")" );\n\n \/\/\/ Get numMinWidth and numMaxWidth (blank lines are excluded)\n let arr2dTsv = [];\n for( let i = 0; i < arrTsv.length; i++ ){\n if( arrTsv[i] === "" ){ \/\/ Skip blank lines\n continue;\n }\n let arrTmp = [];\n let arrCells = arrTsv[i].split("\\t");\n for( let j = 0; j < numMaxWidth; j++ ){\n if( j < arrCells.length ){\n arrTmp[j] = arrCells[j];\n }else{\n arrTmp[j] = "";\n }\n }\n arr2dTsv.push( arrTmp );\n }\n\n return arr2dTsv;\n}\n\n\/*\nNotes:\n- When the process reaches this automated task, TSV is automatically read.\n - TSV: Monthly sales, monthly access log, etc.\n- If there is a blank line in the input TSV text, it will be skipped.\n - The output TSV is rectangular data. There are no blank lines.\n - No line feed code is added to the last line of the output TSV.\n\nAPPENDIX:\n- TSV data that is not rectangular is automatically formatted with an empty string.\n - Tabs are added according to the row with the largest number of columns.\n - However, lines with only line breaks (blank lines) are skipped.\n\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308bTSV\u304c\u81ea\u52d5\u7684\u306b\u8aad\u307f\u8fbc\u307e\u308c\u307e\u3059\u3002\n - TSV: \u6708\u6b21\u58f2\u4e0a\u3001\u6708\u6b21\u30a2\u30af\u30bb\u30b9\u30ed\u30b0\u3001\u306a\u3069\n- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306b\u7a7a\u884c\u304c\u3042\u308b\u5834\u5408\u3001\u30b9\u30ad\u30c3\u30d7\u3055\u308c\u307e\u3059\u3002\n - \u51fa\u529bTSV\u306f\u77e9\u5f62\u30c7\u30fc\u30bf\u3068\u306a\u308a\u307e\u3059\u3002\u7a7a\u884c\u306f\u5b58\u5728\u3057\u307e\u305b\u3093\u3002\n - \u51fa\u529bTSV\u306e\u6700\u7d42\u884c\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u4ed8\u4e0e\u3055\u308c\u307e\u305b\u3093\u3002\n\nAPPENDIX-ja:\n- \u77e9\u5f62\u3067\u306a\u3044TSV\u30c7\u30fc\u30bf\u306f\u3001\u7a7a\u6587\u5b57\u306b\u3088\u3063\u3066\u81ea\u52d5\u6574\u5f62\u3055\u308c\u307e\u3059\u3002\n - \u3082\u3063\u3068\u3082\u5217\u6570\uff08\u30bf\u30d6\u6570\uff09\u304c\u591a\u3044\u884c\u306b\u3042\u308f\u305b\u3066\u3001\u30bf\u30d6\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002\n - \u305f\u3060\u3057\u3001\u6539\u884c\u306e\u307f\u306e\u884c\uff08\u7a7a\u884c\uff09\u306f\u3001\u30b9\u30ad\u30c3\u30d7\u3055\u308c\u307e\u3059\u3002\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- Tsv-String-Verify-Rectangle-2021.xml<\/a>\n
- \n
- 2021-09-05 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Tsv-String-Verify-Rectangle-2023.xml<\/a>\n
- \n
- 2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
The Add-on import feature is available with Professional<\/strong><\/span> edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- When the process reaches this automated task, TSVs stored in String-type data will be read automatically.\n
- \n
- TSV: monthly sales, monthly access log, etc.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- If there is a blank line in the input TSV text, it will be skipped.\n
- \n
- The output TSV will be rectangular data. There are no blank lines.<\/li>\n\n\n\n
- No line feed code is added to the last line of the output TSV.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Verifies](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-verify-rectangle-2021-capture-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"Verifies](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-verify-rectangle-2021-config-en-913x630.png?resize=913%2C630&ssl=1\")
<\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- \n
- TSV data that is not rectangular is automatically formatted with an empty string.\n
- \n
- Tabs are added according to the row with the largest number of columns.<\/li>\n\n\n\n
- However, lines with only line breaks (blank lines) are skipped.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> See also<\/h3>\n\n\n\n
- TSV data that is not rectangular is automatically formatted with an empty string.\n
- When the process reaches this automated task, TSVs stored in String-type data will be read automatically.\n