{"id":171969,"date":"2025-04-07T16:10:19","date_gmt":"2025-04-07T07:10:19","guid":{"rendered":"https:\/\/support.questetra.com\/?p=171969"},"modified":"2025-04-22T10:17:16","modified_gmt":"2025-04-22T01:17:16","slug":"tsv-string-extract-by-regexp-for-each-line-2025","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-extract-by-regexp-for-each-line-2025\/","title":{"rendered":"#TSV-String: Extract by RegExp for each Line"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-background\" style=\"background-color:#084A28;color:#ffffff;margin-top:var(--wp--preset--spacing--30);margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--10);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--10);padding-left:var(--wp--preset--spacing--20)\"><strong>#TSV-String: Extract by RegExp for each Line<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-background has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#084A28;color:#ffffff;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--30);padding-bottom:0;padding-left:var(--wp--preset--spacing--30)\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-extract-by-regexp-for-each-line-2025\/\"><span class=\"material-icons\">translate<\/span> #TSV\u6587\u5b57\u5217: \u5404\u884c\u3054\u3068\u306b\u6b63\u898f\u8868\u73fe\u3067\u62bd\u51fa<\/a><\/p>\n\n\n\n<p class=\"has-background mt-0 pt-0 wp-block-paragraph\" style=\"border:2px solid #267137;color:#333;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--30);margin-left:0;padding-top:var(--wp--preset--spacing--10);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--10);padding-left:var(--wp--preset--spacing--20)\">Extracts a string that matches the RegExp for each line. For example, if you set an email address regular expression, the email address in the specified cell will be added as a new cell at the end of the line. If there is no match, an empty string will be added. It is also possible to limit extraction to regular expression capture groups by specifying the capture group ID (from 1).<\/p>\n\n\n\n<figure class=\"wp-block-image alignright has-custom-border is-style-default\"><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=\"Auto Step icon\" class=\"has-border-color has-ast-global-color-6-border-color\" style=\"border-width:0.5em\"\/><\/figure>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Configs for this Auto Step<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"margin: 0 0 -0.7em 0\">\n<div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Main\"><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfA<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">A: Set Input TSV String<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B1: Set Regular Expression (eg: &#8220;(\\d{3}-\\d{4})|(\\d{7})&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">BoolConfB2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B2: Case Sensitive or Case should be Ignored<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B3: Set Column IDs (Cell IDs) to Search for (eg: &#8220;0,2,3&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB4<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B4: If necessary, Set Capturing Group IDs (eg &#8220;0,1&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfC<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C: Select DATA to store Output TSV Strings (update)<span style=\"color:#990000;\"> *<\/span><\/dd>\n<\/div>\n<div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Advanced\"><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfD1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">D1: Select NUMERIC for Number of TSV Lines (update)<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfD2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">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<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">Script (click to open)<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ Script Example of Business Process Automation\n\/\/ for &#39;engine type: 3&#39; (&quot;GraalJS standard mode&quot;)\n\/\/ cf. &#39;engine type: 2&#39; (&quot;GraalJS Nashorn compatible mode&quot;) (renamed from &quot;GraalJS&quot; at 20230526)\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; );     \/\/ REQUIRED\n  if( strTsv === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A: TSV} is empty \\n&quot; );\n  }\n  const numTsvLines = strTsv.split(&quot;\\n&quot;).length;\n  const numTsvNoLf  = strTsv.replace(\/[\\n]*$\/, &quot;&quot;).split(&quot;\\n&quot;).length;\n                      \/\/ delete Line Feed codes at the end\n  \/\/ get TSV as Array-Array (2d Array)\n  const arr2dTsv    = parseAsRectangular ( strTsv );  \/\/ [row,col]\n\nconst strRegExp      = configs.get       ( &quot;StrConfB1&quot; );     \/\/ REQUIRED\nconst boolIgnoreCase = configs.getObject ( &quot;BoolConfB2&quot; );    \/\/ TOGGLE\n  \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300 &quot;Boolean object&quot;\n\nconst strSearchCols  = configs.get       ( &quot;StrConfB3&quot; )  === &quot;&quot; ? \/\/ not required\n                      &quot;0&quot; : \/\/ default\n                       configs.get       ( &quot;StrConfB3&quot; ) ; \nconst arrSearchCols  = strSearchCols.split(&quot;,&quot;);\n\nconst strCapturing   = configs.get       ( &quot;StrConfB4&quot; )  === &quot;&quot; ? \/\/ not required\n                       &quot;0&quot; : \/\/ default\n                       configs.get       ( &quot;StrConfB4&quot; ) ; \nconst arrCapturing   = strCapturing.split(&quot;,&quot;);\n\nconst strPocketC     = configs.getObject ( &quot;SelectConfC&quot; );   \/\/ REQUIRED\nconst numPocketD1    = configs.getObject ( &quot;SelectConfD1&quot; );  \/\/ not required\nconst numPocketD2    = configs.getObject ( &quot;SelectConfD2&quot; );  \/\/ 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 ==\nconst regSearch  = boolIgnoreCase ?\n                   new RegExp( strRegExp, &#39;i&#39; ) : new RegExp( strRegExp );\n\nlet arrOutputTsv  = [];\n\nfor ( let i = 0; i &lt; arr2dTsv.length; i++ ) {\n  let strTarget = &quot;&quot;;\n  for ( let j = 0; j &lt; arrSearchCols.length; j++ ) {\n    strTarget += arr2dTsv[i][ parseInt(arrSearchCols[j], 10) ];\n    if ( j !== arrSearchCols.length - 1 ) {\n      strTarget += &quot;\\t&quot;;\n    }\n  }\n\n  let arrFound = strTarget.match ( regSearch );\n  engine.log( &quot; AutomatedTask Match Index: &quot; + arrFound?.index );\n  let arrTmp = [...arr2dTsv[i]]; \/\/ Spread syntax\n  for ( let k = 0; k &lt; arrCapturing.length; k++ ) {\n    let strMatch = arrFound?.[ parseInt(arrCapturing[k], 10) ] ?? &quot;&quot;; \/\/ Optional Chaining and Nullish Coalescing\n    arrTmp.push ( strMatch );\n  }\n  arrOutputTsv.push ( arrTmp?.join( &#39;\\t&#39; ) ?? &quot;&quot; );\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\nif ( strPocketC !== null ){ \n  engine.setData( strPocketC, arrOutputTsv?.join( &#39;\\n&#39; ) ?? &quot;&quot; );\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 &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\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(&quot;\\n&quot;);\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 &lt; arrTsv.length; i++ ){\n    if( arrTsv[i] === &quot;&quot; ){ \/\/ Skip blank lines\n      numBlanklines += 1;\n      continue;\n    }\n    let arrCells = arrTsv[i].split(&quot;\\t&quot;);\n    if( numMinWidth &gt; arrCells.length ){ numMinWidth = arrCells.length; }\n    if( numMaxWidth &lt; arrCells.length ){ numMaxWidth = arrCells.length; }\n  }\n  engine.log( &quot; AutomatedTask TsvDataCheck:&quot; + \n              &quot; MinWidth:&quot; + numMinWidth +\n              &quot; MaxWidth:&quot; + numMaxWidth +\n              &quot; Lines:&quot; + arrTsv.length +\n              &quot; (BlankLines:&quot; + numBlanklines + &quot;)&quot; );\n\n  \/\/\/ Get numMinWidth and numMaxWidth (blank lines are excluded)\n  let arr2dTsv      = [];\n  for( let i = 0; i &lt; arrTsv.length; i++ ){\n    if( arrTsv[i] === &quot;&quot; ){ \/\/ Skip blank lines\n      continue;\n    }\n    let arrTmp = [];\n    let arrCells = arrTsv[i].split(&quot;\\t&quot;);\n    for( let j = 0; j &lt; numMaxWidth; j++ ){\n      if( j &lt; arrCells.length ){\n        arrTmp[j] = arrCells[j];\n      }else{\n        arrTmp[j] = &quot;&quot;;\n      }\n    }\n    arr2dTsv.push( arrTmp );\n  }\n\n  return arr2dTsv;\n}\n\n\n\n\/*\n### NOTES\n- When a Process reaches this [Automated Step], the extraction will be automatically executed.\n    - Any regular expression can be set in the Automatic Step configuration.\n- A string that matches the RegExp is extracted for each line of the TSV text.\n    - Only the first match is extracted.\n    - The search range (cells) can be specified. (eg: &quot;0,2,3&quot;) (default: &quot;0&quot;)\n    - The string that matches is added to the end of each line. (The number of TSV columns increases.)\n    - If there is no match, the empty string `&quot;&quot; ` is added.\n    - If you set `\\d{3}-\\d{4}`, strings such as &quot;150-8001&quot; and &quot;604-0835&quot; will be extracted.\n- Partial extractions are also possible using a capturing group `()` in a regular expression.\n    - ID &quot;0&quot;: &quot;Matched string&quot; (Full extraction)\n    - ID &quot;1&quot;: &quot;String matched by the first capture group&quot; (Partial extraction)\n    - If you set `(\\d{3})-(\\d{4})`, any or all of &quot;150-8001&quot;, &quot;150&quot;, and &quot;8001&quot; are added.\n    - The number of TSV columns increases according to the number of setting IDs.\n- The number of lines in the TSV text can also be recorded.\n- Regular Expressions\n    - https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Guide\/Regular_expressions\n\n### NOTES-ja\n- \u3053\u306e\uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u306b\u6848\u4ef6\u304c\u5230\u9054\u3059\u308b\u3068\u3001\u300c\u62bd\u51fa\u51e6\u7406\u300d\u304c\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\n    - \u81ea\u52d5\u5de5\u7a0b\u306e\u30b3\u30f3\u30d5\u30a3\u30b0\uff08\u8a2d\u5b9a\uff09\u306b\u306f\u3001\u4efb\u610f\u306e\u6b63\u898f\u8868\u73fe\u304c\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002\n- \u6b63\u898f\u8868\u73fe\u306b\u300c\u30de\u30c3\u30c1\u3057\u305f\u6587\u5b57\u5217\u300d\u304c\u3001TSV\u30c6\u30ad\u30b9\u30c8\u5404\u884c\u3054\u3068\u306b\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\n    - \u4e00\u756a\u6700\u521d\u306b\u4e00\u81f4\u3057\u305f\u3082\u306e\u3060\u3051\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\n    - \u691c\u7d22\u7bc4\u56f2\uff08\u30bb\u30ebIDs\uff09\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002\uff08\u4f8b: &quot;0,2,3&quot;\uff09\uff08\u30c7\u30d5\u30a9\u30eb\u30c8\u7bc4\u56f2: &quot;0&quot;\uff09\n    - \u5404\u884c\u306e\u672b\u5c3e\u306b\u300c\u30de\u30c3\u30c1\u3057\u305f\u6587\u5b57\u5217\u300d\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002\uff08TSV\u5217\u6570\u304c\u5897\u3048\u307e\u3059\uff09\n    - \u30de\u30c3\u30c1\u3057\u306a\u3051\u308c\u3070\u3001\u7a7a\u6587\u5b57\u5217 &quot;&quot; \u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002\n    - \u305f\u3068\u3048\u3070 `\\d{3}-\\d{4}` \u3068\u8a2d\u5b9a\u3057\u3066\u304a\u3051\u3070 &quot;150-8001&quot; \u3084 &quot;604-0835&quot; \u3068\u3044\u3063\u305f\u6587\u5b57\u5217\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\n- \u6b63\u898f\u8868\u73fe\u5185\u306b\u30ad\u30e3\u30d7\u30c1\u30e3\u30b0\u30eb\u30fc\u30d7 `()` \u3092\u4f7f\u7528\u3059\u308c\u3070\u3001\u90e8\u5206\u62bd\u51fa\u3082\u53ef\u80fd\u3067\u3059\u3002\n    - ID &quot;0&quot;: \u300c\u30de\u30c3\u30c1\u3057\u305f\u6587\u5b57\u5217\u300d\uff08\u5168\u4f53\u62bd\u51fa\uff09\n    - ID &quot;1&quot;: \u300c&quot;1\u756a\u76ee\u306e\u30ad\u30e3\u30d7\u30c1\u30e3\u30b0\u30eb\u30fc\u30d7&quot; \u304c\u30de\u30c3\u30c1\u3057\u305f\u6587\u5b57\u5217\u300d\uff08\u90e8\u5206\u62bd\u51fa\uff09\n    - `(\\d{3})-(\\d{4})` \u3068\u8a2d\u5b9a\u3059\u308c\u3070 &quot;150-8001&quot;, &quot;150&quot;, &quot;8001&quot; \u306e\u3044\u305a\u308c\u304b\u3082\u3057\u304f\u306f\u5168\u3066\u3092\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002\n    - \u8a2d\u5b9aID\u306e\u6570\u306b\u5fdc\u3058\u3066\u3001TSV\u5217\u6570\u304c\u5897\u3048\u307e\u3059\u3002\n- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306e\u884c\u6570\u3082\u8a18\u9332\u53ef\u80fd\u3067\u3059\u3002\n- \u6b63\u898f\u8868\u73fe\u3068\u306f\n    - https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Guide\/Regular_expressions\n\n\n### Input example\nNHK\u653e\u9001\u30bb\u30f3\u30bf\u30fc\t150-8001 \u6771\u4eac\u90fd\u6e0b\u8c37\u533a\u795e\u53572\u4e01\u76ee2\uff0d1\n\u682a\u5f0f\u4f1a\u793e\u30af\u30a8\u30b9\u30c6\u30c8\u30e9\t604-0835 \u4eac\u90fd\u5e02\u4e2d\u4eac\u533a\u5fa1\u6c60\u901a\u9593\u4e4b\u753a\u6771\u5165\u9ad8\u5bae\u753a206\u5fa1\u6c60\u30d3\u30eb4\u968e\nNHK\u653e\u9001\u30bb\u30f3\u30bf\u30fc\u6771\u4eac\t150-8001 \u6771\u4eac\u90fd\u6e0b\u8c37\u533a\u795e\u53572\u4e01\u76ee2\uff0d1\t150-8001\t150\t8001\t\n\u682a\u5f0f\u4f1a\u793e\u30af\u30a8\u30b9\u30c6\u30c8\u30e9\t604-0835 \u4eac\u90fd\u5e02\u4e2d\u4eac\u533a\u5fa1\u6c60\u901a\u9593\u4e4b\u753a\u6771\u5165\u9ad8\u5bae\u753a206\u5fa1\u6c60\u30d3\u30eb4\u968e\t604-0835\t604\t0835\t\n### Output example using `\\d{3}-\\d{4}`\nNHK\u653e\u9001\u30bb\u30f3\u30bf\u30fc\t150-8001 \u6771\u4eac\u90fd\u6e0b\u8c37\u533a\u795e\u53572\u4e01\u76ee2\uff0d1\t150-8001\n\u682a\u5f0f\u4f1a\u793e\u30af\u30a8\u30b9\u30c6\u30c8\u30e9\t604-0835 \u4eac\u90fd\u5e02\u4e2d\u4eac\u533a\u5fa1\u6c60\u901a\u9593\u4e4b\u753a\u6771\u5165\u9ad8\u5bae\u753a206\u5fa1\u6c60\u30d3\u30eb4\u968e\t604-0835\n\n### Output example using `(\\d{3})-(\\d{4})` capturing `0,1,2`\nNHK\u653e\u9001\u30bb\u30f3\u30bf\u30fc\t150-8001 \u6771\u4eac\u90fd\u6e0b\u8c37\u533a\u795e\u53572\u4e01\u76ee2\uff0d1\t150-8001\t150\t8001\n\u682a\u5f0f\u4f1a\u793e\u30af\u30a8\u30b9\u30c6\u30c8\u30e9\t604-0835 \u4eac\u90fd\u5e02\u4e2d\u4eac\u533a\u5fa1\u6c60\u901a\u9593\u4e4b\u753a\u6771\u5165\u9ad8\u5bae\u753a206\u5fa1\u6c60\u30d3\u30eb4\u968e\t604-0835\t604\t0835\n\n\n\nAPPENDIX\n- \u6b63\u898f\u8868\u73fe \u8a2d\u5b9a\u4f8b \/ RegExp Example\n    - \u65e5\u672c\u306e\u90f5\u4fbf\u756a\u53f7 \/ Japanese Postal Code\n        - `\\d{3}-\\d{4}`\n        - `[0-9]{3}-[0-9]{4}`\n        - `(\\d{3})-(\\d{4})`\n        - `(\\d{3}-\\d{4})`\n        - `(\\d{3}-\\d{4})|(\\d{7})`\n        - `([0-9]{3}-[0-9]{4})|([0-9]{7})`\n    - Email\n        - `[\\w_.+-]+@[\\w-.]+[a-zA-Z]{2,}`\n        - `[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-.]+[a-zA-Z]{2,}`\n        - `[a-zA-Z0-9_.+-]+@([a-zA-Z0-9-.]+[a-zA-Z]{2,})`\n        - `[a-zA-Z0-9_.+-]+@([a-zA-Z0-9][a-zA-Z0-9-]*[a-zA-Z0-9]*\\.)+[a-zA-Z]{2,}`\n        - `[a-zA-Z0-9_.+-]+@(([a-zA-Z0-9][a-zA-Z0-9-]*[a-zA-Z0-9]*\\.)+[a-zA-Z]{2,})`\n    - URL\n        - `https?:\/\/[\\w\/:%#\\$&\\?\\(\\)~\\.=\\+\\-]+`\n    - ISO Date from 2024-12-15 to 2025-01-06\n        - `(2024-12-1[5-9])|(2024-12-[2-3][0-9])|(2025-01-0[1-6])`\n- \u6b63\u898f\u8868\u73fe\u30b0\u30eb\u30fc\u30d7 \/ Groups in regular expressions\n    - `(apple|orange)`\n        - &quot;apple&quot; \u304b &quot;orange&quot; \u306e\u3044\u305a\u308c\u304b\u3000\uff0f\u3000Either &quot;apple&quot; or &quot;orange&quot;\n    - \u6b63\u898f\u8868\u73fe\u306f\u8907\u6570\u306e\u30ad\u30e3\u30d7\u30c1\u30e3\u30b0\u30eb\u30fc\u30d7\u3092\u6301\u3064\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\n        - \u30ad\u30e3\u30d7\u30c1\u30e3\u30b0\u30eb\u30fc\u30d7\u5185\u306e\u5de6\u62ec\u5f27\u3068\u540c\u3058\u9806\u306b\u3042\u308b\u3001\u914d\u5217\u8981\u7d20\u306b\u4e00\u81f4\u3057\u307e\u3059\u3002\n    - A regular expression may have multiple capturing groups.\n        - Matches to capturing groups in an array whose members are in the same order as the left parentheses\n- \u6b63\u898f\u8868\u73fe\u6587\u5b57\u30af\u30e9\u30b9 \/ A character class\n    - `[xyz]`\n        - &quot;x&quot; \u304b &quot;y&quot; \u304b &quot;z&quot; \u306e \u4e00\u6587\u5b57\u3000\uff0f\u3000Any one of the enclosed characters, &quot;x&quot; &quot;y&quot; or &quot;z&quot;\n    - `[a-c]`\n        - &quot;a&quot; \u304b\u3089 &quot;c&quot; \u307e\u3067\u306e\u3044\u305a\u308c\u304b\u4e00\u6587\u5b57\u3000\uff0f\u3000Any one in the range &quot;a&quot; to &quot;c&quot;\n    - `[^xyz]`\n        - &quot;x&quot; \u3067\u3082 &quot;y&quot; \u3067\u3082 &quot;z&quot; \u3067\u3082\u306a\u3044\u4e00\u6587\u5b57\u3000\uff0f\u3000Any one that is neither &quot;x&quot; nor &quot;y&quot; nor &quot;z&quot;\n    - `\\d`\n        - \u6570\u5b57\u4e00\u6587\u5b57\u3000\uff0f\u3000Any digit\u3000\uff0f\u3000`[0-9]`\n    - `\\w`\n        - \u534a\u89d2\u82f1\u6570\u5b57\u4e00\u6587\u5b57\u3000\uff0f\u3000Any alphanumeric character\u3000\uff0f\u3000`[A-Za-z0-9_]`\n    - `\\t`\n        - \u6c34\u5e73\u30bf\u30d6\u3000\uff0f\u3000A horizontal tab\n    - `.`\n        - \u6539\u884c\u6587\u5b57\u3092\u9664\u304f\u3042\u3089\u3086\u308b\u4e00\u6587\u5b57\u3000\uff0f\u3000Any single character except line terminators\n- \u6b63\u898f\u8868\u73fe\u30a2\u30b5\u30fc\u30b7\u30e7\u30f3\u8a00\u660e \/ Assertions\n    - `^`\n        - \u5148\u982d\u3000\uff0f\u3000Beginning\n    - `$`\n        - \u672b\u5c3e\u3000\uff0f\u3000End\n    - `\\b`\n        - \u533a\u5207\u308a\u3000\uff0f\u3000A word boundary\n    - `\\B`\n        - \u533a\u5207\u308a\u4ee5\u5916\u3000\uff0f\u3000A non-word boundary\n- \u6b63\u898f\u8868\u73fe\u6570\u91cf\u8a5e \/ Quantifiers\n    - `x*`\n        - \u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &quot;x&quot; \u306e0\u56de\u4ee5\u4e0a\u306e\u7e70\u8fd4\u3000\uff0f\u3000The preceding item &quot;x&quot; 0 or more times\n    - `x+`\n        - \u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &quot;x&quot; \u306e1\u56de\u4ee5\u4e0a\u306e\u7e70\u8fd4\u3000\uff0f\u3000The preceding item &quot;x&quot; 1 or more times\n    - `x?`\n        - \u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &quot;x&quot; \u306e0\u56de\u304b1\u56de\u306e\u51fa\u73fe\u3000\uff0f\u3000The preceding item &quot;x&quot; 0 or 1 times\n    - `x{n}`\n        - \u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &quot;x&quot; \u306en\u56de\u306e\u51fa\u73fe\u3000\uff0f\u3000&quot;n&quot; occurrences of the preceding item &quot;x&quot;\n    - `x{n,m}`\n        - \u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &quot;x&quot; \u304cn\u304b\u3089m\u56de\u51fa\u73fe\u3000\uff0f\u3000at least &quot;n&quot; and at most &quot;m&quot; occurrences\n\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--30)\"><span>Download<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1HPEEPrfel18BlY0qPt4yjW5YjhY1urlZ\/view?usp=drivesdk\" target=\"_blank\">tsv-string-extract-by-regexp-for-each-line-2025.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2025-04-07 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"has-small-font-size\" style=\"text-align: right;\"><div style=\"display: inline-block; background: #FBE7DD; text-align: center;\">\n<span class=\"material-icons\">warning<\/span> Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<br>\n(Installing <em><strong>Addon Auto-Steps<\/strong><\/em> are available only on the <em><strong><span style=\"color: #1970B9\">Professional<\/span><\/strong><\/em> edition.)\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--30)\"><span>Notes<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When a Process reaches this [Automated Step], the extraction is automatically executed.\n<ul class=\"wp-block-list\">\n<li>Any regular expression can be set in the Automatic Step configuration.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A string that matches the RegExp is extracted for each line of the TSV text.\n<ul class=\"wp-block-list\">\n<li>Only the first match is extracted.<\/li>\n\n\n\n<li>The search range (cells) can be specified. (eg: &#8220;0,2,3&#8221;) (default: &#8220;0&#8221;)<\/li>\n\n\n\n<li>The string that matches is added to the end of each line. (The number of TSV columns increases.)<\/li>\n\n\n\n<li>If there is no match, the empty string <code>\"\"<\/code>is added.<\/li>\n\n\n\n<li>If you set <code>\\d{3}-\\d{4}<\/code>, strings such as &#8220;150-8001&#8221; and &#8220;604-0835&#8221; will be extracted.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Partial extractions are also possible using a capturing group <code>()<\/code> in a regular expression.\n<ul class=\"wp-block-list\">\n<li>ID &#8220;0&#8221;: &#8220;Matched string&#8221; (Full extraction)<\/li>\n\n\n\n<li>ID &#8220;1&#8221;: &#8220;String matched by the first capture group&#8221; (Partial extraction)<\/li>\n\n\n\n<li>If you set <code>(\\d{3})-(\\d{4})<\/code>, any or all of &#8220;150-8001&#8221;, &#8220;150&#8221;, and &#8220;8001&#8221; are added.<\/li>\n\n\n\n<li>The number of TSV columns increases according to the number of setting IDs.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The number of lines in the TSV text can also be recorded.<\/li>\n\n\n\n<li>Regular Expressions\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Guide\/Regular_expressions\" rel=\"nofollow\">https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Guide\/Regular_expressions<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--30)\"><span>Capture<\/span><\/h3>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a64782d927c8&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a64782d927c8\" class=\"wp-block-image alignright size-full has-lightbox wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"628\" data-attachment-id=\"171963\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/collab-chat-basics-part2\/attachment\/tsv-string-extract-by-regexp-for-each-line-2025-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=1200%2C628&amp;ssl=1\" data-orig-size=\"1200,628\" 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=\"tsv-string-extract-by-regexp-for-each-line-2025-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=1024%2C536&amp;ssl=1\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=1200%2C628&#038;ssl=1\" alt=\"#TSV-String: Extract by RegExp for each Line\" class=\"wp-image-171963\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=600%2C315&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=1024%2C536&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=768%2C402&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a64782d99133&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a64782d99133\" class=\"wp-block-image aligncenter size-large has-custom-border is-style-rounded has-lightbox is-style-rounded--1 wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"630\" data-attachment-id=\"171967\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/collab-chat-basics-part2\/attachment\/tsv-string-extract-by-regexp-for-each-line-2025-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-config-en.png?fit=1059%2C1064&amp;ssl=1\" data-orig-size=\"1059,1064\" 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=\"tsv-string-extract-by-regexp-for-each-line-2025-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-config-en.png?fit=627%2C630&amp;ssl=1\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-config-en-627x630.png?resize=627%2C630&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-171967\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-config-en.png?resize=627%2C630&amp;ssl=1 627w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-config-en.png?resize=314%2C315&amp;ssl=1 314w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-config-en.png?resize=768%2C772&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-config-en.png?w=1059&amp;ssl=1 1059w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--30)\"><span>Appendix<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6b63\u898f\u8868\u73fe \u8a2d\u5b9a\u4f8b \/ RegExp Example\n<ul class=\"wp-block-list\">\n<li>\u65e5\u672c\u306e\u90f5\u4fbf\u756a\u53f7 \/ Japanese Postal Code\n<ul class=\"wp-block-list\">\n<li><code>\\d{3}-\\d{4}<\/code><\/li>\n\n\n\n<li><code>[0-9]{3}-[0-9]{4}<\/code><\/li>\n\n\n\n<li><code>(\\d{3})-(\\d{4})<\/code><\/li>\n\n\n\n<li><code>(\\d{3}-\\d{4})<\/code><\/li>\n\n\n\n<li><code>(\\d{3}-\\d{4})|(\\d{7})<\/code><\/li>\n\n\n\n<li><code>([0-9]{3}-[0-9]{4})|([0-9]{7})<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Email\n<ul class=\"wp-block-list\">\n<li><code>[\\w_.+-]+@[\\w-.]+[a-zA-Z]{2,}<\/code><\/li>\n\n\n\n<li><code>[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-.]+[a-zA-Z]{2,}<\/code><\/li>\n\n\n\n<li><code>[a-zA-Z0-9_.+-]+@([a-zA-Z0-9-.]+[a-zA-Z]{2,})<\/code><\/li>\n\n\n\n<li><code>[a-zA-Z0-9_.+-]+@([a-zA-Z0-9][a-zA-Z0-9-]*[a-zA-Z0-9]*\\.)+[a-zA-Z]{2,}<\/code><\/li>\n\n\n\n<li><code>[a-zA-Z0-9_.+-]+@(([a-zA-Z0-9][a-zA-Z0-9-]*[a-zA-Z0-9]*\\.)+[a-zA-Z]{2,})<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>URL\n<ul class=\"wp-block-list\">\n<li><code>https?:\/\/[\\w\/:%#\\$&amp;\\?\\(\\)~\\.=\\+\\-]+<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>ISO Date from 2024-12-15 to 2025-01-06\n<ul class=\"wp-block-list\">\n<li><code>(2024-12-1[5-9])|(2024-12-[2-3][0-9])|(2025-01-0[1-6])<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u6b63\u898f\u8868\u73fe\u30b0\u30eb\u30fc\u30d7 \/ Groups in regular expressions\n<ul class=\"wp-block-list\">\n<li><code>(apple|orange)<\/code>\n<ul class=\"wp-block-list\">\n<li>&#8220;apple&#8221; \u304b &#8220;orange&#8221; \u306e\u3044\u305a\u308c\u304b\u3000\uff0f\u3000Either &#8220;apple&#8221; or &#8220;orange&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u6b63\u898f\u8868\u73fe\u306f\u8907\u6570\u306e\u30ad\u30e3\u30d7\u30c1\u30e3\u30b0\u30eb\u30fc\u30d7\u3092\u6301\u3064\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\n<ul class=\"wp-block-list\">\n<li>\u30ad\u30e3\u30d7\u30c1\u30e3\u30b0\u30eb\u30fc\u30d7\u5185\u306e\u5de6\u62ec\u5f27\u3068\u540c\u3058\u9806\u306b\u3042\u308b\u3001\u914d\u5217\u8981\u7d20\u306b\u4e00\u81f4\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A regular expression may have multiple capturing groups.\n<ul class=\"wp-block-list\">\n<li>Matches to capturing groups in an array whose members are in the same order as the left parentheses<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u6b63\u898f\u8868\u73fe\u6587\u5b57\u30af\u30e9\u30b9 \/ A character class\n<ul class=\"wp-block-list\">\n<li><code>[xyz]<\/code>\n<ul class=\"wp-block-list\">\n<li>&#8220;x&#8221; \u304b &#8220;y&#8221; \u304b &#8220;z&#8221; \u306e \u4e00\u6587\u5b57\u3000\uff0f\u3000Any one of the enclosed characters, &#8220;x&#8221; &#8220;y&#8221; or &#8220;z&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>[a-c]<\/code>\n<ul class=\"wp-block-list\">\n<li>&#8220;a&#8221; \u304b\u3089 &#8220;c&#8221; \u307e\u3067\u306e\u3044\u305a\u308c\u304b\u4e00\u6587\u5b57\u3000\uff0f\u3000Any one in the range &#8220;a&#8221; to &#8220;c&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>[^xyz]<\/code>\n<ul class=\"wp-block-list\">\n<li>&#8220;x&#8221; \u3067\u3082 &#8220;y&#8221; \u3067\u3082 &#8220;z&#8221; \u3067\u3082\u306a\u3044\u4e00\u6587\u5b57\u3000\uff0f\u3000Any one that is neither &#8220;x&#8221; nor &#8220;y&#8221; nor &#8220;z&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>\\d<\/code>\n<ul class=\"wp-block-list\">\n<li>\u6570\u5b57\u4e00\u6587\u5b57\u3000\uff0f\u3000Any digit\u3000\uff0f\u3000<code>[0-9]<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>\\w<\/code>\n<ul class=\"wp-block-list\">\n<li>\u534a\u89d2\u82f1\u6570\u5b57\u4e00\u6587\u5b57\u3000\uff0f\u3000Any alphanumeric character\u3000\uff0f\u3000<code>[A-Za-z0-9_]<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>\\t<\/code>\n<ul class=\"wp-block-list\">\n<li>\u6c34\u5e73\u30bf\u30d6\u3000\uff0f\u3000A horizontal tab<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>.<\/code>\n<ul class=\"wp-block-list\">\n<li>\u6539\u884c\u6587\u5b57\u3092\u9664\u304f\u3042\u3089\u3086\u308b\u4e00\u6587\u5b57\u3000\uff0f\u3000Any single character except line terminators<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u6b63\u898f\u8868\u73fe\u30a2\u30b5\u30fc\u30b7\u30e7\u30f3\u8a00\u660e \/ Assertions\n<ul class=\"wp-block-list\">\n<li><code>^<\/code>\n<ul class=\"wp-block-list\">\n<li>\u5148\u982d\u3000\uff0f\u3000Beginning<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>$<\/code>\n<ul class=\"wp-block-list\">\n<li>\u672b\u5c3e\u3000\uff0f\u3000End<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>\\b<\/code>\n<ul class=\"wp-block-list\">\n<li>\u533a\u5207\u308a\u3000\uff0f\u3000A word boundary<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>\\B<\/code>\n<ul class=\"wp-block-list\">\n<li>\u533a\u5207\u308a\u4ee5\u5916\u3000\uff0f\u3000A non-word boundary<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u6b63\u898f\u8868\u73fe\u6570\u91cf\u8a5e \/ Quantifiers\n<ul class=\"wp-block-list\">\n<li><code>x*<\/code>\n<ul class=\"wp-block-list\">\n<li>\u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &#8220;x&#8221; \u306e0\u56de\u4ee5\u4e0a\u306e\u7e70\u8fd4\u3000\uff0f\u3000The preceding item &#8220;x&#8221; 0 or more times<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>x+<\/code>\n<ul class=\"wp-block-list\">\n<li>\u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &#8220;x&#8221; \u306e1\u56de\u4ee5\u4e0a\u306e\u7e70\u8fd4\u3000\uff0f\u3000The preceding item &#8220;x&#8221; 1 or more times<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>x?<\/code>\n<ul class=\"wp-block-list\">\n<li>\u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &#8220;x&#8221; \u306e0\u56de\u304b1\u56de\u306e\u51fa\u73fe\u3000\uff0f\u3000The preceding item &#8220;x&#8221; 0 or 1 times<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>x{n}<\/code>\n<ul class=\"wp-block-list\">\n<li>\u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &#8220;x&#8221; \u306en\u56de\u306e\u51fa\u73fe\u3000\uff0f\u3000&#8221;n&#8221; occurrences of the preceding item &#8220;x&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>x{n,m}<\/code>\n<ul class=\"wp-block-list\">\n<li>\u76f4\u524d\u30a2\u30a4\u30c6\u30e0 &#8220;x&#8221; \u304cn\u304b\u3089m\u56de\u51fa\u73fe\u3000\uff0f\u3000at least &#8220;n&#8221; and at most &#8220;m&#8221; occurrences<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Input example<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>NHK\u653e\u9001\u30bb\u30f3\u30bf\u30fc    150-8001 \u6771\u4eac\u90fd\u6e0b\u8c37\u533a\u795e\u53572\u4e01\u76ee2\uff0d1\n\u682a\u5f0f\u4f1a\u793e\u30af\u30a8\u30b9\u30c6\u30c8\u30e9    604-0835 \u4eac\u90fd\u5e02\u4e2d\u4eac\u533a\u5fa1\u6c60\u901a\u9593\u4e4b\u753a\u6771\u5165\u9ad8\u5bae\u753a206\u5fa1\u6c60\u30d3\u30eb4\u968e<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Output example using <code>\\d{3}-\\d{4}<\/code><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>NHK\u653e\u9001\u30bb\u30f3\u30bf\u30fc    150-8001 \u6771\u4eac\u90fd\u6e0b\u8c37\u533a\u795e\u53572\u4e01\u76ee2\uff0d1 150-8001\n\u682a\u5f0f\u4f1a\u793e\u30af\u30a8\u30b9\u30c6\u30c8\u30e9    604-0835 \u4eac\u90fd\u5e02\u4e2d\u4eac\u533a\u5fa1\u6c60\u901a\u9593\u4e4b\u753a\u6771\u5165\u9ad8\u5bae\u753a206\u5fa1\u6c60\u30d3\u30eb4\u968e 604-0835<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Output example using <code>(\\d{3})-(\\d{4})<\/code> capturing <code>0,1,2<\/code><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>NHK\u653e\u9001\u30bb\u30f3\u30bf\u30fc    150-8001 \u6771\u4eac\u90fd\u6e0b\u8c37\u533a\u795e\u53572\u4e01\u76ee2\uff0d1 150-8001    150 8001\n\u682a\u5f0f\u4f1a\u793e\u30af\u30a8\u30b9\u30c6\u30c8\u30e9    604-0835 \u4eac\u90fd\u5e02\u4e2d\u4eac\u533a\u5fa1\u6c60\u901a\u9593\u4e4b\u753a\u6771\u5165\u9ad8\u5bae\u753a206\u5fa1\u6c60\u30d3\u30eb4\u968e 604-0835    604 0835<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--30)\"><span>See also<\/span><\/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=\"ifDWPLz3iG\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/string-extract-by-regexp-2025\/\">#String: Extract by RegExp<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201c#String: Extract by RegExp\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/string-extract-by-regexp-2025\/embed\/#?secret=WH2T2KLnPj#?secret=ifDWPLz3iG\" data-secret=\"ifDWPLz3iG\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Extracts a string that match the RegExp for each line. If set an &#8220;Email String&#8221;, the email address in the specified cell will be added as a new cell at the end of the line. If no match, an empty will be added. The capture group also available.<\/p>\n","protected":false},"author":2,"featured_media":171963,"comment_status":"closed","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":"","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":[381,389],"class_list":["post-171969","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-regexp","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=1200%2C628&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=1200%2C628&ssl=1",1200,628,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=600%2C315&ssl=1",600,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=768%2C402&ssl=1",768,402,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=1024%2C536&ssl=1",1024,536,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=1200%2C628&ssl=1",1200,628,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=1200%2C628&ssl=1",1200,628,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=1200%2C628&ssl=1",1200,628,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=900%2C628&ssl=1",900,628,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=1200%2C628&ssl=1",1200,628,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=600%2C628&ssl=1",600,628,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=800%2C628&ssl=1",800,628,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-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\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/04\/tsv-string-extract-by-regexp-for-each-line-2025-en.png?fit=1200%2C628&ssl=1",1200,628,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":4,"uagb_excerpt":"Extracts a string that match the RegExp for each line. If set an \"Email String\", the email address in the specified cell will be added as a new cell at the end of the line. If no match, an empty will be added. The capture group also available.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-IJH","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":171969,"position":0},"title":"Singleline TSV String, Extract Cell","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"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.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Singleline TSV String, Extract Cell","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-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\/Singleline-TSV-String-Extract-Cell-en.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-en.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-en.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-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":171969,"position":1},"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":171969,"position":2},"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":[]},{"id":96514,"url":"https:\/\/support.questetra.com\/ja\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":171969,"position":3},"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":77998,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-static-value-to-all-lines\/","url_meta":{"origin":171969,"position":4},"title":"TSV String; Add Static Value to All Lines","author":"IMAMURA, Genichi","date":"2019-07-26","format":false,"excerpt":"Adds the new string cell to the end of all rows. If there are space characters or line feed characters at the beginning and end of the TSV, they will be deleted beforehand. If the number of tab separators does not match, an error will occur.","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\/2019\/07\/TSV-String-Add-Static-Value-to-All-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\/2019\/07\/TSV-String-Add-Static-Value-to-All-Lines-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/TSV-String-Add-Static-Value-to-All-Lines-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/TSV-String-Add-Static-Value-to-All-Lines-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/TSV-String-Add-Static-Value-to-All-Lines-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76781,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/synchronize-users-chapter3\/","url_meta":{"origin":171969,"position":5},"title":"Synchronizing User Information in QBPMS with Local Data (Organizational Affiliation Chapter)","author":"Hirotaka NISHI","date":"2021-01-18","format":false,"excerpt":"Synchronize user information on Questetra BPM Suite with local data. In the Organizational Affiliation Chapter, we introduce you a Java program that synchronizes affiliation information such as \"which organization the user is affiliated to\".","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.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\/171969","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=171969"}],"version-history":[{"count":9,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/171969\/revisions"}],"predecessor-version":[{"id":172400,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/171969\/revisions\/172400"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/171963"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=171969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=171969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=171969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}