{"id":111985,"date":"2021-08-30T14:36:30","date_gmt":"2021-08-30T05:36:30","guid":{"rendered":"https:\/\/support.questetra.com\/?p=111985"},"modified":"2023-08-22T18:14:03","modified_gmt":"2023-08-22T09:14:03","slug":"multiline-string-get-range-lines-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-get-range-lines-2021\/","title":{"rendered":"Multiline String, Get Range Lines"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Multiline String, Get Range Lines<\/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 specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range.<\/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-edit fa-lg\"><\/i><\/span> A1: Set Original Text<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> B1: Set BeginIndex (eg &#8220;0&#8221; &#8220;2&#8221; &#8220;-5&#8221; )<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> B2: Set EndIndex (eg &#8220;2&#8221; &#8220;-5&#8221; &#8220;&#8221; )<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> C1: Select STRING DATA that stores Extracted Text (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\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strInput         = configs.get( &quot;StrConfA1&quot; );          \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\/\n  if( strInput       === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A1: Text} is empty \\n&quot; );\n  }\nconst strBeginIndex    = configs.get( &quot;StrConfB1&quot; );          \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\/\n  if( strBeginIndex  === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {B1: BeginIndex} is empty \\n&quot; );\n  }\n  const numBeginIndex  = parseInt( strBeginIndex, 10 );\n  if( isNaN( numBeginIndex ) ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {B1: BeginIndex} must be an integer \\n&quot; );\n  }\nconst strEndIndex      = configs.get( &quot;StrConfB2&quot; );          \/\/ NotRequired \/\/\/\/\/\/\/\/\/\/\/\/\n  const numEndIndex    = parseInt( strEndIndex, 10 );\n  if( strEndIndex    !== &quot;&quot; ){\n    if( isNaN( numBeginIndex ) ){\n      throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                       &quot; Config {B2: EndIndex} must be an integer or empty \\n&quot; );\n    }\n  }\nconst strPocketOutput  = configs.getObject( &quot;SelectConfC1&quot; ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nconst arrInput = strInput.split(&quot;\\n&quot;);\nlet arrOutput;\n\n\/\/\/ OutputLog and Extract\nif( strEndIndex    === &quot;&quot; ){\n  engine.log( &quot; AutomatedTask RuntimeLog:&quot; +\n              &quot; Range: from &quot; + numBeginIndex + &quot; to (end)&quot; );\n  arrOutput  = arrInput.slice( numBeginIndex );\n}else{\n  engine.log( &quot; AutomatedTask RuntimeLog:&quot; +\n              &quot; Range: from &quot; + numBeginIndex + &quot; to &quot; + numEndIndex );\n  arrOutput  = arrInput.slice( numBeginIndex, numEndIndex );\n}\n\nlet strOutput = arrOutput.join(&quot;\\n&quot;);\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( strPocketOutput, strOutput );\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\/*\nNotes:\n- When the process reaches this automated task, the Text in the string data is automatically processed.\n    - TSV data, Access log, Email body, etc.\n    - {Number of lines} = {Number of line breaks} + 1\n- The range specified by the start line (Begin Index) and end line (End Index) is extracted.\n    - Index starts at zero. The Index on the first line is &quot;0&quot;. (10-line text: 0,1,2,3,4,5,6,7,8,9)\n        - If a negative value for Index, interpreted as the value subtracted from the number of lines.\n        - If &quot;-1&quot; is specified in 10 lines of text, it is the same as if &quot;9&quot; is specified.\n    - End Index is optional. If omitted, the entire part will be extracted.\n        - Even if End Index is specified to exceed the Index of the last row, the end will be extracted.\n    - A case where an empty string is returned.\n        - {Begin Index} &gt;= {End Index}\n        - {Begin Index} &gt; (Index of the last line)\n    - Example of range specification\n        - Extract the first 5 lines (0,1,2,3,4,5,,, to 0,1,2,3,4):\n            - {Begin Index}: `0`\n            - {End Index}: `5`\n        - Extract only the 3rd line (0,1,2,3,4,5,,, to 2):\n            - {Begin Index}: `2`\n            - {End Index}: `3`\n        - Delete one first line (header row) (0,1,2,3,,,N to 1,2,3,,,N):\n            - {Begin Index}: `1`\n            - {End Index}: (empty)\n        - Delete one last line (footer row) (0,1,2,,,N-1,N to 0,1,2,,,N-1):\n            - {Begin Index}: `0`\n            - {End Index}: `-1`\n\nAPPENDIX:\n- The range specification is the same as the JavaScript `slice ()` method.\n    - https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Array\/slice\n    - https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/String\/slice\n- 10-line text\uff1a0,1,2,3,4,5,6,7,8,9\n    - {Begin Index}: `-10`\n        - Output Line: 0,1,2,3,4,5,6,7,8,9\n    - {Begin Index}: `5`, {End Index}: `20`\n        - Output Line: 5,6,7,8,9\n- When setting an index by referring to numeric, set an EL expression using arithmetic operations.\n    - Extract only (N+1) line; (Index N)\n            - {Begin Index}: `#{#q_numN}`\n            - {End Index}: `#{#q_numN + 1}`\n\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308bText\u304c\u81ea\u52d5\u7684\u306b\u52a0\u5de5\u3055\u308c\u307e\u3059\u3002\n    - TSV\u30c7\u30fc\u30bf\u3001\u30a2\u30af\u30bb\u30b9\u30ed\u30b0\u3001\u30e1\u30fc\u30eb\u672c\u6587\u306a\u3069\n    - {\u884c\u306e\u6570} = {\u6539\u884c\u306e\u6570} + 1\n- \u958b\u59cb\u884c\uff08Begin Index\uff09\u3068\u7d42\u4e86\u884c\uff08End Index\uff09\u3067\u6307\u5b9a\u3055\u308c\u305f\u7bc4\u56f2\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\n    - Index \u306f\u30bc\u30ed\u59cb\u307e\u308a\u3067\u3059\u30021\u884c\u76ee\u306e Index \u306f &quot;0&quot; \u3067\u3059\u3002\uff0810\u884c\u30c6\u30ad\u30b9\u30c8\u306e\u5834\u5408\uff1a0,1,2,3,4,5,6,7,8,9\uff09\n        - Index \u306b\u8ca0\u306e\u5024\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u3001\u30c6\u30ad\u30b9\u30c8\u306e\u5168\u884c\u6570\u304b\u3089\u6e1b\u7b97\u3055\u308c\u305f\u5024\u3068\u89e3\u91c8\u3055\u308c\u307e\u3059\u3002\n        - 10\u884c\u306e\u30c6\u30ad\u30b9\u30c8\u3067 &quot;-1&quot; \u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f &quot;9&quot; \u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u3068\u540c\u3058\u51e6\u7406\u306b\u306a\u308a\u307e\u3059\u3002\n    - End Index \u306f\u7701\u7565\u53ef\u80fd\u3067\u3059\u3002\u7701\u7565\u3057\u305f\u5834\u5408\u306f\u672b\u5c3e\u307e\u3067\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\n        - End Index \u306b\u6700\u7d42\u884c\u306e Index \u3092\u8d85\u3048\u308b\u5024\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u3082\u3001\u672b\u5c3e\u307e\u3067\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\n    - \u7a7a\u6587\u5b57\u5217\u304c\u8fd4\u3055\u308c\u308b\u30b1\u30fc\u30b9\u3002\n        - {Begin Index} &gt;= {End Index}\n        - {Begin Index} &gt; (\u6700\u7d42\u884c\u306eIndex)\n    - \u7bc4\u56f2\u6307\u5b9a\u306e\u4f8b\n        - \u5148\u982d\u306e5\u884c\u3092\u62bd\u51fa (0,1,2,3,4,5\u2026 \u21d2 0,1,2,3,4):\n            - {Begin Index}: `0`\n            - {End Index}: `5`\n        - 3\u884c\u76ee\u3060\u3051\u3092\u62bd\u51fa (0,1,2,3,4,5\u2026 \u21d2 2):\n            - {Begin Index}: `2`\n            - {End Index}: `3`\n        - \u5148\u982d\u884c\uff08\u30d8\u30c3\u30c0\u884c\uff09\u30921\u884c\u524a\u9664 (0,1,2,3,\u2026,N \u21d2 1,2,3,\u2026,N):\n            - {Begin Index}: `1`\n            - {End Index}: `(empty)`\n        - \u6700\u7d42\u884c\uff08\u30d5\u30c3\u30bf\u884c\uff09\u30921\u884c\u524a\u9664 (0,1,2,\u2026,N-1,N \u21d2 0,1,2,\u2026,N-1):\n            - {Begin Index}: `0`\n            - {End Index}: `-1`\n\nAPPENDIX-ja:\n- \u7bc4\u56f2\u306e\u6307\u5b9a\u65b9\u6cd5\u306f\u3001JavaScript `slice()` \u30e1\u30bd\u30c3\u30c9\u3068\u540c\u69d8\u3067\u3059\u3002\n    - https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Array\/slice\n    - https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/String\/slice\n- 10\u884c\u30c6\u30ad\u30b9\u30c8\u306e\u5834\u5408\uff1a0,1,2,3,4,5,6,7,8,9\n    - {Begin Index}: `-10`\n        - Output Line: 0,1,2,3,4,5,6,7,8,9\n    - {Begin Index}: `5`, {End Index}: `20`\n        - Output Line: 5,6,7,8,9\n- \u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u53c2\u7167\u3057\u3066\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8a2d\u5b9a\u3059\u308b\u5834\u5408\u3001\u56db\u5247\u6f14\u7b97\u3092\u4f7f\u3063\u305fEL\u5f0f\u8a2d\u5b9a\u304c\u4fbf\u5229\u3067\u3059\u3002\n    - N+1\u884c\u76ee (Index N) \u3060\u3051\u3092\u62bd\u51fa\n            - {Begin Index}: `#{#q_numN}`\n            - {End Index}: `#{#q_numN + 1}`\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\/1mrJ4-kQP2yb3tFQvXOFOqoPcgbpf5sSj\/view?usp=drivesdk\" target=\"_blank\">Multiline-String-Get-Range-Lines-2021.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-08-29 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1IMeip31dprcEFc5j4Bhtk0tgaiMgSKM3\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Multiline-String-Get-Range-Lines-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-21 (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 Add-on 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.<br>Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/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>When the process reaches this automated task, the Text in the string data is automatically processed.\n<ul class=\"wp-block-list\">\n<li>TSV data, Access log, Email body, etc.<\/li>\n\n\n\n<li>{Number of lines} = {Number of line breaks} + 1<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The range specified by the start line (Begin Index) and end line (End Index) is extracted.\n<ul class=\"wp-block-list\">\n<li>Index starts at zero. The Index on the first line is &#8220;0&#8221;. (10-line text: 0,1,2,3,4,5,6,7,8,9)\n<ul class=\"wp-block-list\">\n<li>If there is a negative value for Index, it will be interpreted as a subtraction from the number of lines.<\/li>\n\n\n\n<li>If &#8220;-1&#8221; is specified in 10 lines of text, it is the same as if &#8220;9&#8221; is specified.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>End Index is optional. If omitted, the entire part will be extracted.\n<ul class=\"wp-block-list\">\n<li>Even if End Index is specified to exceed the Index of the last row, the end will be extracted.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A case where an empty string is returned.\n<ul class=\"wp-block-list\">\n<li>{Begin Index} &gt;= {End Index}<\/li>\n\n\n\n<li>{Begin Index} &gt; (Index of the last line)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Example of range specification\n<ul class=\"wp-block-list\">\n<li>Extract the first 5 lines (0,1,2,3,4,5,,, to 0,1,2,3,4):\n<ul class=\"wp-block-list\">\n<li>{Begin Index}: <code>0<\/code><\/li>\n\n\n\n<li>{End Index}: <code>5<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Extract only the 3rd line (0,1,2,3,4,5,,, to 2):\n<ul class=\"wp-block-list\">\n<li>{Begin Index}: <code>2<\/code><\/li>\n\n\n\n<li>{End Index}: <code>3<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Delete one first line (header row) (0,1,2,3,,,N to 1,2,3,,,N):\n<ul class=\"wp-block-list\">\n<li>{Begin Index}: <code>1<\/code><\/li>\n\n\n\n<li>{End Index}: (empty)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Delete one last line (footer row) (0,1,2,,,N-1,N to 0,1,2,,,N-1):\n<ul class=\"wp-block-list\">\n<li>{Begin Index}: <code>0<\/code><\/li>\n\n\n\n<li>{End Index}: <code>-1<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/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\/2021\/08\/multiline-string-get-range-lines-2021-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"111973\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/multiline-string-get-range-lines-2021-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"multiline-string-get-range-lines-2021-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Extracts the specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range.\" class=\"wp-image-111973\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default q-box\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-config-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"984\" height=\"630\" data-attachment-id=\"111977\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/multiline-string-get-range-lines-2021-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-config-en.png?fit=1197%2C766&amp;ssl=1\" data-orig-size=\"1197,766\" 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=\"multiline-string-get-range-lines-2021-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-config-en.png?fit=984%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-config-en-984x630.png?resize=984%2C630&#038;ssl=1\" alt=\"Extracts the specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range.\" class=\"wp-image-111977\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-config-en.png?resize=984%2C630&amp;ssl=1 984w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-config-en.png?resize=492%2C315&amp;ssl=1 492w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-config-en.png?resize=768%2C491&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-config-en.png?w=1197&amp;ssl=1 1197w\" sizes=\"auto, (max-width: 984px) 100vw, 984px\" \/><\/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>The range specification is the same as the JavaScript <code>slice ()<\/code> method.\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Array\/slice\" rel=\"nofollow\">https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Array\/slice<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/String\/slice\" rel=\"nofollow\">https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/String\/slice<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>10-line text\uff1a0,1,2,3,4,5,6,7,8,9\n<ul class=\"wp-block-list\">\n<li>{Begin Index}: <code>-10<\/code>\n<ul class=\"wp-block-list\">\n<li>Output Line: 0,1,2,3,4,5,6,7,8,9<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>{Begin Index}: <code>5<\/code>, {End Index}: <code>20<\/code>\n<ul class=\"wp-block-list\">\n<li>Output Line: 5,6,7,8,9<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>When setting an index by referring to numeric, set an EL expression using arithmetic operations.\n<ul class=\"wp-block-list\">\n<li>Extract only (N+1) line; (Index N)<br>&#8211; {Begin Index}: <code>#{#q_numN}<\/code><br>&#8211; {End Index}: <code>#{#q_numN + 1}<\/code><\/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=\"V7NDeqFkWc\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-convert-2021\/\">TSV String, Convert<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;TSV String, Convert&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-convert-2021\/embed\/#?secret=exBaRIqrGB#?secret=V7NDeqFkWc\" data-secret=\"V7NDeqFkWc\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Extracts the specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range.<\/p>\n","protected":false},"author":2,"featured_media":111981,"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 specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range.","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":[365,389,2535],"class_list":["post-111985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-easy-config-addon","tag-tsv-csv","tag-workflow-automation"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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":4,"uagb_excerpt":"Extracts the specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-t8d","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":97147,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":111985,"position":0},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","author":"IMAMURA, Genichi","date":"2020-10-28","format":false,"excerpt":"\u5358\u4e00\u884cTSV\u30c7\u30fc\u30bf\u3067Google\u30b7\u30fc\u30c8\u3092\u66f4\u65b0\u3057\u307e\u3059\u3002TSV\u306e\u5148\u982d\u5024\u3068\u5b8c\u5168\u4e00\u81f4\u3059\u308bA\u30bb\u30eb\u3092\u63a2\u7d22\u3057\u3001\u6700\u521d\u306b\u5408\u81f4\u3057\u305f\u884c\u306b\u3064\u3044\u3066\u4e0a\u66f8\u304d\u3057\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u5024\u306f\u3001\u624b\u5165\u529b\u3057\u305f\u969b\u3068\u540c\u69d8\u306b\u81ea\u52d5\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\u3082\u3057\u5408\u81f4\u3059\u308b\u884c\u304c\u7121\u3044\u5834\u5408\u306f\u3001\u672b\u5c3e\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":111985,"position":1},"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":82159,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":111985,"position":2},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf\u3055\u308c\u305f\u8907\u6570\u306e\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u8907\u6570\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"string:0,date:2,select:3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82705,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-filter-by-numeric\/","url_meta":{"origin":111985,"position":3},"title":"TSV\u6587\u5b57\u5217, \u6570\u5024\u30d5\u30a3\u30eb\u30bf","author":"IMAMURA, Genichi","date":"2021-02-01","format":false,"excerpt":"\u6570\u5024\u7bc4\u56f2\u3092\u4f7f\u3063\u3066TSV\u6587\u5b57\u5217\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u307e\u3059\u3002\u6307\u5b9a\u306e\u6570\u5024\u30ab\u30e9\u30e0\u304c\u6570\u5024\u7bc4\u56f2\u306b\u542b\u307e\u308c\u308b\u884c\u306e\u307f\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\u8907\u6570\u306e\u7bc4\u56f2\u3092 OR \u6307\u5b9a\u3057\u305f\u3044\u5834\u5408\u306f \"-100","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":"TSV\u6587\u5b57\u5217, \u6570\u5024\u30d5\u30a3\u30eb\u30bf","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":111990,"url":"https:\/\/support.questetra.com\/ja\/addons\/multiline-string-get-range-lines-2021\/","url_meta":{"origin":111985,"position":4},"title":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u7bc4\u56f2\u884c\u306e\u53d6\u5f97","author":"IMAMURA, Genichi","date":"2021-08-30","format":false,"excerpt":"\u6307\u5b9a\u7bc4\u56f2\u306e\u884c\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u7bc4\u56f2\u306f\u958b\u59cb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3068\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3067\u6307\u5b9a\u3055\u308c\u307e\u3059\u3002\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u30bc\u30ed\u59cb\u307e\u308a\u3067\u3001\u5148\u982d\u884c\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u30bc\u30ed\u3068\u306a\u308a\u307e\u3059\u3002\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3067\u6307\u5b9a\u3055\u308c\u305f\u884c\u306f\u62bd\u51fa\u7bc4\u56f2\u306b\u542b\u307e\u308c\u306a\u3044\u70b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\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":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u7bc4\u56f2\u884c\u306e\u53d6\u5f97","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-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\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96361,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/","url_meta":{"origin":111985,"position":5},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","author":"IMAMURA, Genichi","date":"2020-10-14","format":false,"excerpt":"\u6700\u7d42\u884c\u306bTSV\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5fc5\u8981\u3067\u3042\u308c\u3070\u3001\u65b0\u3057\u3044\u884c\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002TSV\u306e\u6307\u5b9a\u5217\u3060\u3051\u304c\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u306a\u304a\u3001\u5217ID\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\"d\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u65e5\u6642\u30c7\u30fc\u30bf\u3068\u3057\u3066\u3001\"n\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u6570\u5024\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u5217\u6307\u5b9a\u306e\u4f8b: \"0,2d,5n\"\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":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111985","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=111985"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111985\/revisions"}],"predecessor-version":[{"id":149977,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111985\/revisions\/149977"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/111981"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=111985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=111985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=111985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}