{"id":170120,"date":"2025-01-24T12:24:35","date_gmt":"2025-01-24T03:24:35","guid":{"rendered":"https:\/\/support.questetra.com\/?p=170120"},"modified":"2025-01-29T17:02:32","modified_gmt":"2025-01-29T08:02:32","slug":"tsv-string-extract-cells-2025","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-extract-cells-2025\/","title":{"rendered":"TSV String: Extract Cells"},"content":{"rendered":"\n

TSV String, Extract Cells<\/strong><\/h4>\n\n\n\n

translate<\/span> TSV\u6587\u5b57\u5217, \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa<\/a><\/p>\n\n\n\n

Extracts the values of specified cells in A1 notation. The extracted string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data if the format allows.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: Set TSV String *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB<\/dt>
B: Set A1 notations of Extract Cells to each line (up to 8) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfC1<\/dt>
C1: Select DATA to store Extracted Cell String (update)<\/dd>\n
SelectConfC2<\/dt>
C2: Select DATA to store Extracted Cell String (update)<\/dd>\n
SelectConfC3<\/dt>
C3: Select DATA to store Extracted Cell String (update)<\/dd>\n
SelectConfC4<\/dt>
C4: Select DATA to store Extracted Cell String (update)<\/dd>\n
SelectConfC5<\/dt>
C5: Select DATA to store Extracted Cell String (update)<\/dd>\n
SelectConfC6<\/dt>
C6: Select DATA to store Extracted Cell String (update)<\/dd>\n
SelectConfC7<\/dt>
C7: Select DATA to store Extracted Cell String (update)<\/dd>\n
SelectConfC8<\/dt>
C8: Select DATA to store Extracted Cell String (update)<\/dd>\n<\/div>\n
SelectConfD1<\/dt>
D1: Select NUMERIC for Number of TSV Lines (update)<\/dd>\n
SelectConfD2<\/dt>
D2: Select NUMERIC for Number of TSV Lines Trimmed (update)<\/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\/en-us\/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