{"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-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-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;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> 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-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=\"KvKmsItsbi\"><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=\"\u201cTSV String: Extract Cells\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-extract-cells-2025\/embed\/#?secret=HWm833GO3z#?secret=KvKmsItsbi\" data-secret=\"KvKmsItsbi\" 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=\"TUPxzrEUUF\"><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; visibility: hidden;\" title=\"\u201cMultiline String, Dequeue First\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/multiline-string-dequeue-first\/embed\/#?secret=hjIfS8lleZ#?secret=TUPxzrEUUF\" data-secret=\"TUPxzrEUUF\" 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=\"44OaFjtV9Z\"><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; visibility: hidden;\" title=\"\u201cGoogle Sheets: Sheet, Append TSV\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/embed\/#?secret=e1Yh6JRExg#?secret=44OaFjtV9Z\" data-secret=\"44OaFjtV9Z\" 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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_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],"faq_section":[],"class_list":["post-96508","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"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-related-posts":[{"id":82149,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":96508,"position":0},"title":"Questetra BPMS: Process, Batch Extract as TSV","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as \"string:0,date:2,select:3\". Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: Process, Batch Extract as TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-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\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-en.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-en.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-en.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-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":170120,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-extract-cells-2025\/","url_meta":{"origin":96508,"position":1},"title":"TSV String: Extract Cells","author":"IMAMURA, Genichi","date":"2025-01-24","format":false,"excerpt":"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.","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\/2025\/01\/tsv-string-extract-cells-2025-en.png?fit=1200%2C628&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/tsv-string-extract-cells-2025-en.png?fit=1200%2C628&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/tsv-string-extract-cells-2025-en.png?fit=1200%2C628&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/tsv-string-extract-cells-2025-en.png?fit=1200%2C628&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/tsv-string-extract-cells-2025-en.png?fit=1200%2C628&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82133,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":96508,"position":2},"title":"Questetra BPMS: Process, Extract as TSV","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"Extracts process data as single-line TSV string. Items are specified in CSV format such as \"0,2,3\". Tab code and line feed code are automatically deleted. Discussion type, Table type, Guide-Panel type cannot be extracted (Warning Log).","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: Process, Extract as TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-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\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-en.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-en.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-en.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-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96520,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-dequeue-first\/","url_meta":{"origin":96508,"position":3},"title":"Multiline String, Dequeue First","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Removes the first line from the multiline string. One line less than the original string. By placing in a loop flow or in a recursive workflow, data list can be processed sequentially.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Multiline String, Dequeue First","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Multiline-String-Dequeue-First-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\/10\/Multiline-String-Dequeue-First-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Multiline-String-Dequeue-First-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Multiline-String-Dequeue-First-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Multiline-String-Dequeue-First-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":83944,"url":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-matched-lines\/","url_meta":{"origin":96508,"position":4},"title":"Two Tsv Strings, Extract Cell-Matched Lines","author":"IMAMURA, Genichi","date":"2020-01-29","format":false,"excerpt":"Extracts B lines that DO exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Two Tsv Strings, Extract Cell-Matched Lines","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-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\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":83960,"url":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-mismatched-lines\/","url_meta":{"origin":96508,"position":5},"title":"Two Tsv Strings, Extract Cell-Mismatched Lines","author":"IMAMURA, Genichi","date":"2020-01-29","format":false,"excerpt":"Extracts B lines that DO NOT exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are returned.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Two Tsv Strings, Extract Cell-Mismatched Lines","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-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\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"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","_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"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=96508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}