TSV String; Multiply N by Number Column<\/div>
Generates a new TSV string by multiplying N by each number in the number column. Calculation results are rounded off and added at the end of the line. This can be used for tax calculations, etc. Removes whitespace from both ends of a TSV string.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- A: Select STRING DATA for TSV Text *<\/span><\/li>\n
- <\/i><\/span> B: Set ID of Numeric Column to be multiplied (e.g. “0”, “3”) *<\/span><\/li>\n
- <\/i><\/span> C: Set Value to multiply (e.g. “1.1”, “1.0185185185”) *<\/span><\/li>\n
- D: Select STRING DATA for New TSV Text (update) *<\/span><\/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\/\/ (c) 2021, Questetra, Inc. (the MIT License)\n\n\/*\n=input tsv=\nA1\t10000\tC1\nA2\t10800\tC2\n=N=\n1.0185185185\n=output tsv=\nA1\t10000\tC1\t10185\nA2\t10800\tC2\t11000\n*\/\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA = configs.get( "conf_DataIdA" ) + ""; \/\/ config required\nconst columnB = configs.get( "conf_ColumnB" ) + ""; \/\/ config required\nconst valueC = configs.get( "conf_ValueC" ) + ""; \/\/ config required\nconst dataIdD = configs.get( "conf_DataIdD" ) + ""; \/\/ config required\n\/\/ 'java.lang.String' to javascript primitive 'string' by ""\n\nengine.log( " AutomatedTask Config: ID of Numeric Column " + columnB );\nengine.log( " AutomatedTask Config: Value to multiply " + valueC );\n\n\/\/ Design-time Config Format Check\nconst intColumnB = parseInt( columnB );\nif ( isNaN( intColumnB )){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {ID of Numeric Column} is not an integer \\n" );\n}\nconst numValueC = parseFloat( valueC );\nif ( isNaN( numValueC )){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {Value to multiply} is not a number \\n" );\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ Run-time Data Format Check\nif( engine.findDataByNumber( dataIdA ) === null ){\n throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n " String {A} as TSV is null \\n" );\n}\nconst inputText = (engine.findDataByNumber( dataIdA ) + "").trim();\nif( inputText === "" ){\n throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n " String {A} as TSV is empty \\n" );\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet outputText = "";\nconst arrInputText = inputText.split("\\n");\nengine.log( " AutomatedTask MultilineString:" + \n " String {A} as TSV, number of lines " + arrInputText.length );\n\nfor( let i = 0; i < arrInputText.length; i++ ){\n let arrCellValues = arrInputText[i].split("\\t");\n let strValueB = arrCellValues[ intColumnB ];\n let numValueB = parseFloat( strValueB );\n \/\/ Run-time Data Format Check\n if ( isNaN( numValueB )){\n throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n " String {A} as TSV, Specified Column is not numeric at " + i + "\\n" );\n }\n let newValue = Math.round( numValueB * numValueC );\n outputText += arrInputText[i] + "\\t" + newValue;\n if( i !== arrInputText.length - 1 ){\n outputText += "\\n";\n }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setDataByNumber( dataIdD, outputText );\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
- Tsv-String-Multiply-N-by-Number-Column-2021.xml<\/a><\/li>\n\n\n\n
- Tsv-String-Multiply-N-by-Number-Column-202107.xml<\/a> (Deletes only newline characters at both ends of a string.)\n
- \n
- \/\/const inputText = (engine.findDataByNumber( dataIdA ) + “”).trim();<\/li>\n\n\n\n
- const inputText = (engine.findDataByNumber( dataIdA ) + “”).replace(\/^[\\n]*\/, “”).replace(\/[\\n]*$\/, “”);<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
2021-07-15 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/tsv-string-multiply-n-by-number-column-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> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/tsv-string-multiply-2021-en.png?ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-Tsv-String-Multiply-N-by-Number-Column-en.png?resize=960%2C540&ssl=1\")
<\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n
- Tsv-String-Multiply-N-by-Number-Column-202107.xml<\/a> (Deletes only newline characters at both ends of a string.)\n
- <\/i><\/span> B: Set ID of Numeric Column to be multiplied (e.g. “0”, “3”) *<\/span><\/li>\n