{"id":187753,"date":"2026-06-23T16:09:20","date_gmt":"2026-06-23T07:09:20","guid":{"rendered":"https:\/\/support.questetra.com\/?p=187753"},"modified":"2026-06-23T16:26:52","modified_gmt":"2026-06-23T07:26:52","slug":"date-tsv-group-by-quarter-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/date-tsv-group-by-quarter-2026\/","title":{"rendered":"\u65e5\u4ed8 #TSV: \u56db\u534a\u671f\u96c6\u8a08"},"content":{"rendered":"\n

\u65e5\u4ed8 #TSV: \u56db\u534a\u671f\u96c6\u8a08<\/strong><\/h4>\n\n\n\n

translate<\/span> Date #TSV: Group by Quarter<\/a><\/p>\n\n\n\n

\u65e5\u4ed8TSV\u5185\u306e\u884c\u6570\u3092\u56db\u534a\u671f\u3054\u3068\u306b\u30ab\u30a6\u30f3\u30c8\u3057\u30012\u5217\u306eTSV\uff08”Q-202604~06″,”3″\uff09\u3068\u3057\u3066\u51fa\u529b\u3057\u307e\u3059\u3002\u6570\u5024\u5217\uff08\u4f8b\uff1a\u672c\u4f53\u4fa1\u683c, \u6d88\u8cbb\u7a0e\u984d\uff09\u3092\u542b\u3080\u5834\u5408\u3001\u305d\u306e\u6570\u5024\u3092\u56db\u534a\u671f\u5408\u8a08\uff08”Q-202604~06″,”3″,”12000″,”1200″\uff09\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\u306a\u304a\u3001Date \u5217\u306e\u5834\u6240\u306fA\u5217\uff08id=0\uff09\u306b\u9650\u3089\u305a\u3001\u4efb\u610f\u306e\u5217\u4f4d\u7f6e\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002\u307e\u305f Datetime \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u306a\u3063\u3066\u3044\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: \u5165\u529bTSV\u6587\u5b57\u5217\uff08\u65e5\u4ed8\u5217\u3092\u542b\u3080TSV\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB1<\/dt>
B1: \u65e5\u4ed8\u5217\u306eID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08A\u5217\u306f”0″\u3001B\u5217\u306f”1″\uff09 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB2<\/dt>
B2: \u5408\u8a08\u3059\u308b\u6570\u5024\u5217\u306eID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u4f8b: “1,2,4”\uff09#{EL}<\/sup><\/span><\/dd>\n
SelectConfC1<\/dt>
C1: \u30ab\u30a6\u30f3\u30c8\u884c\u6570\u306e\u51fa\u529b\u5f62\u5f0f *<\/span><\/dd>\n
StrConfC2<\/dt>
C2: FY\u65b9\u5f0f\u306b\u5909\u66f4\u3057\u305f\u3044\u5834\u5408\u3001\u6c7a\u7b97\u6708\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u4f8b: “3”; Q-202604~06 \u2192 FY2027-Q1\uff09#{EL}<\/sup><\/span><\/dd>\n
SelectConfC3<\/dt>
C3: \u30a2\u30a6\u30c8\u30d7\u30c3\u30c8TSV\u304c\u683c\u7d0d\u3055\u308c\u308b\u8907\u6570\u884c\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0) *<\/span><\/dd>\n<\/div>\n
SelectConfD1<\/dt>
D1: \u5165\u529bTSV\u884c\u6570\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfD2<\/dt>
D2: \u5165\u529bTSV\u884c\u6570\uff08\u7a7a\u884c\u3092\u7121\u8996\uff09\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfD3<\/dt>
D3: \u51fa\u529bTSV\u884c\u6570\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/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 );  \/\/ [row,col]\nconst strColIdDate   = configs.get( "StrConfB1" );            \/\/ REQUIRED\nconst strColIdsNum   = configs.get( "StrConfB2" );            \/\/ REQUIRED\nconst strCountFormat = configs.get( "SelectConfC1" );         \/\/ "Separate", "Merged", "Hidden"\nconst strFyMonth     = configs.get( "StrConfC2" );            \/\/ not required\nconst strPocketC3    = configs.getObject ( "SelectConfC3" );  \/\/ REQUIRED\nconst numPocketD1    = configs.getObject ( "SelectConfD1" );  \/\/ not required\nconst numPocketD2    = configs.getObject ( "SelectConfD2" );  \/\/ not required\nconst numPocketD3    = configs.getObject ( "SelectConfD3" );  \/\/ not required\n\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\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/ \u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u30d1\u30fc\u30b9\u3068\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\nconst idxDate = parseInt(strColIdDate, 10);\nif (isNaN(idxDate) || idxDate < 0) {\n  throw new Error("\\n AutomatedTask ConfigError: Invalid Date Column ID in B1 \\n");\n}\n\nlet arrIdxNum = [];\nif (strColIdsNum !== "") {\n  arrIdxNum = strColIdsNum.split(",").map(s => parseInt(s.trim(), 10));\n  if (arrIdxNum.some(isNaN)) {\n    throw new Error("\\n AutomatedTask ConfigError: Invalid Numeric Column IDs in B2 \\n");\n  }\n}\n\nlet yeMonth = 0;\nif (strFyMonth !== "") {\n  yeMonth = parseInt(strFyMonth, 10);\n  if (isNaN(yeMonth) || yeMonth < 1 || yeMonth > 12) {\n    throw new Error("\\n AutomatedTask ConfigError: Invalid YE Month in C2 (must be 1-12) \\n");\n  }\n}\n\n\/\/ \u30d8\u30c3\u30c0\u30fc\u884c\u306e\u51e6\u7406\u3068\u30c1\u30a7\u30c3\u30af\nif (arr2dTsv.length === 0) {\n  throw new Error("\\n AutomatedTask DataError: Input TSV is empty \\n");\n}\nconst headerRow = arr2dTsv[0];\nif (idxDate >= headerRow.length) {\n  throw new Error(`\\n AutomatedTask ConfigError: Date Column ID (${idxDate}) is out of bounds \\n`);\n}\nconst numHeaders = arrIdxNum.map(idx => {\n  if (idx >= headerRow.length) {\n    throw new Error(`\\n AutomatedTask ConfigError: Numeric Column ID (${idx}) is out of bounds \\n`);\n  }\n  return headerRow[idx];\n});\n\n\/\/ \u96c6\u8a08\u51e6\u7406\u306e\u6e96\u5099\n\/\/ Map: \u30ad\u30fc = \u56db\u534a\u671f\u30e9\u30d9\u30eb, \u5024 = { count: \u884c\u6570, sums: [Number, Number...] }\nconst mapAgg = new Map();\nlet minAbsQ = Infinity;\nlet maxAbsQ = -Infinity;\n\n\/\/ \u30c7\u30fc\u30bf\u884c\u306e\u30eb\u30fc\u30d7\uff081\u884c\u76ee\u306f\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u30b9\u30ad\u30c3\u30d7\uff09\nfor (let i = 1; i < arr2dTsv.length; i++) {\n  const row = arr2dTsv[i];\n  const strDate = row[idxDate];\n\n  \/\/ \u7a7a\u30bb\u30eb\u306f\u30b9\u30ad\u30c3\u30d7\n  if (!strDate || strDate.trim() === "") continue;\n\n  let dateObj;\n  try {\n    dateObj = parseAsLocalDate(strDate);\n  } catch (e) {\n    engine.log(`Row ${i + 1} skipped: Failed to parse date "${strDate}".`);\n    continue;\n  }\n\n  \/\/ \u30e9\u30d9\u30eb\u3068\u7d76\u5bfe\u56db\u534a\u671f\u756a\u53f7\u306e\u53d6\u5f97\n  const qInfo = getQuarterInfo(dateObj, yeMonth);\n  const label = qInfo.label;\n  const absQ = qInfo.absQ;\n\n  \/\/ \u6700\u5c0f\u30fb\u6700\u5927\u306e\u56db\u534a\u671f\u3092\u8a18\u9332\n  if (absQ < minAbsQ) minAbsQ = absQ;\n  if (absQ > maxAbsQ) maxAbsQ = absQ;\n\n  \/\/ \u30de\u30c3\u30d7\u306e\u521d\u671f\u5316 (ECMAScript\u6a19\u6e96\u306e\u6570\u5024 0 \u3067\u521d\u671f\u5316)\n  if (!mapAgg.has(label)) {\n    mapAgg.set(label, { count: 0, sums: new Array(arrIdxNum.length).fill(0) });\n  }\n\n  const aggData = mapAgg.get(label);\n  aggData.count++;\n\n  \/\/ \u6570\u5024\u5217\u306e\u52a0\u7b97\uff08\u4e0d\u8981\u6587\u5b57\u306e\u9664\u53bb\u5bfe\u5fdc\uff09\n  for (let j = 0; j < arrIdxNum.length; j++) {\n    const cellVal = row[arrIdxNum[j]];\n    if (cellVal !== "") {\n      \/\/ \u300c\u30d4\u30ea\u30aa\u30c9(.)\u300d\u300c\u30de\u30a4\u30ca\u30b9\u8a18\u53f7(-)\u300d\u300c\u6570\u5b57(0-9)\u300d\u4ee5\u5916\u3092\u3059\u3079\u3066\u9664\u53bb\n      const numValStr = cellVal.replace(\/[^0-9.-]\/g, ''); \n      const numVal = Number(numValStr);\n      \n      if (numValStr !== "" && !isNaN(numVal)) {\n        aggData.sums[j] += numVal;\n      } else if (cellVal.trim() !== "") {\n        engine.log(`Row ${i + 1} Col ${arrIdxNum[j]} warning: Unparseable number "${cellVal}".`);\n      }\n    }\n  }\n}\n\n\/\/ --- \u30ae\u30e3\u30c3\u30d7\uff08\u30c8\u30d3\uff09\u306e\u7a74\u57cb\u3081\u51e6\u7406 ---\nif (minAbsQ !== Infinity) {\n  for (let q = minAbsQ; q <= maxAbsQ; q++) {\n    const label = getLabelFromAbsoluteQuarter(q, yeMonth);\n    if (!mapAgg.has(label)) {\n      \/\/ \u5b58\u5728\u3057\u306a\u3044\u56db\u534a\u671f\u306a\u3089 count: 0, sums: 0 \u3067\u30bb\u30c3\u30c8\n      mapAgg.set(label, { count: 0, sums: new Array(arrIdxNum.length).fill(0) });\n    }\n  }\n}\n\n\n\n\/\/ ==== \u51fa\u529b\u7528TSV\u306e\u69cb\u7bc9 ====\nlet arrOutputTsv = [];\nlet outHeaderRow = [];\n\n\/\/ \u30d8\u30c3\u30c0\u30fc\u8a2d\u5b9a\nif (strCountFormat === "Merged") {\n  outHeaderRow.push("Qtr-Label (Count)");\n} else if (strCountFormat === "Hidden") {\n  outHeaderRow.push("Qtr-Label");\n} else {\n  \/\/ "Separate" (\u30c7\u30d5\u30a9\u30eb\u30c8)\n  outHeaderRow.push("Qtr-Label");\n  outHeaderRow.push("Count");\n}\noutHeaderRow = outHeaderRow.concat(numHeaders);\narrOutputTsv.push(outHeaderRow.join("\\t"));\n\n\/\/ \u30c7\u30fc\u30bf\u884c\u306e\u30bd\u30fc\u30c8\u3068\u69cb\u7bc9\uff08\u30e9\u30d9\u30eb\u540d\u3067\u6607\u9806\u30bd\u30fc\u30c8\uff09\nconst sortedLabels = Array.from(mapAgg.keys()).sort();\nfor (const label of sortedLabels) {\n  const agg = mapAgg.get(label);\n  let rowData = [];\n\n  if (strCountFormat === "Merged") {\n    rowData.push(`${label} (${agg.count})`);\n  } else if (strCountFormat === "Hidden") {\n    rowData.push(label);\n  } else {\n    \/\/ "Separate" (\u30c7\u30d5\u30a9\u30eb\u30c8)\n    rowData.push(label);\n    rowData.push(agg.count.toString());\n  }\n\n  \/\/ \u6570\u5024\u3092\u6587\u5b57\u5217\u5316\u3057\u3066TSV\u306e\u30bb\u30eb\u306b\u8ffd\u52a0\n  for (const sum of agg.sums) {\n    rowData.push(String(sum));\n  }\n  arrOutputTsv.push(rowData.join("\\t"));\n}\n\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\nif ( strPocketC3 !== null ){ \n  engine.setData( strPocketC3, arrOutputTsv?.join( '\\n' ) ?? "" );\n}\n\nif ( numPocketD1 !== null ){ \n  engine.setData( numPocketD1, new java.math.BigDecimal( strTsv.split("\\n").length ) );\n}\nif ( numPocketD2 !== null ){ \n  engine.setData( numPocketD2, new java.math.BigDecimal( arr2dTsv.length ) );\n}\nif ( numPocketD3 !== null ){ \n  engine.setData( numPocketD3, new java.math.BigDecimal( arrOutputTsv.length ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\/**\n * \u65e5\u4ed8\u3068\u6c7a\u7b97\u6708\u304b\u3089\u56db\u534a\u671f\u30e9\u30d9\u30eb\u3068\u7d76\u5bfe\u56db\u534a\u671f\u756a\u53f7\uff08\u30bd\u30fc\u30c8\u30fb\u88dc\u9593\u7528\uff09\u3092\u751f\u6210\u3059\u308b\n * @param {Date} dateObj - JavaScript Date object\n * @param {number} yeMonth - Year End Month (0 for standard quarter, 1-12 for FY)\n * @returns {Object} { label: string, absQ: number }\n *\/\nfunction getQuarterInfo(dateObj, yeMonth) {\n  const y = dateObj.getFullYear();\n  const m = dateObj.getMonth() + 1; \/\/ 1-12\n\n  if (yeMonth === 0) {\n    \/\/ \u901a\u5e38\u306e\u56db\u534a\u671f (Q-YYYYMM~MM)\n    const q = Math.ceil(m \/ 3); \/\/ 1, 2, 3, 4\n    const absQ = y * 4 + (q - 1);\n    let qStr = "";\n    if (q === 1) qStr = "01~03";\n    else if (q === 2) qStr = "04~06";\n    else if (q === 3) qStr = "07~09";\n    else qStr = "10~12";\n    return { label: `Q-${y}${qStr}`, absQ: absQ };\n  } else {\n    \/\/ FY\u30d9\u30fc\u30b9\u306e\u56db\u534a\u671f (FYYYYY-QX)\n    let fy = y;\n    if (m > yeMonth) {\n      fy = y + 1;\n    }\n    let shiftedM = m - yeMonth;\n    if (shiftedM <= 0) {\n      shiftedM += 12;\n    }\n    const qNum = Math.ceil(shiftedM \/ 3);\n    const absQ = fy * 4 + (qNum - 1);\n    return { label: `FY${fy}-Q${qNum}`, absQ: absQ };\n  }\n}\n\n\/**\n * \u7d76\u5bfe\u56db\u534a\u671f\u756a\u53f7\u3068\u6c7a\u7b97\u6708\u304b\u3089\u3001\u30e9\u30d9\u30eb\u6587\u5b57\u5217\u3092\u5fa9\u5143\u3059\u308b\uff08\u30c8\u30d3\u306e\u7a74\u57cb\u3081\u7528\uff09\n * @param {number} absQ - Absolute Quarter Number\n * @param {number} yeMonth - Year End Month\n * @returns {string} Quarter label\n *\/\nfunction getLabelFromAbsoluteQuarter(absQ, yeMonth) {\n  if (yeMonth === 0) {\n    const y = Math.floor(absQ \/ 4);\n    const q = (absQ % 4) + 1;\n    let qStr = "";\n    if (q === 1) qStr = "01~03";\n    else if (q === 2) qStr = "04~06";\n    else if (q === 3) qStr = "07~09";\n    else qStr = "10~12";\n    return `Q-${y}${qStr}`;\n  } else {\n    const fy = Math.floor(absQ \/ 4);\n    const qNum = (absQ % 4) + 1;\n    return `FY${fy}-Q${qNum}`;\n  }\n}\n\n\n\/**\n * Parses TSV string as a two-dimensional rectangular data matrix and creates a 2D array.\n * @param {string} strTsv - The input TSV string\n * @returns {Array<Array<string>>} Rectangular 2D array\n *\/\nfunction parseAsRectangular( strTsv ){\n  const arrTsv = strTsv.split("\\n");\n  let numMinWidth   = Infinity;\n  let numMaxWidth   = 0;\n  let numBlanklines = 0;\n  \n  const parsedRows = [];\n  for( let i = 0; i < arrTsv.length; i++ ){\n    const line = arrTsv[i];\n    if( line === "" ){\n      numBlanklines++;\n      continue;\n    }\n    const arrCells = line.split("\\t");\n    const len = arrCells.length;\n    if( len < numMinWidth ){ numMinWidth = len; }\n    if( len > numMaxWidth ){ numMaxWidth = len; }\n    parsedRows.push( arrCells );\n  }\n  \n  if( numMinWidth === Infinity ){\n    numMinWidth = 0;\n  }\n  engine.log( " AutomatedTask TsvDataCheck:" + \n              " MinWidth:" + numMinWidth +\n              " MaxWidth:" + numMaxWidth +\n              " Lines:" + arrTsv.length +\n              " (BlankLines:" + numBlanklines + ")" );\n\n  for( let i = 0; i < parsedRows.length; i++ ){\n    const row = parsedRows[i];\n    while( row.length < numMaxWidth ){\n      row.push( "" );\n    }\n  }\n  return parsedRows;\n}\n\n\n\/**\n * Parses a Date or Datetime string and returns a JavaScript `Date` object as local time.\n * Timezone information in the string (such as "Z" or "+09:00") is forcefully ignored.\n * Supports various formats: "YYYYMMDD", "YYYY-MM-DD", ISO 8601, Japanese localized formats, etc.\n * * \u65e5\u4ed8\u307e\u305f\u306f\u65e5\u6642\u306e\u6587\u5b57\u5217\u3092\u89e3\u6790\u3057\u3001\u30ed\u30fc\u30ab\u30eb\u6642\u523b\u3068\u3057\u3066\u6271\u308f\u308c\u308bJavaScript\u306e `Date` \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8fd4\u3057\u307e\u3059\u3002\n * \u6587\u5b57\u5217\u5185\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u60c5\u5831\uff08"Z"\u3084"+09:00"\u306a\u3069\uff09\u306f\u5f37\u5236\u7684\u306b\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n * "YYYYMMDD", "YYYY-MM-DD", ISO 8601, \u65e5\u672c\u8a9e\u306e\u65e5\u4ed8\u6587\u5b57\u5217\u306a\u3069\u3001\u69d8\u3005\u306a\u5f62\u5f0f\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002\n *\n * @param {string} str - The date or datetime string to parse. \/ \u89e3\u6790\u3059\u308b\u65e5\u4ed8\u307e\u305f\u306f\u65e5\u6642\u306e\u6587\u5b57\u5217\u3002\n * @returns {Date} A local Date object. \/ \u30ed\u30fc\u30ab\u30eb\u6642\u523b\u306eDate\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3002\n * @throws {Error} Throws an error if the string is empty, contains no numbers, or lacks required date parts.\n * \/ \u6587\u5b57\u5217\u304c\u7a7a\u306e\u5834\u5408\u3001\u6570\u5b57\u304c\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u3001\u307e\u305f\u306f\u5fc5\u8981\u306a\u65e5\u4ed8\u8981\u7d20\uff08\u5e74\u6708\u65e5\uff09\u304c\u4e0d\u8db3\u3057\u3066\u3044\u308b\u5834\u5408\u306b\u30a8\u30e9\u30fc\u3092\u30b9\u30ed\u30fc\u3057\u307e\u3059\u3002\n * * @example\n * parseAsLocalDate("2026-12-31 23:59");     \/\/ Date 2026-12-31T23:59:00 (Local)\n * parseAsLocalDate("20261231T235959Z");     \/\/ Date 2026-12-31T23:59:00 (Local, 'Z' is ignored)\n * parseAsLocalDate("2026\u5e7412\u670831\u65e5");       \/\/ Date 2026-12-31T00:00:00 (Local)\n *\/\nfunction parseAsLocalDate ( str ){ \/\/ strDateOrDatetime\n  \/\/\n  \/\/ Searches a Date-or-Datetime String for YYYY, MM, DD, hh:mm in that order and\n  \/\/  returns JavaScript `Date` object.\n  \/\/ Any format is forcibly recognized as LOCAL DATETIME. -- UNIQUE --\n  \/\/ Supports "ISO 8601 format", "BPMS date format", "BPMS datetime format", etc,,,\n  \/\/\n  \/\/ String "2026-12-31 23:59"          (Questetra BPMS datetime format)\n  \/\/ \u21d2 Date 2026-12-31T23:59:00+XX:00\n  \/\/ String "2026-12-31"                (Questetra BPMS date format) \n  \/\/ \u21d2 Date 2026-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "2026\/12\/31"                (Windows date-ja format)\n  \/\/ \u21d2 Date 2026-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "2026-12-31 23:59:59"       (SQL Time format)\n  \/\/ \u21d2 Date 2026-12-31T23:59:00+XX:00\n  \/\/ String "2026-12-31T23:59:59.999Z"  (ISO 8601 format)\n  \/\/ \u21d2 Date 2026-12-31T23:59:00+XX:00   \/\/ UNIQUE: Timezone not evaluated\n  \/\/ String "2026\u5e7412\u670831\u65e5"            (\u65e5\u672c\u8a9e\/Japanese)\n  \/\/ \u21d2 Date 2026-12-31T00:00:00+XX:00\n  \/\/\n  \/\/ String "20261231"\n  \/\/ \u21d2 Date 2026-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "20261231T235959Z"          (ISO 8601 format)\n  \/\/ \u21d2 Date 2026-12-31T23:59:00+XX:00   \/\/ UNIQUE: Timezone not evaluated\n  \/\/ String "20261231T2359"\n  \/\/ \u21d2 Date 2026-12-31T23:59:00+XX:00\n\n  if( str === "" ){\n    throw new Error( "\\n AutomatedTask ParseDateError:" +\n                     " String is empty \\n" );\n  }\n  const arrNumParts = str.match( \/\\d+\/g );\n  if( arrNumParts === null ){\n    throw new Error( "\\n AutomatedTask ParseDateError:" +\n                     " No numeric characters in: " + str + "\\n" );\n  }\n\n  \/\/\/ function default\n  let numYear    = 0; \/\/ limit in QBPMS: 1900 to 2100 (asof 2026-06)\n  let indexMonth = 0;\n  let numDay     = 0;\n  let numHours   = 0;\n  let numMinutes = 0;\n\n  \/\/\/ case: startsWith YYYYMMDD\n  if( arrNumParts[0].length === 8 ){\n    numYear      = parseInt( arrNumParts[0].slice( 0, 4 ), 10 );\n    indexMonth   = parseInt( arrNumParts[0].slice( 4, 6 ), 10 ) - 1;\n    numDay       = parseInt( arrNumParts[0].slice( 6, 8 ), 10 );\n    if (arrNumParts.length > 1) {\n      if (arrNumParts[1].length >= 4) {\n        \/\/ like "2359" or "235959Z"\n        numHours = parseInt(arrNumParts[1].slice(0, 2), 10);\n        numMinutes = parseInt(arrNumParts[1].slice(2, 4), 10);\n      } else {\n        \/\/ like "23:59" -> arrNumParts is ['...', '23', '59']\n        numHours = parseInt(arrNumParts[1], 10);\n        if (arrNumParts.length > 2) {\n          numMinutes = parseInt(arrNumParts[2], 10);\n        }\n      }\n    }\n\n  \/\/\/ case: not startsWith YYYYMMDD, like "2026-12-31 23:59"\n  }else{\n    if( arrNumParts.length < 3){\n      throw new Error( "\\n AutomatedTask ParseDateError:" +\n                       " 3 Parts of numeric characters are needed in: " + str + "\\n" );\n    }\n    numYear      = parseInt( arrNumParts[0], 10 );\n    indexMonth   = parseInt( arrNumParts[1], 10 ) - 1;\n    numDay       = parseInt( arrNumParts[2], 10 );\n  if (arrNumParts.length > 3) {\n      numHours = parseInt(arrNumParts[3], 10);\n    }\n    if (arrNumParts.length > 4) {\n      numMinutes = parseInt(arrNumParts[4], 10);\n    }\n  }\n\n  \/\/\/ return JavaScript `Date` object\n  const localDate = new Date(numYear, indexMonth, numDay, numHours, numMinutes);\n  localDate.setFullYear(numYear);\n  return localDate;\n}\n\n\n\n\n\/*\n### Sample Data\n\n==== input TSV ====\n\u53d6\u5f15No\t\u53d6\u5f15\u65e5\t\u501f\u65b9\u52d8\u5b9a\u79d1\u76ee\t\u501f\u65b9\u88dc\u52a9\u79d1\u76ee\t\u501f\u65b9\u90e8\u9580\t\u501f\u65b9\u53d6\u5f15\u5148\t\u501f\u65b9\u7a0e\u533a\u5206\t\u501f\u65b9\u30a4\u30f3\u30dc\u30a4\u30b9\t\u501f\u65b9\u91d1\u984d (\u5186)\t\u501f\u65b9\u7a0e\u984d\n1\t2026\/04\/01\t\u6d88\u8017\u54c1\u8cbb\t\t\u7ba1\u7406\u90e8\t\u6587\u5177\u30b7\u30e7\u30c3\u30d7A\t\u8ab2\u7a0e\u4ed5\u5165 10%\t\u9069\u683c\t5500\t550\n2\t2026\/04\/02\t\u65c5\u8cbb\u4ea4\u901a\u8cbb\t\t\u55b6\u696d\u90e8\tJR\u6771\u65e5\u672c\t\u8ab2\u7a0e\u4ed5\u5165 10%\t\u9069\u683c\t1320\t132\n3\t2026\/06\/03\t\u901a\u4fe1\u8cbb\t\t\u7ba1\u7406\u90e8\t\u643a\u5e2f\u30ad\u30e3\u30ea\u30a2B\t\u8ab2\u7a0e\u4ed5\u5165 10%\t\u9069\u683c\t8800\t880\n4\t2026\/07\/05\t\u5e83\u544a\u5ba3\u4f1d\u8cbb\t\t\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u90e8\t\u5e83\u544a\u4ee3\u7406\u5e97C\t\u8ab2\u7a0e\u4ed5\u5165 10%\t\u9069\u683c\t110000\t11000\n5\t2027-01-06 12:30\t\u5e83\u544a\u5ba3\u4f1d\u8cbb\t\t\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u90e8\t\u5e83\u544a\u4ee3\u7406\u5e97D\t\u8ab2\u7a0e\u4ed5\u5165 10%\t\u9069\u683c\t33000\t3300\n\n==== output TSV-1 (date:id1) ====\nQtr-Label\tCount\nQ-202604~06\t3\nQ-202607~09\t2\n\n==== output TSV-2 (date:id1, sum:8) ====\nQtr-Label\tCount\t\u501f\u65b9\u91d1\u984d (\u5186)\nQ-202604~06\t3\t15620\nQ-202607~09\t2\t143000\n\n==== output TSV-3 (date:id1, sum:8,9)  ====\nQtr-Label (Count)\t\u501f\u65b9\u91d1\u984d (\u5186)\t\u501f\u65b9\u7a0e\u984d\nFY2027-Q1 (3)\t15620\t1562\nFY2027-Q2 (1)\t110000\t11000\nFY2027-Q3 (0)\t0\t0\nFY2027-Q4 (1)\t33000\t3300\n\n\n\n\n### NOTES-en\n\n* When a case reaches this [Automated Step], the TSV aggregation process is automatically executed.\n    * The first row of the input TSV is recognized as the header row.\n* The input TSV string is parsed as a simple tab-separated values string.\n    * Double quotes and other specific characters within the TSV string are retained as is.\n    * Blank lines within the TSV string are ignored.\n    * For rows lacking the expected number of cells, empty string ("") cells are automatically appended.\n    * The number of rows in the input\/output TSV string can be stored as Case Data.\n* The date column used as the aggregation key is specified by its column ID.\n    * It does not necessarily have to be Column A (id=0).\n    * If Column B (id=1) is the aggregation key, set "1".\n* Various aggregation results can be output as TSV strings.\n    * `Qtr-Label\tCount`\n        * `Q-202604~06\t3`\n        * `Q-202607~09\t2`\n    * `Qtr-Label\tCount\tDebit Amount (JPY)`\n        * `Q-202604~06\t3\t15620`\n        * `Q-202607~09\t2\t143000`\n    * `Qtr-Label (Count)\tDebit Amount (JPY)\tDebit Tax`\n        * `Q-202604~06 (3)\t15620\t1562`\n        * `Q-202607~09 (2)\t143000\t14300`\n\n\n### NOTES-ja\n\n* \u6848\u4ef6\uff08\u30b1\u30fc\u30b9\uff09\u304c\u3053\u306e\uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u306b\u5230\u9054\u3059\u308b\u3068\u3001TSV\u96c6\u8a08\u51e6\u7406\u304c\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\n    * \u5165\u529bTSV\u306e1\u884c\u76ee\u306f\u3001\u30d8\u30c3\u30c0\u30fc\u884c\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u307e\u3059\u3002\n* \u5165\u529bTSV\u6587\u5b57\u5217\u306f\u3001\u30b7\u30f3\u30d7\u30eb\u306a\u30bf\u30d6\u533a\u5207\u308a\u6587\u5b57\u5217\u3068\u3057\u3066\u30d1\u30fc\u30b9\u3055\u308c\u307e\u3059\u3002\n    * TSV\u6587\u5b57\u5217\u5185\u306e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u7b49\u3082\u3001\u305d\u306e\u307e\u307e\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\n    * TSV\u6587\u5b57\u5217\u5185\u306e\u7a7a\u884c\u306f\u3001\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n    * TSV\u6587\u5b57\u5217\u5185\u3067\u30bb\u30eb\u6570\u306e\u8db3\u308a\u306a\u3044\u884c\u306f\u3001\u7a7a\u6587\u5b57\uff08""\uff09\u306e\u30bb\u30eb\u304c\u81ea\u52d5\u7684\u306b\u88dc\u5b8c\u3055\u308c\u307e\u3059\u3002\n    * \u5165\u51fa\u529bTSV\u306e\u884c\u6570\u306f\u3001\u30b1\u30fc\u30b9\u30c7\u30fc\u30bf\u3068\u3057\u3066\u683c\u7d0d\u53ef\u80fd\u3067\u3059\u3002\n* \u96c6\u8a08\u30ad\u30fc\u3068\u306a\u308b\u65e5\u4ed8\u5217\u306fID\u3067\u6307\u5b9a\u3057\u307e\u3059\n    * \u5fc5\u305a\u3057\u3082A\u5217\uff08id=0\uff09\u3067\u306a\u304f\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002\n    * B\u5217\uff08id=1\uff09\u304c\u96c6\u8a08\u30ad\u30fc\u3068\u306a\u308b\u5834\u5408\u3001"1" \u3068\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002\n* \u3055\u307e\u3056\u307e\u306a\u96c6\u8a08\u7d50\u679c\u3092\u3001TSV\u6587\u5b57\u5217\u3068\u3057\u3066\u51fa\u529b\u3055\u305b\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002\n    * `Qtr-Label\tCount`\n        * `Q-202604~06\t3`\n        * `Q-202607~09\t2`\n    * `Qtr-Label\tCount\t\u501f\u65b9\u91d1\u984d (\u5186)`\n        * `Q-202604~06\t3\t15620`\n        * `Q-202607~09\t2\t143000`\n    * `Qtr-Label (Count)\t\u501f\u65b9\u91d1\u984d (\u5186)\t\u501f\u65b9\u7a0e\u984d`\n        * `Q-202604~06 (3)\t15620\t1562`\n        * `Q-202607~09 (2)\t143000\t14300`\n\n\n\n### APPENDIX-en\n* The default format for the quarter label is `Q-202604~06`.\n    * By setting the Year-End (YE) Month, you can switch to the FY format (Fiscal Year basis \/ End-Year style).\n        * Note) End-Year style: FY2027 = 2026\/04\/01 to 2027\/03\/31\n        * e.g.: "3"; `Q-202604~06` \u2192 `FY2027-Q1`\n        * e.g.: "12"; `Q-202604~06` \u2192 `FY2026-Q2`\n* Cells in the specified numeric columns are parsed as numbers as much as possible. *(Excluding the first header row)*\n    * Any characters other than periods (`.`), minus signs (`-`), and digits (`0-9`) are stripped out.\n        * such as commas acting as digit separators or currency symbols\n    * The resulting string is evaluated using `Number()`.\n    * If parsing fails, the value is treated as `0`.\n    * e.g.: `$ 1,500.50 usd` \u21d2 `1500.5`\n\n### APPENDIX-ja\n* \u56db\u534a\u671f\u30e9\u30d9\u30eb\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u306f `Q-202604~06` \u3067\u3059\u3002\n    * \u6c7a\u7b97\u6708\u3092\u30bb\u30c3\u30c8\u3059\u308c\u3070FY\u65b9\u5f0f\uff08\u4f1a\u8a08\u5e74\u5ea6\u30d9\u30fc\u30b9\uff0f\u7d42\u4e86\u5e74\u65b9\u5f0f\uff09\u306b\u5909\u66f4\u53ef\u80fd\u3067\u3059\u3002\n        * \u203b \u7d42\u4e86\u5e74\u65b9\u5f0f\uff1a FY2027 = 2026\/04\/01 \uff5e 2027\/03\/31\n        * \u4f8b: "3"; `Q-202604~06` \u2192 `FY2027-Q1`\n        * \u4f8b: "12"; `Q-202604~06` \u2192 `FY2026-Q2`\n* \u6570\u5024\u5217\u3068\u3057\u3066\u6307\u5b9a\u3055\u308c\u305f\u5217\u306e\u5404\u30c7\u30fc\u30bf\u306f\u3001\u53ef\u80fd\u306a\u9650\u308a\u6570\u5024\u3068\u3057\u3066\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\u203b\u5148\u982d1\u884c\u76ee\uff08\u30d8\u30c3\u30c0\u30fc\u884c\uff09\u3092\u9664\u304f\n    * \u300c\u30d4\u30ea\u30aa\u30c9(.)\u300d\u300c\u30de\u30a4\u30ca\u30b9\u8a18\u53f7(-)\u300d\u300c\u6570\u5b57(0\uff5e9)\u300d\u4ee5\u5916\u306e\u6587\u5b57\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u3001\u305d\u308c\u3089\u304c\u9664\u53bb\u3055\u308c\u305f\u4e0a\u3067\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\n        * \u6841\u533a\u5207\u308a\u30ab\u30f3\u30de\u3084\u901a\u8ca8\u8a18\u53f7\u306a\u3069\n    * \u9664\u53bb\u5f8c\u306e\u6587\u5b57\u5217\u306f `Number()` \u306b\u3088\u3063\u3066\u6570\u5024\u5316\u3055\u308c\u307e\u3059\u3002\n    * \u89e3\u6790\u306b\u5931\u6557\u3057\u305f\u5834\u5408\u306f `0` \u3068\u3057\u3066\u52a0\u7b97\u3055\u308c\u307e\u3059\u3002\n    * \u4f8b: `$ 1,500.50 usd` \u21d2 `1500.5`\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n