{"id":84857,"date":"2020-02-28T17:13:19","date_gmt":"2020-02-28T08:13:19","guid":{"rendered":"https:\/\/support.questetra.com\/?p=84857"},"modified":"2021-08-06T15:01:29","modified_gmt":"2021-08-06T06:01:29","slug":"converter-tsv-string-to-table","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table\/","title":{"rendered":"Converter: TSV-String to Table"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF4CC;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table-2021\/\">https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Converter: TSV-String to Table<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">\n\n\n\n<p class=\"wp-block-paragraph\">Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2020-02-27 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table\/\">https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table\/<\/a><\/p>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul\">\n<li> A: Set TSV String<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> B: Select TABLE DATA (update)<\/li>\n<li> B2: Select TABLE DATA (append)<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ Nashorn Script (engine type: 1)\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}\nlet numColsB = 0;\nif( dataIdB !== \"\" ){\n  numColsB  = engine.findDataDefinitionByNumber( dataIdB )\n                    .getSubDataDefinitions().size() - 0;\n  engine.log( \" AutomatedTask TableConfig:\" +\n              \" #of {B}-Columns Definition: \" + numColsB );\n}\nlet numColsB2 = 0;\nif( dataIdB2 !== \"\" ){\n  numColsB2  = engine.findDataDefinitionByNumber( dataIdB2 )\n                     .getSubDataDefinitions().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 = &#091;]; \/\/ 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 &lt; arrTsv.length; i++ ){\n  twoDimArrayA&#091;i] = arrTsv&#091;i].split(\"\\t\");\n}\n\nlet outputTable1 = new com.questetra.bpms.core.model.formdata.ListArray();\nif( dataIdB !== \"\" ){\n  for( let i = 0; i &lt; arrTsv.length; i++ ){\n    let tmpRow = new com.questetra.bpms.core.model.formdata.ListArray.ListRow();\n    if( twoDimArrayA&#091;i].length &lt; numColsB ){\n      for( let j = 0; j &lt; twoDimArrayA&#091;i].length; j++ ){\n        if( engine.findDataDefinitionByNumber( dataIdB )\n                  .getSubDataDefinitions()\n                  .get(j).matchDataType(\"DECIMAL\") ){\n          twoDimArrayA&#091;i]&#091;j] = twoDimArrayA&#091;i]&#091;j].replace( \/,\/g, \"\" );\n        }\n        tmpRow.addCol( twoDimArrayA&#091;i]&#091;j] );\n      }\n      for( let j = 0; j &lt; numColsB - twoDimArrayA&#091;i].length; j++ ){\n        tmpRow.addCol( \"\" ); \/\/ Fill with empty characters\n      }\n    }\n    if( twoDimArrayA&#091;i].length &gt;= numColsB ){\n      for( let j = 0; j &lt; numColsB; j++ ){\n        if( engine.findDataDefinitionByNumber( dataIdB )\n                  .getSubDataDefinitions()\n                  .get(j).matchDataType(\"DECIMAL\") ){\n          twoDimArrayA&#091;i]&#091;j] = twoDimArrayA&#091;i]&#091;j].replace( \/,\/g, \"\" );\n        }\n        tmpRow.addCol( twoDimArrayA&#091;i]&#091;j] );\n      }\n    }\n    outputTable1.addRow( tmpRow );\n    engine.log( \" AutomatedTask:\" +\n                \" Add B&#091;\" + i + \"]\" );\n  }\n}\n\nlet outputTable2 = new com.questetra.bpms.core.model.formdata.ListArray();\nlet numOriginLines = 0;\nif( dataIdB2 !== \"\" ){\n  if( engine.findDataByNumber( dataIdB2 ) !== null ){\n    outputTable2 = engine.findDataByNumber( dataIdB2 ); \n    numOriginLines = engine.findDataByNumber( dataIdB2 ).size() - 0;\n  }\n  engine.log( \" AutomatedTask:\" +\n              \" #of {B2}-Rows: \" + numOriginLines );\n\n  for( let i = 0; i &lt; arrTsv.length; i++ ){\n    let tmpRow = new com.questetra.bpms.core.model.formdata.ListArray.ListRow();\n    if( twoDimArrayA&#091;i].length &lt; numColsB2 ){\n      for( let j = 0; j &lt; twoDimArrayA&#091;i].length; j++ ){\n        if( engine.findDataDefinitionByNumber( dataIdB2 )\n                  .getSubDataDefinitions()\n                  .get(j).matchDataType(\"DECIMAL\") ){\n          twoDimArrayA&#091;i]&#091;j] = twoDimArrayA&#091;i]&#091;j].replace( \/,\/g, \"\" );\n        }\n        tmpRow.addCol( twoDimArrayA&#091;i]&#091;j] );\n      }\n      for( let j = 0; j &lt; numColsB2 - twoDimArrayA&#091;i].length; j++ ){\n        tmpRow.addCol( \"\" ); \/\/ Fill with empty characters\n      }\n    }\n    if( twoDimArrayA&#091;i].length &gt;= numColsB2 ){\n      for( let j = 0; j &lt; numColsB2; j++ ){\n        if( engine.findDataDefinitionByNumber( dataIdB2 )\n                  .getSubDataDefinitions()\n                  .get(j).matchDataType(\"DECIMAL\") ){\n          twoDimArrayA&#091;i]&#091;j] = twoDimArrayA&#091;i]&#091;j].replace( \/,\/g, \"\" );\n        }\n        tmpRow.addCol( twoDimArrayA&#091;i]&#091;j] );\n      }\n    }\n    outputTable2.addRow( tmpRow );\n    engine.log( \" AutomatedTask:\" +\n                \" Add B2&#091;\" + (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()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/code><\/pre>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACx0lEQVRYR8WXz0sUYRjHP5O0CLX+\nuHTIQ7sHIby0BdIh0EU6hwmd20Vx9mb9AUvlQQSRVhBq0WW3gxcFKzx4000kBKO2QNgSssgS6uDu\noQQJJt4ZZ3ecH+s4O+kLyy7s+z7fz\/PM87zPMxKnvKRj6afpBbpRiCDRAkQOzhdQKCEhvvMkeOnW\n7tEAWVrYZwi4B6qom1UCUgSYII747bhqAzwhxhkeH0PYLCTE48i8cCJwBnhKCkn13I+VQua+nSF7\ngDQ54K4fyhUbCjkSxM02rQD+en5YT2GChJpLlXUYQHvmWV89txq7bcyJKoCW7Vt1JJxb7hIBwnp1\nVAHSPAQeuLVSa99U1xTzW\/Msflt02vYIWdXDCCBKptkPgI07GzQFmhhcGXSCKCHTWgXQbrjnRvGe\niz20nWvzxJO8lqS9uZ3t39u1INRc0CJgk\/nCi47WDk8AxkOOEAcVoQGkyat3vGH5BbD3d4\/RwijD\nb4fNzrxCJqoDfAEuGXdMd03TeaHTUwRC50NqDgjx8Q\/jJN8k7ewUkLmqAyielBwOieiFg+Fa4tpJ\nGelIgODZIJnuDDt\/dhh67a41rN5aZfnHspPnVWwDgOURiF1CPBvN0hvqJfcxx8DKgH+BUnhPgohj\nEhrFG6QG1n6usVne9ASw9H2J3CfR3w4tQxLalOHszVn6wn0I8XpXppixRs9UhpaLaPLGJP2X+2ls\naKxXH1sAMFxE2l1guYqNEHOf51j4uuAJplgqsv5r3Xi2jKyNd0c2Ix1iZnPGzyS0aUZaOxbVYGlI\nY9fH2N3fZeTdiKcImA6VCRCytmOx61QHEh3zf45kUAm9LndyQyk8QyZmfoYnNZZbPK8dAf1fbVAR\nV5jXSakMxLy9mOgQWnWIUVp83IIIYfFqlqrv1cz8wEREFKJIRFBoQeKKukU0FokSCgUk8rU8dp8D\nflS8Cxv\/AFp57iGwqv7bAAAAAElFTkSuQmCC\" alt=\"\"\/><\/figure><\/div>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/a\/questetra.com\/file\/d\/1jn-ubC864WoZf_Ga-Fl04Opr1JNl0EE6\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Converter-Tsv-String-to-Table.xml (opens in a new tab)\">Converter-Tsv-String-to-Table.xml<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/converter-tsv-to-table.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"84860\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table\/attachment\/converter-tsv-string-to-table-capture-ja\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-title=\"Converter-TSV-String-to-Table-capture-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?fit=1024%2C576&amp;ssl=1\" alt=\"Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.\" class=\"wp-image-84860\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-capture-ja.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Copies text information of all cell values.<\/li><li>Copies in the display order of the column. (Does not depend on column ID)<\/li><li>If the number of columns decreases, the right columns will not be copied.<\/li><li>If the number of columns increases, blank strings will be completed.<\/li><li>For Numeric-column, the period &#8220;.&#8221; is recognized as a decimal point.<\/li><li>For Numeric-column, the comma &#8220;,&#8221; is recognized as a thousand separator.<\/li><li>For Select-column, the value must be choice ID. (Otherwise, not copied)<\/li><li>Auto-calculated columns are reevaluated. (Not always the same value)<\/li><li>To add data without erasing already stored cell data, use B2.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"1ONRoZvziH\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/\">TSV String; Re-order Columns<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cTSV String; Re-order Columns\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/embed\/#?secret=mf3ONBJEqn#?secret=1ONRoZvziH\" data-secret=\"1ONRoZvziH\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"MWdrYUYuHM\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/\">TSV String, Sort by Numeric<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cTSV String, Sort by Numeric\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/embed\/#?secret=ZLQHd2ZCuS#?secret=MWdrYUYuHM\" data-secret=\"MWdrYUYuHM\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.<\/p>\n","protected":false},"author":2,"featured_media":84858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[373,389],"faq_section":[],"class_list":["post-84857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-listarray","tag-tsv-csv"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":3,"uagb_excerpt":"Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-m4F","jetpack-related-posts":[{"id":84887,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-table-to-tsv-string\/","url_meta":{"origin":84857,"position":0},"title":"Converter: Table to TSV-String","author":"IMAMURA, Genichi","date":"2020-03-02","format":false,"excerpt":"Converts Table-type data to TSV String. The string value of all cells in the Table-type data is copied over TSV string B. Cells with no input are regarded as empty strings.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: Table to TSV-String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":84857,"position":1},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69663,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsvtotable\/","url_meta":{"origin":84857,"position":2},"title":"Converter (TSV to Table)","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Parses a tab delimited text (TSV) stored in a String type data item, and stores it in a Table type data item. *Note If the number of design columns (number of columns) of the table does not match with the number of TSV items, it results in an error. \u00a0In\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-table-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-table-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-table-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-table-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-table-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69064,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tabletotsv\/","url_meta":{"origin":84857,"position":3},"title":"Converter (Table to TSV)","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Converts the value of a Table type data item to the tab delimited format (TSV) and stores it in a String type data item","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82453,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-excelcsv-to-table\/","url_meta":{"origin":84857,"position":4},"title":"Converter (TSV File to Table type data)","author":"Shiho Tatsumi","date":"2024-08-01","format":false,"excerpt":"This item overwrites the value of a Table type data item with a contents of an Excel compatible CSV file (TSV UTF-16 LE with BOM) stored in a File type data item.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":71382,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-table-options\/","url_meta":{"origin":84857,"position":5},"title":"Converter (Table to Options)","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Convert IDs-Labels defined in Table data to two String type data items. (In order to base registration as Options XML, refer to two String type data from Select type data. Then, refer to the Select type data from [Service Task (Choices Update)].) *Note Columns in the table information A' must\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/84857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=84857"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/84857\/revisions"}],"predecessor-version":[{"id":111262,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/84857\/revisions\/111262"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/84858"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=84857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=84857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=84857"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=84857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}