{"id":170124,"date":"2025-01-24T12:31:21","date_gmt":"2025-01-24T03:31:21","guid":{"rendered":"https:\/\/support.questetra.com\/?p=170124"},"modified":"2025-01-29T17:49:56","modified_gmt":"2025-01-29T08:49:56","slug":"tsv-string-extract-cells-2025","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-extract-cells-2025\/","title":{"rendered":"TSV\u6587\u5b57\u5217: \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa"},"content":{"rendered":"\n

TSV\u6587\u5b57\u5217, \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa<\/strong><\/h4>\n\n\n\n

translate<\/span> TSV String, Extract Cells<\/a><\/p>\n\n\n\n

\u6307\u5b9a\u30bb\u30eb\u306e\u5024\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002\u30bb\u30eb\u306fA1\u8868\u8a18\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\u62bd\u51fa\u3055\u308c\u305f\u6587\u5b57\u5217\u306f\u3001\u6587\u5b57\u5217\u578b\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u683c\u7d0d\u3067\u304d\u307e\u3059\u3002\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304c\u8a31\u305b\u3070\u3001\u6570\u5024\u578b\u3001\u65e5\u4ed8\u578b\u3001\u65e5\u6642\u578b\u3001\u5358\u4e00\u9078\u629e\u578b\u3001\u30e6\u30fc\u30b6\u578b\u3001\u7d44\u7e54\u578b\u306e\u5404\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u578b\u5909\u63db\u3057\u3066\u683c\u7d0d\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: TSV\u6587\u5b57\u5217\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB<\/dt>
B: \u62bd\u51fa\u30bb\u30eb(A1\u8868\u8a18)\u3092\u5404\u884c\u306b\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u6700\u59278\u30bb\u30eb\u5206\uff09 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfC1<\/dt>
C1: \u62bd\u51fa\u3055\u308c\u305f\u30bb\u30eb\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC2<\/dt>
C2: \u62bd\u51fa\u3055\u308c\u305f\u30bb\u30eb\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC3<\/dt>
C3: \u62bd\u51fa\u3055\u308c\u305f\u30bb\u30eb\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC4<\/dt>
C4: \u62bd\u51fa\u3055\u308c\u305f\u30bb\u30eb\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC5<\/dt>
C5: \u62bd\u51fa\u3055\u308c\u305f\u30bb\u30eb\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC6<\/dt>
C6: \u62bd\u51fa\u3055\u308c\u305f\u30bb\u30eb\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC7<\/dt>
C7: \u62bd\u51fa\u3055\u308c\u305f\u30bb\u30eb\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC8<\/dt>
C8: \u62bd\u51fa\u3055\u308c\u305f\u30bb\u30eb\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n<\/div>\n
SelectConfD1<\/dt>
D1: TSV\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: \u672b\u5c3e\u6539\u884c\u30b3\u30fc\u30c9\u3092\u7121\u8996\u3057\u305f\u884c\u6570\u304c\u683c\u7d0d\u3055\u308c\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
\/\/ GraalJS Script (engine type: 3)\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 numTsvLines = strTsv.split("\\n").length;\n  const numTsvNoLf  = strTsv.replace(\/[\\n]*$\/, "").split("\\n").length;\n                      \/\/ delete Line Feed codes at the end\n\n  \/\/ get TSV as Array-Array (2d Array)\n  const arr2dTsv    = parseAsRectangular( strTsv );  \/\/ [row,col]\n\nconst strExtractNotations   = configs.get       ( "StrConfB" );     \/\/ REQUIRED\n  if( strExtractNotations === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {B: IDs} not specified \\n" );\n  }\n\nconst multiPocketC1 = configs.getObject ( "SelectConfC1" );  \/\/ not required\nconst multiPocketC2 = configs.getObject ( "SelectConfC2" );  \/\/ not required\nconst multiPocketC3 = configs.getObject ( "SelectConfC3" );  \/\/ not required\nconst multiPocketC4 = configs.getObject ( "SelectConfC4" );  \/\/ not required\nconst multiPocketC5 = configs.getObject ( "SelectConfC5" );  \/\/ not required\nconst multiPocketC6 = configs.getObject ( "SelectConfC6" );  \/\/ not required\nconst multiPocketC7 = configs.getObject ( "SelectConfC7" );  \/\/ not required\nconst multiPocketC8 = configs.getObject ( "SelectConfC8" );  \/\/ not required\n\nconst arrMultiPocketC = [];\n  arrMultiPocketC.push ( multiPocketC1 );\n  arrMultiPocketC.push ( multiPocketC2 );\n  arrMultiPocketC.push ( multiPocketC3 );\n  arrMultiPocketC.push ( multiPocketC4 );\n  arrMultiPocketC.push ( multiPocketC5 );\n  arrMultiPocketC.push ( multiPocketC6 );\n  arrMultiPocketC.push ( multiPocketC7 );\n  arrMultiPocketC.push ( multiPocketC8 );\n\nconst numPocketD1 = configs.getObject ( "SelectConfD1" );  \/\/ not required\nconst numPocketD2 = configs.getObject ( "SelectConfD2" );  \/\/ not required\n\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (nothing)\n\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/\/ Get A1Notations as Coordinate-Array for Extraction;\n\/\/\/ eg: "A1, C1, H1" -> [ [0,0], [2, 0], [7, 0] ]   \/\/ [colNum,rowNum] Array (0-start)\nlet   arrExtractCoords = [];\nconst regA1Notation = \/^(?<colId>[A-Z]+)(?<rowNum>[0-9]+)$\/; \/\/ RegExp\n  \/\/ Named capturing group \/ \u540d\u524d\u4ed8\u304d\u30ad\u30e3\u30d7\u30c1\u30e3\u30b0\u30eb\u30fc\u30d7\n  \/\/ https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Regular_expressions\/Named_capturing_group\n\nconst arrExtractNotations = strExtractNotations.split("\\n");\nfor ( let i = 0; i < arrExtractNotations.length; i++ ){\n  if( arrExtractNotations[i] === "" ){ \/\/ Skip blank lines\n    continue;\n  }\n\n  let objMatch = arrExtractNotations[i].match( regA1Notation );\n  \/\/ engine.log( " debug:" + objMatch.groups.colId + " " + objMatch.groups.rowNum );\n  let arrTmp = [ alpha2Decimal ( objMatch.groups.colId ) -1, objMatch.groups.rowNum -1 ]; \/\/ 0-start\n  \/\/ engine.log( " debug:" + alpha2Decimal (objMatch.groups.colId) + " " + objMatch.groups.rowNum );\n\n  arrExtractCoords.push ( arrTmp );\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\/ja\/articles\/360024574771-R2301\n\/\/ \n\/\/\/ prepare\nconst regBpmsYMD     = \/^\\d{4}-\\d{2}-\\d{2}$\/;                     \/\/ RegExp\nconst regEmail       = \/^[\\w][\\w_\\.\\-\\+]*@[\\w\\.\\-]+\\.[a-zA-Z]+$\/; \/\/ RegExp\nconst regPositiveInt = \/^([1-9]\\d*|0)$\/;                          \/\/ RegExp\n\n\n\/\/\/  Get Cell Values  and  Store (loop)\n\nfor ( let i = 0; i < arrExtractCoords.length; i++ ){\n  let strCellValue = arr2dTsv[ arrExtractCoords[i][1] ][ arrExtractCoords[i][0] ];  \/\/ 0 start\n  if( strCellValue === "" ){\n    engine.log( " AutomatedTask CellString[" + arrExtractCoords[i][0]  + "][" + arrExtractCoords[i][1] + "]: (empty)" );\n    engine.setData( arrMultiPocketC[i], null );\n    return;\n  }\n  engine.log( " AutomatedTask CellString[" + arrExtractCoords[i][0]  + "][" + arrExtractCoords[i][1] + "]: " + strCellValue );\n\n  \/\/ \u25bd\u25bdCase: STRING\u25bd\u25bd\n  if( arrMultiPocketC[i].matchDataType("STRING") ){\n    engine.setData( arrMultiPocketC[i], strCellValue );\n\n  }else if( arrMultiPocketC[i].matchDataType("DECIMAL") ){\n    let numCellValue = parseFloat( strCellValue.replace(\/,\/g, "") );\n    if( isNaN( numCellValue ) ){\n      throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n                       " Invalid Numeric Value \\n" );\n    }\n    engine.setData( arrMultiPocketC[i], new java.math.BigDecimal( numCellValue ) );\n\n  \/\/ \u25bd\u25bdCase: DATE\u25bd\u25bd\n  }else if( arrMultiPocketC[i].matchDataType("DATE") ){\n    if( regBpmsYMD.test( strCellValue ) ){\n      engine.setData( arrMultiPocketC[i], java.sql.Date.valueOf( strCellValue ) );\n    }else{\n      engine.log( " AutomatedTask DateStringWarning:" +\n                  " CellValue should be YYYY-MM-DD" );\n      let numMillSec = Date.parse( strCellValue );\n      if( isNaN( numMillSec ) ){\n        throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n                         " Invalid Date Value \\n" );\n      }\n      engine.setData( arrMultiPocketC[i], new java.sql.Date( numMillSec ) );\n    }\n\n  \/\/ \u25bd\u25bdCase: DATETIME\u25bd\u25bd\n  }else if( arrMultiPocketC[i].matchDataType("DATETIME") ){\n    let strDatetimeTmp = strCellValue;\n    if( regBpmsYMD.test( strDatetimeTmp ) ){\n      strDatetimeTmp += "T00:00:00";\n    }\n    let numMillSec = Date.parse( strDatetimeTmp );\n    if( isNaN( numMillSec ) ){\n      throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n                       " Invalid Datetime Value \\n" );\n    }\n    engine.setData( arrMultiPocketC[i], new java.sql.Timestamp( numMillSec ) );\n\n  \/\/ \u25bd\u25bdCase: SELECT_SINGLE\u25bd\u25bd\n  }else if( arrMultiPocketC[i].matchDataType("SELECT_SINGLE") ){\n    let arrTmp = new java.util.ArrayList();\n    arrTmp.add( strCellValue );\n    engine.setData( arrMultiPocketC[i], arrTmp );\n\n  \/\/ \u25bd\u25bdCase: QUSER\u25bd\u25bd\n  }else if( arrMultiPocketC[i].matchDataType("QUSER") ){\n    let quserTmp;\n    if( regPositiveInt.test( strCellValue ) ){\n      quserTmp = quserDao.findById( parseInt(strCellValue) );\n      if( quserTmp === null ){\n        throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n                         " Invalid User Value \\n" );\n      }\n      engine.setData( arrMultiPocketC[i], quserTmp );\n    }else if( regEmail.test( strCellValue ) ){\n      quserTmp = quserDao.findByEmail( strCellValue );\n      if( quserTmp === null ){\n        throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n                         " Invalid User Value \\n" );\n      }\n      engine.setData( arrMultiPocketC[i], quserTmp );\n    }else{\n      throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n                       " CellValue must be UserId or UserEmail \\n" );\n    }\n\n  \/\/ \u25bd\u25bdCase: QGROUP\u25bd\u25bd\n  }else if( arrMultiPocketC[i].matchDataType("QGROUP") ){\n    let qorgTmp;\n    if( regPositiveInt.test( strCellValue ) ){\n      qorgTmp = qgroupDao.findById( parseInt(strCellValue) );\n      if( qorgTmp === null ){\n        throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n                         " Invalid Organization Value \\n" );\n      }\n      engine.setData( arrMultiPocketC[i], qorgTmp );\n    }else{\n      throw new Error( "\\n AutomatedTask UnexpectedStringError:" +\n                       " CellValue must be OrganizationId \\n" );\n    }\n\n  \/\/ \u25bd\u25bdCase: error\u25bd\u25bd\n  }else{ \/\/ Unknown\n    throw new Error( "\\n AutomatedTask CriticalError:" +\n                     " DataType Unmatched \\n" );\n  }\n}\n\nif ( numPocketD1 !== null ){ \n  engine.setData( numPocketD1, new java.math.BigDecimal( numTsvLines ) );\n}\nif ( numPocketD2 !== null ){ \n  engine.setData( numPocketD2, new java.math.BigDecimal( numTsvNoLf ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\nfunction alpha2Decimal ( str ){\n  \/\/ alpha2Decimal ( alpha: string ): number\n  \/\/ alpha2Decimal ('a') -> 1\n  \/\/ alpha2Decimal ('AA') -> 27\n\n  str = str.toUpperCase();\n  let numSum = 0;\n  const numLen = str.length;\n  let   i      = numLen;\n  while( -- i > -1 ){\n    numSum += ( str.charCodeAt( i ) - 64 ) * Math.pow( 26, numLen - 1 - i ); \n  }\n  return numSum;\n}\n\n\n\/\/ Parses TSV string as two-dimensional rectangular data matrix and creates a 2D array.\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\/*\nNOTES\n- If you place this "Automated Step" in the Workflow diagram, the Extraction will be executed.\n- Extracts any cell in the TSV text (specified using A1 notation).\n    - If specify `B3` in the config, the third row of column B (second column) will be extracted.\n    - If specify `B#{#q_i}` in the config, the i-th row will be extracted.\n    - Up to eight cells can be extracted at the same time.\n- The number of lines of TSV text can also be extracted at the same time.\n- "A1 notation" is a syntax used to define a cell (or cell range) using the column letter and row number.\n    - The top left cell (cell in column A, first row) is specified as `A1`.\n    - The cell to the right of that is specified as `B1`, and the cell below is specified as `A2`.\n- An error will occur if the TSV string is an empty string.\n    - An error will occur if the specified cell does not exist.\n- If there is a blank line in the input TSV text, it will be skipped.\n    - The line feed code for the last line is not added either.\n- The data will be deleted if the extracted Cell string is empty. (overwritte with `null`)\n- Numerical String is evaluated with `parseFloat()` after removing the comma.\n    - An error will occur, if failed to parse.\n    - Truncation after the decimal point depends on the format of DataItem definition\n- Date or Datetime String is evaluated with `Date()`\n    - An error will occur, if failed to parse.\n    - `new Date('December 17, 1995 03:24:00')`\n    - `new Date('1995-12-17T03:24:00')`\n    - `new Date('1995-12-17 03:24')`\n    - `new Date('1995-12-17')`\n        - In principle, "format including time" is interpreted as local time.\n        - In principle, "date only format" is interpreted as UTC time.\n        - However, in case of "YYYY-MM-DD", "T00:00:00" is added and localized.\n- SELECT String  will be stored only if match the Choice ID (option id)\n    - NO ERROR will occur (cannot be detected), even if it does not match any ID.\n- QUSER String will be stored only if match the user id or email address.\n    - An error will occur, if user not found.\n- QORG String will be stored only if match the organization id.\n    - An error will occur, if organization not found.\n\nNOTES-ja\n- \u3053\u306e\uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u3092\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u56f3\u306b\u914d\u7f6e\u3059\u308c\u3070\u3001\u6848\u4ef6\u5230\u9054\u306e\u5ea6\u306b\u300c\u62bd\u51fa\u51e6\u7406\u300d\u304c\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\n- TSV\u30c6\u30ad\u30b9\u30c8\u5185\u306e\u4efb\u610f\u306e\u30bb\u30eb\uff08A1\u8868\u8a18\u3067\u6307\u5b9a\uff09\u3092\u81ea\u52d5\u7684\u306b\u62bd\u51fa\u3057\u307e\u3059\u3002\n    - \uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u306e\u30b3\u30f3\u30d5\u30a3\u30b0\u306b\u3066 `B3` \u3068\u6307\u5b9a\u3057\u3066\u304a\u3051\u3070\u3001B\u5217\uff08\u7b2c2\u5217\u76ee\uff09\u306e3\u884c\u76ee\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\n    - \uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u306e\u30b3\u30f3\u30d5\u30a3\u30b0\u306b\u3066 `B#{#q_i}` \u3068\u6307\u5b9a\u3057\u3066\u304a\u3051\u3070\u3001B\u5217\uff08\u7b2c2\u5217\u76ee\uff09\u306ei\u884c\u76ee\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\n    - \u540c\u6642\u306b8\u30bb\u30eb\u307e\u3067\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002\n- TSV\u30c6\u30ad\u30b9\u30c8\u306e\u884c\u6570\u3082\u540c\u6642\u306b\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002\n- "A1\u8868\u8a18" \u3068\u306f\u3001\u5217\u6587\u5b57\u3068\u884c\u756a\u53f7\u3092\u4f7f\u7528\u3057\u3066\u30bb\u30eb (\u307e\u305f\u306f\u30bb\u30eb\u306e\u7bc4\u56f2) \u3092\u5b9a\u7fa9\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u69cb\u6587\u3067\u3059\u3002\n    - \u6700\u3082\u5de6\u4e0a\u306e\u30bb\u30eb\uff08A\u52171\u884c\u76ee\u306e\u30bb\u30eb\uff09\u306f `A1` \u3067\u3059\u3002\n    - \u305d\u306e\u53f3\u96a3\u306e\u30bb\u30eb\u306f `B1` \u3001\u4e0b\u96a3\u306e\u30bb\u30eb\u306f `A2` \u3067\u3059\u3002\n- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306b\u7a7a\u884c\u304c\u3042\u308b\u5834\u5408\u3001\u30b9\u30ad\u30c3\u30d7\u3055\u308c\u307e\u3059\u3002\n    - \u51fa\u529bTSV\u306e\u6700\u7d42\u884c\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u4ed8\u4e0e\u3055\u308c\u307e\u305b\u3093\u3002\n- TSV\u6587\u5b57\u5217\u304c\u7a7a\u6587\u5b57\u5217\u306e\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002\n    - \u6307\u5b9a\u30bb\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002\n- \u62bd\u51fa\u3057\u305f\u6587\u5b57\u5217\u304c\u7a7a\u6587\u5b57\u5217\u306e\u5834\u5408\u3001\u683c\u7d0d\u5148\u306e\u30c7\u30fc\u30bf\u306f\u524a\u9664\u3055\u308c\u307e\u3059\uff08`null` \u3067\u4e0a\u66f8\uff09\n- \u6570\u5024\u6587\u5b57\u5217\u306f\u3001\u30ab\u30f3\u30de\uff08\u6841\u533a\u5207\u308a\u6587\u5b57\uff09\u304c\u9664\u53bb\u3055\u308c\u305f\u4e0a\u3067\u3001yparseFloat()` \u95a2\u6570\u3067\u8a55\u4fa1\u3055\u308c\u307e\u3059\n    - \u6587\u5b57\u5217\u306e\u89e3\u6790\u306b\u5931\u6557\u3057\u305f\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\n    - \u5c0f\u6570\u70b9\u4ee5\u4e0b\u306e\u5207\u308a\u6368\u3066\u51e6\u7406\u306f\u3001\u683c\u7d0d\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u66f8\u5f0f\u306b\u5bc4\u308a\u307e\u3059\n- \u65e5\u4ed8\u6587\u5b57\u5217\u304a\u3088\u3073\u65e5\u6642\u6587\u5b57\u5217\u306f\u3001`Date()` \u95a2\u6570\u3067\u8a55\u4fa1\u3055\u308c\u307e\u3059\n    - \u6587\u5b57\u5217\u306e\u89e3\u6790\u306b\u5931\u6557\u3057\u305f\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\n    - `new Date('December 17, 1995 03:24:00')`\n    - `new Date('1995-12-17T03:24:00')`\n    - `new Date('1995-12-17 03:24')`\n    - `new Date('1995-12-17')`\n        - \u306a\u304a\u300c\u6642\u523b\u3092\u542b\u3080\u5f62\u5f0f\u300d\u306f\u30ed\u30fc\u30ab\u30eb\u30bf\u30a4\u30e0\u3068\u3057\u3066\u89e3\u91c8\u3055\u308c\u307e\u3059\n        - \u307e\u305f\u300c\u65e5\u4ed8\u306e\u307f\u306e\u5f62\u5f0f\u300d\u306f\u539f\u5247 UTC \u6642\u523b\u3068\u89e3\u91c8\u3055\u308c\u307e\u3059\n        - \u305f\u3060\u3057 "YYYY-MM-DD" \u66f8\u5f0f\u306f "T00:00:00" \u304c\u81ea\u52d5\u4ed8\u52a0\uff08\u30ed\u30fc\u30ab\u30eb\u30bf\u30a4\u30e0\u5316\uff09\u3055\u308c\u307e\u3059\n- \u9078\u629e\u6587\u5b57\u5217\u306f\u3001\u9078\u629e\u80a2ID\u306b\u5408\u81f4\u3059\u308b\u5834\u5408\u306b\u9650\u308a\u4ee3\u5165\u3055\u308c\u307e\u3059\n    - \u306a\u304a\u3001\u3044\u305a\u308c\u306eID\u306b\u3082\u5408\u81f4\u3057\u306a\u3044\u5834\u5408\u3067\u3082\u3001\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u305b\u3093\uff08\u691c\u77e5\u3067\u304d\u307e\u305b\u3093\uff09\n- \u30e6\u30fc\u30b6\u3092\u8868\u3059\u6587\u5b57\u5217\u306f\u3001\u30e6\u30fc\u30b6ID\u3082\u3057\u304f\u306f\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u306b\u5408\u81f4\u3059\u308b\u5834\u5408\u306b\u9650\u308a\u4ee3\u5165\u3055\u308c\u307e\u3059\n    - \u30e6\u30fc\u30b6\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\n- \u7d44\u7e54\u3092\u8868\u3059\u6587\u5b57\u5217\u306f\u3001\u7d44\u7e54ID\u306b\u5408\u81f4\u3059\u308b\u5834\u5408\u306b\u9650\u308a\u4ee3\u5165\u3055\u308c\u307e\u3059\n    - \u7d44\u7e54\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\n*\/\n\n\/*\nAPPENDIX\n- Error Log sample1\n    - AutomatedTask ConfigError: Config {B:ID} must be less than TSV size\n- Error Log sample2 (Wrong Email, Wrong Id, etc)\n    - AutomatedTask UnexpectedStringError: Invalid User Value \n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n