{"id":175014,"date":"2025-07-16T16:53:58","date_gmt":"2025-07-16T07:53:58","guid":{"rendered":"https:\/\/support.questetra.com\/?p=175014"},"modified":"2025-07-22T14:44:16","modified_gmt":"2025-07-22T05:44:16","slug":"tsv-string-add-thousands-separators-2025","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-thousands-separators-2025\/","title":{"rendered":"#TSV-String: Add Thousands Separators"},"content":{"rendered":"\n

#TSV-String: Add Thousands Separators<\/strong><\/h4>\n\n\n\n

translate<\/span> #TSV\u6587\u5b57\u5217: \u6841\u533a\u5207\u308a\u8a18\u53f7\u306e\u8ffd\u52a0<\/a><\/p>\n\n\n\n

Formats the specified range of columns from START index to END index of the TSV (END not included). The index starts from “0”. Negative index counts back from the end. If START is omitted, it will start from the beginning, if END is omitted, it will go to 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
OptionConfB0<\/dt>
B0: Select Thousands Separator *<\/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]\n\n\nconst strSeparator  = configs.get        ( "OptionConfB0" );   \/\/\/ REQUIRED (SELECT_ITEM)\n  \/\/ "comma", "dot", "space"\n\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  engine.log( " AutomatedTask Runtime: StartIndex auto-set as " + numStartIndex );\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  engine.log( " AutomatedTask Runtime: EndIndex auto-set as " + numEndIndex );\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 arrRow = arr2dTsv[i];   \/\/ \u5143\u306e\u884c\u30c7\u30fc\u30bf\n  let arrOutputRow = [];\n\n  for ( let j = 0; j < arrRow.length; j++ ) {      \/\/ Determine whether the column is to be processed\n    if (j >= numStartIndex && j < numEndIndex) {   \/\/ The column to be processed is separated by thousands.\n      let processedValue = arrRow[j];\n      if (strSeparator === "comma") {\n        processedValue = processedValue.replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1,');\n      } else if (strSeparator === "dot") {\n        processedValue = processedValue\n          .replace(\/(\\d)\\.(?=\\d)\/g, '$1,')   \/\/ Temporarily change the decimal point to a comma\n          .replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1.')   \/\/ Dot separator\n          .replace(\/(\\d),(\\d)\/g, '$1.$2');   \/\/ Convert a temporary comma back to a dot\n      } else if (strSeparator === "space") {\n        processedValue = processedValue\n          .replace(\/(\\d)\\.(?=\\d)\/g, '$1,')   \/\/ Temporarily change the decimal point to a comma\n          .replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1 ')   \/\/ Digit separator to space\n          .replace(\/(\\d),(\\d)\/g, '$1.$2');   \/\/ Convert a temporary comma back to a dot\n      }\n      arrOutputRow.push(processedValue);\n    } else {\n      arrOutputRow.push(arrRow[j]);      \/\/ For columns not subject to processing, the original values are used as is.\n    }\n  }\n  arrOutputTsv.push(arrOutputRow.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 "Formatting" is automatically executed.\n    - Helps improve the visibility of numerical data.\n    - Convenient for pre-processing of data sharing (such as email sending, posting to CollabChat, etc.)\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 start up to the last column of the TSV.\n- Detects numbers with more than three digits in the Cell text.\n    - Adds thousand separator to each number.\n    - A comma, dot, or space can be specified as the digit separator.\n    - Note that this replacement will also be applied to decimals, postal codes and years.\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\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u51e6\u7406\u300d\u304c\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u307e\u3059\n    - \u6570\u5024\u30c7\u30fc\u30bf\u306e\u8996\u8a8d\u6027\u3092\u5411\u4e0a\u3055\u305b\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\n    - \u30c7\u30fc\u30bf\u5171\u6709\uff08\u30e1\u30fc\u30eb\u9001\u4fe1\u3084CollabChat\u3078\u306e\u81ea\u52d5\u6295\u7a3f\u306a\u3069\uff09\u306e\u524d\u51e6\u7406\u3068\u3057\u3066\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- \u5404\u30bb\u30eb\u30c6\u30ad\u30b9\u30c8\u4e2d\u306e4\u6841\u4ee5\u4e0a\u6570\u5024\uff08\u6570\u5b574\u9023\u7d9a\u4ee5\u4e0a\uff09\u3092\u691c\u51fa\u3057\u307e\u3059\n    - \u5404\u6570\u5024\u306b\u5bfe\u3057\u3066\u30b1\u30bf\u533a\u5207\u8a18\u53f7\u3092\u4ed8\u4e0e\u3057\u307e\u3059\n    - \u6841\u533a\u5207\u308a\u8a18\u53f7\u306b\u306f\u3001\u30ab\u30f3\u30de\u3001\u30c9\u30c3\u30c8\u3082\u3057\u304f\u306f\u30b9\u30da\u30fc\u30b9\u304c\u6307\u5b9a\u53ef\u80fd\u3067\u3059\n    - \u3053\u306e\u81ea\u52d5\u5909\u63db\u306f\u3001\u5c0f\u6570\u90e8\u3084\u90f5\u4fbf\u756a\u53f7\u3084\u5e74\u53f7\u306b\u3082\u9069\u7528\u3055\u308c\u3066\u3057\u307e\u3046\u70b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\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- Examples:\n    - Input: `$12345678.90`\n    - Output: `$12,345,678.90`\n    - Input: `\u20ac12345.00`\n    - Output: `\u20ac12,345.00`\n    - Input: `12345678.90123`\n    - Output: `12,345,678.90,123` (not good)\n    - Input: `0120-345-678`\n    - Output: `0,120-345-678` (not good)\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- Examples:\n    - Input: `$12345678.90`\n    - Output: `$12,345,678.90`\n    - Input: `\u20ac12345.00`\n    - Output: `\u20ac12,345.00`\n    - Input: `12345678.90123`\n    - Output: `12,345,678.90,123` (\u597d\u307e\u3057\u304f\u306a\u3044\u4f8b)\n    - Input: `0120-345-678`\n    - Output: `0,120-345-678` (\u597d\u307e\u3057\u304f\u306a\u3044\u4f8b)\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n