{"id":96508,"date":"2020-10-16T15:13:35","date_gmt":"2020-10-16T06:13:35","guid":{"rendered":"https:\/\/support.questetra.com\/?p=96508"},"modified":"2025-01-28T10:25:30","modified_gmt":"2025-01-28T01:25:30","slug":"singleline-tsv-string-extract-cell","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","title":{"rendered":"Singleline TSV String, Extract Cell"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Singleline TSV String, Extract Cell<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Extracts the cell value of the specified ID, starting from zero. The extracted cell 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.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A: Set Singleline TSV String<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B: Set ID of Cell to be extracted<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> C: Select DATA to store Extracted Cell String (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\/*\nNOTES\n- An error will occur, if Singleline TSV String is empty.\n- An error will occur, if ID does not exist (eg. greater than the number of tabs)\n- The data will be deleted if the extracted Cell string is empty. (overwritte with &quot;null&quot;)\n- Numerical String is evaluated with &quot;parseFloat()&quot; 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 &quot;Date()&quot;\n    - An error will occur, if failed to parse.\n    - new Date(&#39;December 17, 1995 03:24:00&#39;)\n    - new Date(&#39;1995-12-17T03:24:00&#39;)\n    - new Date(&#39;1995-12-17 03:24&#39;)\n    - new Date(&#39;1995-12-17&#39;)\n        - In principle, &quot;format including time&quot; is interpreted as local time.\n        - In principle, &quot;date only format&quot; is interpreted as UTC time.\n        - However, in case of &quot;YYYY-MM-DD&quot;, &quot;T00:00:00&quot; 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\n- \u5358\u4e00\u884cTSV\u6587\u5b57\u5217\u304c\u7a7a\u6587\u5b57\u5217\u306e\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\n- \u6307\u5b9a\u3057\u305f\u62bd\u51faID\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\uff08TSV\u306e\u30bf\u30d6\u6570\u3092\u8d85\u3048\u308b\u5834\u5408\u306a\u3069\uff09\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\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\uff08null \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\u3001&quot;parseFloat()&quot; \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&quot;Date()&quot; \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(&#39;December 17, 1995 03:24:00&#39;)\n    - new Date(&#39;1995-12-17T03:24:00&#39;)\n    - new Date(&#39;1995-12-17 03:24&#39;)\n    - new Date(&#39;1995-12-17&#39;)\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 &quot;YYYY-MM-DD&quot; \u66f8\u5f0f\u306f &quot;T00:00:00&quot; \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\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strTsv       = configs.get( &quot;StrConfA&quot; ) + &quot;&quot;;     \/\/ required\nconst strCellId    = configs.get( &quot;StrConfB&quot; ) + &quot;&quot;;     \/\/ required\nconst multiPocketC = configs.getObject( &quot;SelectConfC&quot; ); \/\/ required\n\nif( strTsv === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {A: TSV} is empty \\n&quot; );\n}\nif( strCellId === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {B: ID} not specified \\n&quot; );\n}\nconst regPositiveInt = \/^([1-9]\\d*|0)$\/; \/\/ RegExp\nif( ! regPositiveInt.test( strCellId ) ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {B:ID} must be a positive integer or zero \\n&quot; );\n}\nlet numCellId = parseInt( strCellId, 10 );\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (nothing)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nconst arrTsv       = strTsv.split(&quot;\\t&quot;);\nengine.log( &quot; AutomatedTask Tsv.length: &quot; + arrTsv.length );\nengine.log( &quot; AutomatedTask ID of Cell: &quot; + strCellId );\nif( arrTsv.length &lt; numCellId ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {B:ID} must be less than TSV length\\n&quot; );\n}\nconst strCellValue = arrTsv[ numCellId ];\nif( strCellValue === &quot;&quot; ){\n  engine.log( &quot; AutomatedTask CellString[&quot; + numCellId + &quot;]: (empty)&quot; );\n  engine.setData( multiPocketC, null );\n  return;\n}\nengine.log( &quot; AutomatedTask CellString[&quot; + numCellId + &quot;]: &quot; + strCellValue );\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nconst regBpmsYMD = \/^\\d{4}-\\d{2}-\\d{2}$\/; \/\/ RegExp\nconst regEmail = \/^[\\w][\\w_\\.\\-\\+]*@[\\w\\.\\-]+\\.[a-zA-Z]+$\/; \/\/ RegExp\n\n\/\/ ref) Retrieving \/ Updating\n\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574771-R2301\n\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574771-R2301\n\nif( multiPocketC.matchDataType(&quot;STRING&quot;) ){\n  engine.setData( multiPocketC, strCellValue );\n\n}else if( multiPocketC.matchDataType(&quot;DECIMAL&quot;) ){\n  let numCellValue = parseFloat( strCellValue.replace(\/,\/g, &quot;&quot;) );\n  if( isNaN( numCellValue ) ){\n    throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                     &quot; Invalid Numeric Value \\n&quot; );\n  }\n  engine.setData( multiPocketC, new java.math.BigDecimal( numCellValue ) );\n\n}else if( multiPocketC.matchDataType(&quot;DATE&quot;) ){\n  if( regBpmsYMD.test( strCellValue ) ){\n    engine.setData( multiPocketC, java.sql.Date.valueOf( strCellValue ) );\n  }else{\n    engine.log( &quot; AutomatedTask DateStringWarning:&quot; +\n                &quot; CellValue should be YYYY-MM-DD&quot; );\n    let numMillSec = Date.parse( strCellValue );\n    if( isNaN( numMillSec ) ){\n      throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                       &quot; Invalid Date Value \\n&quot; );\n    }\n    engine.setData( multiPocketC, new java.sql.Date( numMillSec ) );\n  }\n\n}else if( multiPocketC.matchDataType(&quot;DATETIME&quot;) ){\n  let strDatetimeTmp = strCellValue;\n  if( regBpmsYMD.test( strDatetimeTmp ) ){\n    strDatetimeTmp += &quot;T00:00:00&quot;;\n  }\n  let numMillSec = Date.parse( strDatetimeTmp );\n  if( isNaN( numMillSec ) ){\n    throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                     &quot; Invalid Datetime Value \\n&quot; );\n  }\n  engine.setData( multiPocketC, new java.sql.Timestamp( numMillSec ) );\n\n}else if( multiPocketC.matchDataType(&quot;SELECT_SINGLE&quot;) ){\n  let arrTmp = new java.util.ArrayList();\n  arrTmp.add( strCellValue );\n  engine.setData( multiPocketC, arrTmp );\n\n}else if( multiPocketC.matchDataType(&quot;QUSER&quot;) ){\n  let quserTmp;\n  if( regPositiveInt.test( strCellValue ) ){\n    quserTmp = quserDao.findById( parseInt(strCellValue) );\n    if( quserTmp === null ){\n      throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                       &quot; Invalid User Value \\n&quot; );\n    }\n    engine.setData( multiPocketC, quserTmp );\n  }else if( regEmail.test( strCellValue ) ){\n    quserTmp = quserDao.findByEmail( strCellValue );\n    if( quserTmp === null ){\n      throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                       &quot; Invalid User Value \\n&quot; );\n    }\n    engine.setData( multiPocketC, quserTmp );\n  }else{\n    throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                     &quot; CellValue must be UserId or UserEmail \\n&quot; );\n  }\n\n}else if( multiPocketC.matchDataType(&quot;QGROUP&quot;) ){\n  let qorgTmp;\n  if( regPositiveInt.test( strCellValue ) ){\n    qorgTmp = qgroupDao.findById( parseInt(strCellValue) );\n    if( qorgTmp === null ){\n      throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                       &quot; Invalid Organization Value \\n&quot; );\n    }\n    engine.setData( multiPocketC, qorgTmp );\n  }else{\n    throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                     &quot; CellValue must be OrganizationId \\n&quot; );\n  }\n\n}else{ \/\/ Unknown\n  throw new Error( &quot;\\n AutomatedTask CriticalError:&quot; +\n                   &quot; DataType Unmatched \\n&quot; );\n}\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nAPPENDIX\n- Error Log sample1\n    - AutomatedTask ConfigError: Config {B:ID} must be less than TSV length\n- Error Log sample2 (Wrong Email, Wrong Id, etc)\n    - AutomatedTask UnexpectedStringError: Invalid User Value \n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADkElEQVRYR8WXW0gUURjHf+MtK7to\nERF2AUUrNsmCEnzYLkJJlhBBJfWwFe66CFkbaA\/1nCAlIblG5kNh+xR0kS7kluCSFSRsmRU+ZFlk\nt7VytfIyMbNNu267O2ej2PM2M+f7n\/\/5zv\/7\/mckYjwk4fUbmILMViTWIpOLxCIg9Ve8B5kXSHQi\ncxuJi5gZEsHWJ9DEXH5QCViAZBFQ4BtgJ4lqTLyNFBOZgB0LEjXAVMGFg6d5kTmEBXu4+PAEGjgF\nlP3lwsFh9ZixhsIKTcBOMxI7\/9HiPhiZC1goCcb8k8C\/3bluJiYS8J15vcjONy3YRHJ8Mjf7bvJ1\n5KtIiJaJskBN+An41N4jIriSzBLq8utIjEuk8l4lp54ochEeXpLI1KrDT6CBE0CFCEyjsRFTtgkJ\nidbXrRS0FIiEBc6pxcwB5YWPgNJk4KNInWfNyOLyhstkz8xWQz3fPZS7ymnuaY6GhNInZinNykfA\nzi4kzokgHF5+mKMrj6rn7xO3jKPHQYnzD4FHhpPZjYXzWgYagT0iBK5uvMq6eesYk8dISUxRQ3oH\ne9lxawcd7zpEILQ5ZzGzV8vAQyRy9aIL5xfStKaJ55+fM\/B9gKKFRaoORsZHOO4+TtX9Kj0I\/3eZ\nTiys0DLwKcBYwoIoyt+3eB+1j2pxf3KrlZA6yedHnR86MV4xRlOSHsykaQRkPerTEqfRtrmNtOQ0\nNd1dni71OXe2L3GDI4PRl6QZSZiAdamV6tXVON84Kb5RrC5ak1fDfsN+EuIS1OeWly0UXS\/S24v\/\newAB3SNwrHewPWN7RPD+4X5Md0xce3VNhETAEdiJKMK8OXk4ChyMjY\/h6ndNADekGn4fw7g8zunu\n05S1C5hokAgjluGxVceoWFbBmadn1KYTOLSj0Ury2cAzttzYolaKzphQhhEbkavYRcb0jJDp1cSp\nidE76qXqXhV1XXVRNaKwrVgznu6BbvIv5YcEVTJ0MOegak6CYgxqxUpUCDNSOt6RFUcwzjPS\/rYd\n210bD94\/mEAifWo6pUtKseXYmJKg7AO1F5x8fBL7Ezt93r5QpIPMSJkSZMfubW4MaQaGRodQxBUn\nxakLOF87f7ufQk7xhqT4JIZHh1VfUEa8FM\/khMl8+fEFa7s12KjC2LESGcWFRE9hYb\/LhLmQaBEx\nvZJpJGJ6Kf0\/mYjyWu7PRAx\/TDQSMf01C5RyzH5O\/7rexAJ\/Av2AWTB+TSFiAAAAAElFTkSuQmCC\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1Ip0joGj7lIXUyU6YcbPNiyr2YppmlzIt\/view?usp=drivesdk\" target=\"_blank\">Singleline-Tsv-String-Extract-Cell.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-11-21 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1iXgYEFp3HtT5SArK4u22t74xG5nFKMcE\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Singleline-Tsv-String-Extract-Cell-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-28 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"> The Addon-import feature is available with <span style=\"background-color:rgba(0, 0, 0, 0);color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>An error will occur if the single line TSV String is empty<\/li>\n\n\n\n<li>An error will occur if the ID does not exist (e.g. greater than the number of tabs)<\/li>\n\n\n\n<li>The data will be deleted if the extracted cell string is empty (overwritten with &#8220;null&#8221;)<\/li>\n\n\n\n<li>A numerical string is evaluated with the &#8220;parseFloat()&#8221; function after removing the comma\n<ul class=\"wp-block-list\">\n<li>An error will occur if the string parse fails<\/li>\n\n\n\n<li>Truncation after the decimal point depends on the format of the Data Item<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A Date or Datetime String is evaluated with &#8220;Date()&#8221;\n<ul class=\"wp-block-list\">\n<li>An error will occur if the string parse fails<\/li>\n\n\n\n<li>new Date(&#8216;December 17, 1995 03:24:00&#8217;)<\/li>\n\n\n\n<li>new Date(&#8216;1995-12-17T03:24:00&#8217;)<\/li>\n\n\n\n<li>new Date(&#8216;1995-12-17 03:24&#8217;)<\/li>\n\n\n\n<li>new Date(&#8216;1995-12-17&#8217;)\n<ul class=\"wp-block-list\">\n<li>In principle, &#8220;format including time&#8221; is interpreted as local time<\/li>\n\n\n\n<li>In principle, &#8220;date only format&#8221; is interpreted as UTC time<\/li>\n\n\n\n<li>However, in case of &#8220;YYYY-MM-DD&#8221;, &#8220;T00:00:00&#8221; is added and localized<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select strings will be stored only if they match the Choice ID\n<ul class=\"wp-block-list\">\n<li>NO ERROR will occur (cannot be detected) even if it does not match any ID<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A QUSER String will be stored only if it matches the User ID or email address\n<ul class=\"wp-block-list\">\n<li>An error will occur if the user is not found<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A QORG String will be stored only if it matches the Organization ID\n<ul class=\"wp-block-list\">\n<li>An error will occur if the organization is not found<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener noreferrer\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"96511\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/attachment\/singleline-tsv-string-extract-cell-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Singleline-TSV-String-Extract-Cell-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell 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.\" class=\"wp-image-96511\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Error Log sample1\n<ul class=\"wp-block-list\">\n<li>AutomatedTask ConfigError: Config {B:ID} must be less than TSV length<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Error Log sample2 (Wrong Email, Wrong Id, etc)\n<ul class=\"wp-block-list\">\n<li>AutomatedTask UnexpectedStringError: Invalid User Value<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"qULyqkMyOX\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-extract-cells-2025\/\">TSV String: Extract Cells<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;TSV String: Extract Cells&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-extract-cells-2025\/embed\/#?secret=qDXAlY8blY#?secret=qULyqkMyOX\" data-secret=\"qULyqkMyOX\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"Qgi1FxvNch\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/multiline-string-dequeue-first\/\">Multiline String, Dequeue First<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Multiline String, Dequeue First&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/multiline-string-dequeue-first\/embed\/#?secret=iTZvLlQaIu#?secret=Qgi1FxvNch\" data-secret=\"Qgi1FxvNch\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"DKm3Hn59DB\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/\">Google Sheets: Sheet, Append TSV<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Google Sheets: Sheet, Append TSV&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/google-sheets-sheet-append-tsv\/embed\/#?secret=VaLOqxNsps#?secret=DKm3Hn59DB\" data-secret=\"DKm3Hn59DB\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell 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.<\/p>\n","protected":false},"author":2,"featured_media":96509,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell 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.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[389],"class_list":["post-96508","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":2,"uagb_excerpt":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell 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.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-p6A","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":96514,"url":"https:\/\/support.questetra.com\/ja\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":96508,"position":0},"title":"\u5358\u4e00\u884cTSV\u6587\u5b57\u5217, \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"\u6307\u5b9aID\u306e\u30bb\u30eb\u5024\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002ID\u306f\u30bc\u30ed\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\u3002\u62bd\u51fa\u3057\u305f\u30bb\u30eb\u6587\u5b57\u5217\u306f\u3001\u6587\u5b57\u5217\u578b\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u683c\u7d0d\u3067\u304d\u307e\u3059\u3002\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","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u5358\u4e00\u884cTSV\u6587\u5b57\u5217, \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84787,"url":"https:\/\/support.questetra.com\/en\/addons\/table-duplicate\/","url_meta":{"origin":96508,"position":1},"title":"Table, Duplicate","author":"IMAMURA, Genichi","date":"2020-02-26","format":false,"excerpt":"Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Table, Duplicate","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":145065,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-csv-string-extract-cell-2023\/","url_meta":{"origin":96508,"position":2},"title":"Singleline CSV String, Extract Cell","author":"Peter Glover","date":"2023-04-11","format":false,"excerpt":"Extracts the cell value of the specified ID, starting from zero. The extracted cell 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.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/04\/singleline-csv-string-extract-cell-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/04\/singleline-csv-string-extract-cell-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/04\/singleline-csv-string-extract-cell-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/04\/singleline-csv-string-extract-cell-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/04\/singleline-csv-string-extract-cell-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82159,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":96508,"position":3},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf\u3055\u308c\u305f\u8907\u6570\u306e\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u8907\u6570\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"string:0,date:2,select:3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82141,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":96508,"position":4},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u4e00\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"0,2,3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96805,"url":"https:\/\/support.questetra.com\/ja\/addons\/any-data-type-output-to-log\/","url_meta":{"origin":96508,"position":5},"title":"\u4efb\u610f\u30c7\u30fc\u30bf\u578b, \u30ed\u30b0\u306b\u51fa\u529b","author":"IMAMURA, Genichi","date":"2020-10-22","format":false,"excerpt":"\u696d\u52d9\u30c7\u30fc\u30bf\u3092\u300c\u81ea\u52d5\u51e6\u7406\u30ed\u30b0\u300d\u306b\u51fa\u529b\u3057\u307e\u3059\u3002\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u306e\u7ba1\u7406\u8005\u7279\u6a29\u3092\u6301\u3064\u30e6\u30fc\u30b6\u306f\u3001\u6848\u4ef6\u304c\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u6642\u70b9\u3067\u4fdd\u5b58\u3055\u308c\u3066\u3044\u305f\u30c7\u30fc\u30bf\u3092\u691c\u8a3c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u4efb\u610f\u30c7\u30fc\u30bf\u578b, \u30ed\u30b0\u306b\u51fa\u529b","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/any-data-type-Output-to-Log-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/any-data-type-Output-to-Log-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/any-data-type-Output-to-Log-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/any-data-type-Output-to-Log-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/any-data-type-Output-to-Log-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=96508"}],"version-history":[{"count":12,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96508\/revisions"}],"predecessor-version":[{"id":170151,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96508\/revisions\/170151"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/96509"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=96508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=96508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=96508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}