{"id":174802,"date":"2025-07-10T15:51:11","date_gmt":"2025-07-10T06:51:11","guid":{"rendered":"https:\/\/support.questetra.com\/?p=174802"},"modified":"2025-07-16T13:56:43","modified_gmt":"2025-07-16T04:56:43","slug":"tsv-string-extract-range-columns-2025","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-extract-range-columns-2025\/","title":{"rendered":"#TSV-String: Extract Range Columns"},"content":{"rendered":"\n

#TSV-String: Extract Range Columns<\/strong><\/h4>\n\n\n\n

translate<\/span> #TSV\u6587\u5b57\u5217: \u7bc4\u56f2\u5217\u306e\u62bd\u51fa<\/a><\/p>\n\n\n\n

Extracts the specified range of columns from the START column to just before the END column of the TSV (END is not included). The index starts from “0”. Negative indexes are counted backwards from the end. If START is omitted, it will start from the beginning, and if END is omitted, it will finish at the end.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: Set Input TSV String *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB1<\/dt>
B1: Set Start-Index (Col-A: “0”, Col-C: “2”, Last-Col: “-1”)#{EL}<\/sup><\/span><\/dd>\n
StrConfB2<\/dt>
B2: Set END-Index (Col-A: “0”, Col-C: “2”, Last-Col: “-1”)#{EL}<\/sup><\/span><\/dd>\n
SelectConfC<\/dt>
C: Select STRING DATA to store Output TSV (update) *<\/span><\/dd>\n<\/div>\n
SelectConfInY<\/dt>
InY: Select NUMERIC for Number of Input TSV Lines (update)<\/dd>\n
SelectConfInX<\/dt>
InX: Select NUMERIC for Number of Input TSV Cols (update)<\/dd>\n
SelectConfOutY<\/dt>
OutY: Select NUMERIC for Number of Output TSV Lines (update)<\/dd>\n
SelectConfOutX<\/dt>
OutX: Select NUMERIC for Number of Output TSV Cols (update)<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ Script Example of Business Process Automation\n\/\/ for 'engine type: 3' ("GraalJS standard mode")\n\/\/ cf. 'engine type: 2' ("GraalJS Nashorn compatible mode") (renamed from "GraalJS" at 20230526)\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        ( "StrConfA" );       \/\/ REQUIRED\n  if( strTsv === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A: TSV} is empty \\n" );\n  }\n  const arr2dTsv    = parseAsRectangular ( strTsv );           \/\/ as arr2dTSV[Y][X]\nconst strStartIndex = configs.get        ( "StrConfB1" );      \/\/ not required\n  let numStartIndex = Number( strStartIndex );\n  if ( isNaN(numStartIndex) ) {\n    numStartIndex = 0;\n  } else if ( numStartIndex < 0 ) {\n    numStartIndex = arr2dTsv[0].length + numStartIndex;\n  }\n  if( arr2dTsv[0].length <= numStartIndex ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Start-Index must be less than the number of columns. \\n" );\n  }\nconst strEndIndex   = configs.get        ( "StrConfB2" );      \/\/ not required\n  let numEndIndex = strEndIndex.trim() === "" ? NaN : Number( strEndIndex );\n  if ( isNaN(numEndIndex) ) {\n    numEndIndex = arr2dTsv[0].length;\n  } else if ( numEndIndex < 0 ) {\n    numEndIndex = arr2dTsv[0].length + numEndIndex;\n  }\n  if( numEndIndex <= numStartIndex ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Start-Index must be less than End-Index. \\n" );\n  }\nconst strPocketC    = configs.getObject ( "SelectConfC" );     \/\/ REQUIRED\nconst numPocketInY  = configs.getObject ( "SelectConfInY" );   \/\/ not required\nconst numPocketInX  = configs.getObject ( "SelectConfInX" );   \/\/ not required\nconst numPocketOutY = configs.getObject ( "SelectConfOutY" );  \/\/ not required\nconst numPocketOutX = configs.getObject ( "SelectConfOutX" );  \/\/ not required\n\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\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet arrOutputTsv  = [];\n\nfor ( let i = 0; i < arr2dTsv.length; i++ ) {\n  let arrTmp = arr2dTsv[i].slice( numStartIndex, numEndIndex );\n  arrOutputTsv.push ( arrTmp.join( '\\t' ) );\n}\n\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\/\/\/ ref) Retrieving \/ Updating from ScriptTasks\n\/\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574771-R2301\n\/\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574771-R2301\n\nif ( strPocketC !== null ){ \n  engine.setData( strPocketC, arrOutputTsv?.join( '\\n' ) ?? "" );\n}\n\nif ( numPocketInY !== null ){ \n  engine.setData( numPocketInY, new java.math.BigDecimal( arr2dTsv.length ) );\n}\nif ( numPocketInX !== null ){ \n  engine.setData( numPocketInX, new java.math.BigDecimal( arr2dTsv[0].length ) );\n}\nif ( numPocketOutY !== null ){ \n  engine.setData( numPocketOutY, new java.math.BigDecimal( arrOutputTsv.length ) );\n}\nif ( numPocketOutX !== null ){ \n  engine.setData( numPocketOutX, new java.math.BigDecimal( arrOutputTsv[0].split("\\t").length ) );\n}\n\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\n\/**\n * Parses a TSV (Tab-Separated Values) string and returns a 2D array with rectangular shape.\n * This function ensures that each row in the resulting 2D array has the same number of columns,\n * equal to the widest row in the original TSV input. Shorter rows are padded with empty strings.\n * Blank lines in the input are ignored.\n * Additionally, the function logs the minimum and maximum column counts (excluding blank lines),\n * along with the total number of lines and count of blank lines.\n * \n * TSV\uff08\u30bf\u30d6\u533a\u5207\u308a\u5024\uff09\u5f62\u5f0f\u306e\u6587\u5b57\u5217\u3092\u89e3\u6790\u3057\u30012\u6b21\u5143\u306e\u914d\u5217\u3068\u3057\u3066\u6574\u5f62\u3057\u3066\u8fd4\u3057\u307e\u3059\u3002\n * \u5165\u529b\u3055\u308c\u305fTSV\u6587\u5b57\u5217\u3092\u884c\u5358\u4f4d\u3067\u5206\u5272\u3057\u3001\u5404\u884c\u306e\u30bb\u30eb\u6570\u3092\u305d\u308d\u3048\u3066\u300c\u9577\u65b9\u5f62\uff08\u77e9\u5f62\uff09\u300d\u306e\u5f62\u306b\u6574\u3048\u307e\u3059\u3002\n * \u6700\u3082\u30bb\u30eb\u6570\u304c\u591a\u3044\u884c\u306b\u5408\u308f\u305b\u3066\u3001\u30bb\u30eb\u6570\u304c\u8db3\u308a\u306a\u3044\u884c\u306b\u306f\u7a7a\u6587\u5b57\u5217\uff08""\uff09\u3092\u88dc\u5b8c\u3057\u307e\u3059\u3002\n * \u7a7a\u884c\uff08\u4e2d\u8eab\u304c\u7a7a\u306e\u884c\uff09\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n * \u307e\u305f\u3001\u6700\u5c0f\u5217\u6570\u30fb\u6700\u5927\u5217\u6570\u30fb\u5168\u4f53\u306e\u884c\u6570\u30fb\u7a7a\u884c\u306e\u6570\u3092\u30ed\u30b0\u306b\u51fa\u529b\u3057\u307e\u3059\uff08engine.log\uff09\u3002\n * \n * \n * @param {string} strTsv - The raw TSV string, with rows separated by newline characters (`\\n`) \n *                          and cells separated by tab characters (`\\t`).\n * \n * @returns {string[][]} A two-dimensional array where each sub-array represents a row from the TSV input,\n *                       padded with empty strings to ensure uniform column width.\n * \n * @example\n * const tsv = "a\\tb\\tc\\n1\\t2\\nx\\ty\\tz\\tw\\n";\n * const result = parseAsRectangular(tsv);\n * \/\/ result:\n * \/\/ [\n * \/\/   ["a", "b", "c", ""],\n * \/\/   ["1", "2", "", ""],\n * \/\/   ["x", "y", "z", "w"]\n * \/\/ ]\n *\/\n\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\n\n\/*\n### NOTES\n- When the process reaches this [Automated Step], the extraction is automatically executed.\n    - This is a convenient add-on automated step for automating subsequent processes such as data integration and data aggregation.\n- The specified column range (from the START index to just before the END index) is automatically extracted.\n    - The column index starts at "0" (counting from the beginning, first column is `0`).\n    - A negative value can also be set for the column index (counting from the end, last column is `-1`).\n    - If the START index is omitted, extraction will start from the first column of the TSV.\n    - If the END index is omitted, extraction will run up to the last column of the TSV.\n\n### NOTES-ja\n- \u6848\u4ef6\u30d7\u30ed\u30bb\u30b9\u304c\u3053\u306e\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001TSV\u30c6\u30ad\u30b9\u30c8\u304c\u8aad\u307f\u8fbc\u307e\u308c\u300c\u62bd\u51fa\u51e6\u7406\u300d\u304c\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u307e\u3059\n    - \u30c7\u30fc\u30bf\u9023\u643a\u3084\u30c7\u30fc\u30bf\u96c6\u8a08\u306a\u3069\u3001\u5f8c\u7d9a\u51e6\u7406\u306e\u81ea\u52d5\u5316\u3092\u884c\u3046\u969b\u306b\u4fbf\u5229\u306a\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\u3067\u3059\n- \u6307\u5b9a\u306e\u5217\u7bc4\u56f2\uff08START\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304b\u3089END\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u624b\u524d\u307e\u3067\uff09\u304c\u3001\u81ea\u52d5\u62bd\u51fa\u3055\u308c\u307e\u3059\n    - \u5217\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u300c0\u300d\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\uff08\u5148\u982d\u304b\u3089\u6570\u3048\u308b\uff0f\u5148\u982d\u5217\u306f `0`\uff09\n    - \u5217\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306b\u306f\u300c\u8ca0\u306e\u5024\u300d\u3082\u8a2d\u5b9a\u53ef\u80fd\u3067\u3059\uff08\u672b\u5c3e\u304b\u3089\u6570\u3048\u308b\uff0f\u672b\u5c3e\u5217\u306f `-1`\uff09\n    - START\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6307\u5b9a\u304c\u7701\u7565\u3055\u308c\u305f\u5834\u5408\u3001TSV\u306e\u6700\u521d\u306e\u5217\u304b\u3089\u62bd\u51fa\u3055\u308c\u307e\u3059\n    - END\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6307\u5b9a\u304c\u7701\u7565\u3055\u308c\u305f\u5834\u5408\u3001TSV\u306e\u6700\u5f8c\u306e\u5217\u307e\u3067\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\n\n### APPENDIX\n- TSV (Tab Separated Values) text is assumed to be rectangular data.\n    - TSV text: monthly sales summary, monthly access summary, PIVOT table, etc.\n    - Non-rectangular data is automatically formatted with an empty string (adjusted to the longest number of columns).\n    - Blank lines (including trailing newlines) are ignored.\n- Indexes:\n    - Indexes start from 0 (first column is `0`).\n    - For example, the third column from the left (so-called column C) has index `2`.\n    - Negative indexes are counted from the end (last column is `-1`).\n    - For example, the third column from the right has index `-3`.\n- The number of rows (height) and columns (width) of the input\/output TSV can be stored in Numeric data.\n- If the order of the output TSV columns should be changed, place a "TSV String, Convert" downstream in the workflow.\n    - https:\/\/support.questetra.com\/addons\/tsv-string-convert-2021\/\n\n### APPENDIX-ja\n- TSV\uff08Tab Separated Values\uff09\u30c6\u30ad\u30b9\u30c8\u306f\u3001\u77e9\u5f62\u30c7\u30fc\u30bf\u3092\u524d\u63d0\u3068\u3057\u307e\u3059\n    - TSV\u30c6\u30ad\u30b9\u30c8: \u6708\u6b21\u58f2\u4e0a\u96c6\u8a08\u3001\u6708\u6b21\u30a2\u30af\u30bb\u30b9\u96c6\u8a08\u3001PIVOT\u30c6\u30fc\u30d6\u30eb\u3001\u306a\u3069\n    - \u77e9\u5f62\u3067\u306a\u3044\u30c7\u30fc\u30bf\u306f\u3001\u7a7a\u6587\u5b57\u5217\u306b\u3088\u3063\u3066\u81ea\u52d5\u6574\u5f62\u3055\u308c\u307e\u3059\uff08\u6700\u3082\u9577\u3044\u5217\u6570\u306b\u5408\u308f\u305b\u308b\uff09\n    - \u7a7a\u884c\uff08\u672b\u5c3e\u6539\u884c\u3092\u542b\u3080\uff09\u306f\u7121\u8996\u3055\u308c\u307e\u3059\n- \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u7406\u89e3:\n    - \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f0\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\uff08\u5148\u982d\u5217\u306f `0`\uff09\n    - \u4f8b\u3048\u3070\u3001\u5de6\u304b\u30893\u756a\u76ee\u306e\u5217\uff08\u3044\u308f\u3086\u308bC\u5217\uff09\u306f\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9 `2` \u3068\u306a\u308a\u307e\u3059\n    - \u8ca0\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u672b\u5c3e\u304b\u3089\u6570\u3048\u307e\u3059\uff08\u672b\u5c3e\u5217\u306f `-1`\uff09\n    - \u4f8b\u3048\u3070\u3001\u53f3\u304b\u30893\u756a\u76ee\u306e\u5217\u306f\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9 `-3` \u3068\u306a\u308a\u307e\u3059\n- \u30a4\u30f3\u30d7\u30c3\u30c8TSV\u304a\u3088\u3073\u30a2\u30a6\u30c8\u30d7\u30c3\u30c8TSV\u306e\u884c\u6570\uff08\u9ad8\u3055\uff09\u3068\u5217\u6570\uff08\u5e45\uff09\u3092\u6570\u5024\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u683c\u7d0d\u3067\u304d\u307e\u3059\n- \u51fa\u529bTSV\u5217\u306e\u4e26\u3073\u9806\u304c\u5909\u66f4\u3055\u308c\u308b\u3079\u304d\u306a\u3089\u3001\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u4e0b\u6d41\u306b\u300eTSV \u6587\u5b57\u5217, \u5909\u63db\u300f\u3092\u914d\u7f6e\u3057\u307e\u3059\n    - https:\/\/support.questetra.com\/ja\/addons\/tsv-string-convert-2021\/\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n