Converter: TSV-String to Table<\/div>
Converts a TSV String to Table-type data. The string values of all cells in the TSV string are copied over to Table-type data B. If there is an inconsistency in the Table column design, an error may occur.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> A: Set TSV String *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B: Select TABLE DATA (update)<\/li>\n
- <\/i><\/span> B2: Select TABLE DATA (append)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\/\/ \n\/\/ Notes:\n\/\/ Copies text information of all cell values.\n\/\/ Copies in the display order of the column. (Does not depend on column ID)\n\/\/ If the number of columns decreases, the right columns will not be copied.\n\/\/ If the number of columns increases, blank strings will be completed.\n\/\/ For Numeric-column, the period "." is recognized as a decimal point.\n\/\/ For Numeric-column, the comma "," is recognized as a thousand separator.\n\/\/ For Select-column, the value must be choice ID. (Otherwise, not copied)\n\/\/ Auto-calculated columns are reevaluated. (Not always the same value)\n\/\/ To add data without erasing already stored cell data, use B2.\n\/\/\n\/\/ Notes (ja):\n\/\/ \u5168\u3066\u306e\u30bb\u30eb\u5024\u306e\u6587\u5b57\u60c5\u5831\u3092\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002\n\/\/ \u30ab\u30e9\u30e0\u306e\u8868\u793a\u9806\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002\uff08\u30ab\u30e9\u30e0ID\u306b\u4f9d\u3089\u306a\u3044\uff09\n\/\/ \u30ab\u30e9\u30e0\u5217\u6570\u304c\u5c11\u306a\u304f\u306a\u308b\u5834\u5408\u306f\u3001\u53f3\u5217\u90e8\u304c\u30ab\u30c3\u30c8\u3055\u308c\u307e\u3059\u3002\n\/\/ \u30ab\u30e9\u30e0\u5217\u6570\u304c\u5897\u3048\u308b\u5834\u5408\u306f\u3001\u7a7a\u767d\u6587\u5b57\u5217\u3067\u88dc\u5b8c\u3055\u308c\u307e\u3059\u3002\n\/\/ \u6570\u5024\u30ab\u30e9\u30e0\u3078\u306e\u5024\u30b3\u30d4\u30fc\u306f\u3001\u30d4\u30ea\u30aa\u30c9 "." \u3092\u5c0f\u6570\u70b9\u3068\u3057\u3066\u8a8d\u8b58\u3057\u3066\u4ee3\u5165\u3057\u307e\u3059\u3002\n\/\/ \u6570\u5024\u30ab\u30e9\u30e0\u3078\u306e\u5024\u30b3\u30d4\u30fc\u306f\u3001\u6841\u533a\u5207\u308a\u6587\u5b57 "," \u304c\u5b58\u5728\u3057\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002\n\/\/ \u9078\u629e\u30ab\u30e9\u30e0\u3078\u306e\u5024\u30b3\u30d4\u30fc\u306f\u3001\u9078\u629e\u80a2ID\u3067\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002\uff08\u30b3\u30d4\u30fc\u3055\u308c\u307e\u305b\u3093\uff09\n\/\/ \u81ea\u52d5\u8a08\u7b97\u30ab\u30e9\u30e0\u306f\u3001\u518d\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\uff08\u5fc5\u305a\u3057\u3082\u540c\u3058\u5024\u306b\u306a\u308a\u307e\u305b\u3093\uff09\n\/\/ \u65e2\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u30c7\u30fc\u30bf\u3092\u6d88\u3055\u305a\u306b\u8ffd\u8a18\u3057\u305f\u3044\u5834\u5408\u306f\u3001B2\u3092\u3054\u5229\u7528\u304f\u3060\u3055\u3044\u3002\n\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( "conf_StrTsv" ) + ""; \/\/ required\nconst dataIdB = configs.get( "conf_DataIdB" ) + ""; \/\/ not required\nconst dataIdB2 = configs.get( "conf_DataIdB2" ) + ""; \/\/ not required\n\/\/ 'java.lang.String' to javascript primitive 'string'\n\nif( strTsv === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " TSV String {A} is empty \\n" );\n}\n\nlet outputTable1 = null;\nlet outputTable1ProcessDataDefinitionView = null;\nlet outputTable1DataDefinition = null;\nlet numColsB = 0;\nif( dataIdB !== "" ){\n outputTable1ProcessDataDefinitionView = engine.findDataDefinitionByNumber( dataIdB ); \/\/ com.questetra.bpms.core.event.scripttask.ProcessDataDefinitionView\n outputTable1DataDefinition = outputTable1ProcessDataDefinitionView.getSubDataDefinitions(); \/\/ java.util.List<com.questetra.bpms.core.event.scripttask.SubDataDefinitionView>\n outputTable1 = outputTable1ProcessDataDefinitionView.createListArray(); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray\n numColsB = outputTable1DataDefinition.size() - 0;\n engine.log( " AutomatedTask TableConfig:" +\n " #of {B}-Columns Definition: " + numColsB );\n}\n\nlet outputTable2 = null;\nlet outputTable2ProcessDataDefinitionView = null;\nlet outputTable2DataDefinition = null;\nlet numColsB2 = 0;\nif( dataIdB2 !== "" ){\n outputTable2ProcessDataDefinitionView = engine.findDataDefinitionByNumber( dataIdB2 ); \/\/ com.questetra.bpms.core.event.scripttask.ProcessDataDefinitionView\n outputTable2DataDefinition = outputTable2ProcessDataDefinitionView.getSubDataDefinitions(); \/\/ java.util.List<com.questetra.bpms.core.event.scripttask.SubDataDefinitionView>\n outputTable2 = engine.findDataByNumber( dataIdB2 ); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray\n if( outputTable2 === null ){\n outputTable2 = outputTable1ProcessDataDefinitionView.createListArray();\n }\n numColsB2 = outputTable2DataDefinition.size() - 0;\n engine.log( " AutomatedTask TableConfig:" +\n " #of {B2}-Columns Definition: " + numColsB2 );\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (nothing)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet twoDimArrayA = []; \/\/ for TSV-A\nconst arrTsv = strTsv.split("\\n");\nengine.log( " AutomatedTask MultilineString:" + \n " TSV {A}, number of lines " + arrTsv.length );\nfor( let i = 0; i < arrTsv.length; i++ ){\n twoDimArrayA[i] = arrTsv[i].split("\\t");\n}\n\nif( dataIdB !== ""){\n for( let i = 0; i < arrTsv.length; i++ ){\n let tmpRow = outputTable1.addRow(); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray.ScriptListRow\n if( twoDimArrayA[i].length < numColsB ){\n for( let j = 0; j < twoDimArrayA[i].length; j++ ){\n const tmpCol = outputTable1DataDefinition.get(j); \/\/ com.questetra.bpms.core.event.scripttask.SubDataDefinitionView\n if( tmpCol.matchDataType("DECIMAL") ){\n twoDimArrayA[i][j] = twoDimArrayA[i][j].replace( \/,\/g, "" );\n }\n tmpRow.setCol( j, twoDimArrayA[i][j] );\n }\n for( let k = twoDimArrayA[i].length; k < numColsB; k++ ){\n tmpRow.setCol( k, "" ); \/\/ Fill with empty characters\n }\n }\n if( twoDimArrayA[i].length >= numColsB ){\n for( let j = 0; j < numColsB; j++ ){\n const tmpCol = outputTable1DataDefinition.get(j); \/\/ com.questetra.bpms.core.event.scripttask.SubDataDefinitionView\n if( tmpCol.matchDataType("DECIMAL") ){\n twoDimArrayA[i][j] = twoDimArrayA[i][j].replace( \/,\/g, "" );\n }\n tmpRow.setCol( j, twoDimArrayA[i][j] );\n }\n }\n engine.log( " AutomatedTask:" +\n " Add B[" + i + "]" );\n }\n}\n\nlet numOriginLines = 0;\nif( dataIdB2 !== ""){\n if( outputTable2 !== null ){\n numOriginLines = outputTable2.size() - 0;\n }\n engine.log( " AutomatedTask:" +\n " #of {B2}-Rows: " + numOriginLines );\n\n for( let i = 0; i < arrTsv.length; i++ ){\n let tmpRow = outputTable2.addRow(); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray.ScriptListRow\n if( twoDimArrayA[i].length < numColsB2 ){\n for( let j = 0; j < twoDimArrayA[i].length; j++ ){\n const tmpCol = outputTable2DataDefinition.get(j); \/\/ com.questetra.bpms.core.event.scripttask.SubDataDefinitionView\n if( tmpCol.matchDataType("DECIMAL") ){\n twoDimArrayA[i][j] = twoDimArrayA[i][j].replace( \/,\/g, "" );\n }\n tmpRow.setCol( j, twoDimArrayA[i][j] );\n }\n for( let k = twoDimArrayA[i].length; k < numColsB2; k++ ){\n tmpRow.setCol( k, "" ); \/\/ Fill with empty characters\n }\n }\n if( twoDimArrayA[i].length >= numColsB2 ){\n for( let j = 0; j < numColsB2; j++ ){\n const tmpCol = outputTable2DataDefinition.get(j); \/\/ com.questetra.bpms.core.event.scripttask.SubDataDefinitionView\n if( tmpCol.matchDataType("DECIMAL") ){\n twoDimArrayA[i][j] = twoDimArrayA[i][j].replace( \/,\/g, "" );\n }\n tmpRow.setCol( j, twoDimArrayA[i][j] );\n }\n }\n engine.log( " AutomatedTask:" +\n " Add B2[" + (numOriginLines + i) + "]" );\n }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( dataIdB !== "" ){\n engine.setDataByNumber( dataIdB, outputTable1 );\n}\nif( dataIdB2 !== "" ){\n engine.setDataByNumber( dataIdB2, outputTable2 );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\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
- Converter-Tsv-String-to-Table-2021.xml<\/a><\/li>\n<\/ul>\n\n\n\n
2021-08-05 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/converter-tsv-string-to-table-2021\/<\/a>
<\/i> The Add-on import feature is available with Professional<\/strong><\/span> edition.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- Copies text information of all cell values.<\/li>\n\n\n\n
- Copies the columns in the order in which they are displayed (does not depend on the column ID\/field name).<\/li>\n\n\n\n
- If the number of columns decreases, the right columns will not be copied.<\/li>\n\n\n\n
- If the number of columns increases, they will be completed with blank strings.<\/li>\n\n\n\n
- For Numeric columns periods are recognized as a decimal point.<\/li>\n\n\n\n
- For Numeric columns commas are recognized as a thousand separator.<\/li>\n\n\n\n
- For Select columns the copied value must be the Choice ID (otherwise nothing is copied).<\/li>\n\n\n\n
- Auto-calculated columns are re-evaluated (not always to the same value).<\/li>\n\n\n\n
- To add data without erasing existing cell data, use B2.<\/li>\n\n\n\n
- Please prepare the value of Excel-CSV in the following format according to the data type of the table type sub-item (column)\n
- \n
- String-type: (entered character string)<\/li>\n\n\n\n
- Numeric-type: Standard format (period as decimal point, no thousands separator)<\/li>\n\n\n\n
- Select-type: Choice ID<\/li>\n\n\n\n
- Date-type: yyyy-mm-dd<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- If the format does not match, or if the specified value does not satisfy the input check contents, a processing error will result<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/converter-tsv-to-table-en.png?ssl=1\")
<\/figure>\n\n\n\n![\"Converts](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?fit=1024%2C576&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n
- <\/i><\/span> B: Select TABLE DATA (update)<\/li>\n