{"id":110461,"date":"2021-08-02T16:40:54","date_gmt":"2021-08-02T07:40:54","guid":{"rendered":"https:\/\/support.questetra.com\/?p=110461"},"modified":"2021-10-05T16:36:07","modified_gmt":"2021-10-05T07:36:07","slug":"two-tsv-strings-compare-numeric-cells-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-compare-numeric-cells-2021\/","title":{"rendered":"Two Tsv Strings, Compare Numeric Cells"},"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\">Two Tsv Strings, Compare Numeric Cells<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Compares numeric column strings in TSV-A and TSV-B, and lists the amount of change from A to B. If there is no string that matches the key column of A, it will not be listed. If there are multiple matches, they will be compared to the numbers in the key rows above them.<\/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> A: Set TSV String<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A-key-id: Set ID of key column<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> A-num-id: Set ID of numeric column<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-edit fa-lg\"><\/i><\/span> B: Set TSV String<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B-key-id: Set ID of key column<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B-num-id: Set ID of numeric column<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> C: Select STRING DATA for Extracted TSV String (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> D: Set Output Col-IDs following {Value-Rate} (eg &#8220;0,1,3,0&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/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>\n\/\/ GraalJS Script (engine type: 2)\n\/\/ Notes:\n\/\/ Search for lines with the Key and compare the numeric cells.\n\/\/ Assumes a digit separator and evaluates all numbers after removing all commas &quot;,&quot;.\n\/\/ {Growth Value} and {Growth Rate} are calculated. \n\/\/ &quot;Infinity&quot; is output for the zero denominator.\n\/\/ Value Rate and the values of the specified B column IDs are output in TSV.\n\/\/ {Growth Value} {Growth Rate} {B-Column0} {B-Column1}... \n\/\/ \n\/\/ Notes(ja):\n\/\/ \u540c\u4e00Key\u306e\u884c\u3092\u63a2\u7d22\u3057\u3001\u6570\u5024\u30bb\u30eb\u540c\u58eb\u3092\u6bd4\u8f03\u3057\u307e\u3059\u3002\n\/\/ \u6841\u533a\u5207\u308a\u6587\u5b57\u3092\u60f3\u5b9a\u3057\u3001\u5168\u3066\u306e\u30ab\u30f3\u30de \u201c,\u201d \u3092\u9664\u53bb\u3057\u305f\u3046\u3048\u3067\u6570\u5024\u5224\u5b9a\u3057\u307e\u3059\n\/\/ {\u5897\u52a0\u5024}\u3068{\u5897\u52a0\u7387}\u304c\u7b97\u51fa\u3055\u308c\u307e\u3059\u3002\n\/\/ \u3000\u30bc\u30ed\u5206\u6bcd\u306f &quot;Infinity&quot; \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\n\/\/ {\u5897\u52a0\u5024} {\u5897\u52a0\u7387} \u304a\u3088\u3073\u6307\u5b9a\u3057\u305fB\u30ab\u30e9\u30e0ID\u306e\u5024\u304cTSV\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\n\/\/ \u3000{\u5897\u52a0\u5024} {\u5897\u52a0\u7387} {B-Column0} {B-Column1}... \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 strA    = configs.get( &quot;conf_StrA&quot; )    + &quot;&quot;;  \/\/ config required\nconst idKeyA  = configs.get( &quot;conf_IdKeyA&quot; )  + &quot;&quot;;  \/\/ config required\nconst idNumA  = configs.get( &quot;conf_IdNumA&quot; )  + &quot;&quot;;  \/\/ config required\nconst strB    = configs.get( &quot;conf_StrB&quot; )    + &quot;&quot;;  \/\/ config required\nconst idKeyB  = configs.get( &quot;conf_IdKeyB&quot; )  + &quot;&quot;;  \/\/ config required\nconst idNumB  = configs.get( &quot;conf_IdNumB&quot; )  + &quot;&quot;;  \/\/ config required\nconst dataIdC = configs.get( &quot;conf_DataIdC&quot; ) + &quot;&quot;;  \/\/ config required\nconst colIds  = configs.get( &quot;conf_ColIds&quot; )  + &quot;&quot;;  \/\/ config not required\n\nif( strA === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {Str A} is empty \\n&quot; );\n}\nif( strB === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {Str B} is empty \\n&quot; );\n}\n\nif( idKeyA === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {KeyID A} is empty \\n&quot; );\n}\nif( idKeyB === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {KeyID B} is empty \\n&quot; );\n}\nif( idNumA === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {NumID A} is empty \\n&quot; );\n}\nif( idNumB === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {NumID B} is empty \\n&quot; );\n}\nconst zeroPositiveInt = \/^([1-9]\\d*|0)$\/; \/\/ RegExp\nlet numIdKeyA = -1;\nif( zeroPositiveInt.test( idKeyA ) ){\n  numIdKeyA = parseInt(idKeyA, 10);\n}else{\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config Number {KeyID A} must be a positive integer or zero \\n&quot; );\n}\nlet numIdKeyB = -1;\nif( zeroPositiveInt.test( idKeyB ) ){\n  numIdKeyB = parseInt(idKeyB, 10);\n}else{\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config Number {KeyID B} must be a positive integer or zero \\n&quot; );\n}\nlet numIdNumA = -1;\nif( zeroPositiveInt.test( idNumA ) ){\n  numIdNumA = parseInt(idNumA, 10);\n}else{\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config Number {NumID A} must be a positive integer or zero \\n&quot; );\n}\nlet numIdNumB = -1;\nif( zeroPositiveInt.test( idNumB ) ){\n  numIdNumB = parseInt(idNumB, 10);\n}else{\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config Number {NumID B} must be a positive integer or zero \\n&quot; );\n}\nconst idsCsv = \/^[0-9][0-9,]*$\/; \/\/ RegExp\nif( ! idsCsv.test( colIds ) ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {Column IDs} allows only numbers and commas. \\n&quot; );\n}\nconst arrColIds = colIds.split(&quot;,&quot;);\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ Nothing (except EL-expression Config)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet twoDimArrayA = []; \/\/ for TSV-A\nconst arrStrA = strA.split(&quot;\\n&quot;);\nfor( let i = 0; i &lt; arrStrA.length; i++ ){\n  twoDimArrayA[i] = arrStrA[i].split(&quot;\\t&quot;);\n}\nlet twoDimArrayB = []; \/\/ for TSV-B\nconst arrStrB = strB.split(&quot;\\n&quot;);\nfor( let i = 0; i &lt; arrStrB.length; i++ ){\n  twoDimArrayB[i] = arrStrB[i].split(&quot;\\t&quot;);\n}\nengine.log( &quot; AutomatedTask MultilineString:&quot; + \n            &quot; TSV {A}, number of lines &quot; + arrStrA.length );\nengine.log( &quot; AutomatedTask MultilineString:&quot; + \n            &quot; TSV {B}, number of lines &quot; + arrStrB.length );\n\nlet strOutput = &quot;&quot;;\nfor( let i = 0; i &lt; arrStrB.length; i++ ){\n  for( let j = 0; j &lt; arrStrA.length; j++ ){\n    if( twoDimArrayB[i][numIdKeyB] === twoDimArrayA[j][numIdKeyA] ){\n      engine.log( &quot; AutomatedTask Match:&quot; +\n                  &quot; B[&quot; + i + &quot;][&quot; + numIdKeyB + &quot;] ==&quot; +\n                  &quot; A[&quot; + j + &quot;][&quot; + numIdKeyA + &quot;]&quot; );\n      strOutput += (\n                     parseFloat( twoDimArrayB[i][numIdNumB].replace( \/,\/g,&quot;&quot;) ) - \n                     parseFloat( twoDimArrayA[j][numIdNumA].replace( \/,\/g,&quot;&quot;) )\n                   ) + &quot;\\t&quot; +\n                   Math.floor(\n                     (\n                       parseFloat( twoDimArrayB[i][numIdNumB].replace( \/,\/g,&quot;&quot;) ) \/\n                       parseFloat( twoDimArrayA[j][numIdNumA].replace( \/,\/g,&quot;&quot;) )\n                     ) * 1000\n                   ) \/ 1000 + &quot;&quot;;                   \n      for( let k = 0; k &lt; arrColIds.length; k++ ){\n        strOutput += &quot;\\t&quot; + twoDimArrayB[i][ (arrColIds[k] - 0) ];\n      }\n      strOutput += &quot;\\n&quot;;\n      break;\n    }\n  }\n}\nstrOutput = strOutput.replace(\/[\\n]*$\/, &quot;&quot;);\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strOutput === &quot;&quot; ){\n  engine.log( &quot; AutomatedTask DataUpdating: Output Text empty&quot; );\n}\nengine.setDataByNumber( dataIdC, strOutput );\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADGUlEQVRYR8WXS0hUYRSAvyuO5GMq\nM0vURWqZKAm6mDQsUKFNq1xZ5MISZmxjQRC6EFcjQkxuppkBLdCwRTItxE0IYeBmqFxEg1BqhZAI\naSj2mKgbd8Y7j\/uYuVeNudv\/PL57zvnPOb9Amj\/BsH8fOYi0IdCMSB0CJ4D8Hf0NRD4iMI\/ICwT8\n2PluxHZqgEcUEeIu4AAOGDEK\/AS8ZDFEJ6vJdJIDeHEgcA\/INehYKbaNyB0cePX09QF8PAC6d+lY\nqebBzk0tW9oAXiYQuLJPziNmRJ7g4KrSphogyZ9X51cz1jxG5aFKXbbQnxCuty6c804tGVUkEgEi\nOfdoaUrOJ1omqC2oZXJpkqlPUyqxMmsZPWd6cL9z0\/+qXxtSpDu+JmIAkWr\/oFVw8c4FBEYXRul6\n2aVy0HGqA1ejKwyXmZHJyvYKfYE+dWFmcVK+HTEAH\/eBW0pppXPpXAIYeD1AU1ETlgwL67\/Wmf48\njQwwtzpH\/dF6tn5vUfO0RisSw9i5LR1EAKQmA1+V91zLuQww+2UWd5Mbq8VKcCMYdiQDeIIeinOK\naTzeqAcg9YkCqVlFALxcQ2BciSoZHD43zNqPNUJ\/Q9Fj\/7Kfpc2lvQBIt6IDB4\/lCIwC17UABm2D\n9AZ6GX+fyNdwrIHO051kZ2ZHc20iApKrh9i5IUfgDQJ1ZgC0EmsKQGQeB\/VyBNbjBkvUtmQwPgKB\nywGqDlepfC98W8D2zGamBiQbG9g5IgOIen+kl4I9R0AyYEcwBbDPEUgAMJQC3f67c2CqBhJS4MVQ\nEfov+qk4WKHiWNxcpO15m7kaUBShoWvotDkpzS1VAcgt12QEEq6hbiP6b0WoaESarVj6o6GzQ3iD\nXpa3llOVAPHT0FwrjswD1TBqr2gPT7c8S15K57KAvA+UW8uTzQLFMJK0k4zjMN95H4XZheFiM\/KN\nXBjRA9hGcxxHhpLuQjJzaYbWklYjvqMy8pRMUNJdSGQpnZWspbiFktwSUwDynhCnlGIlkyXTupSm\niISpEMSETa7lsUik8WEiQ6T1aRYf77Q9TneZdKNq\/wCsgZQwbt5uGQAAAABJRU5ErkJggg==\n\" alt=\"\"\/><\/a><\/figure><\/div>\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\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/1T-zhf7FQ60bC6MjXpNFlaQBsUiOZaXx9\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Two-Tsv-Strings-Compare-Numeric-Cells-2021.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-07-27 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-compare-numeric-cells-2021\/\">https:\/\/support.questetra.com\/addons\/two-tsv-strings-compare-numeric-cells-2021\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Add-on import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Searches for rows with the same Key and compares numeric cells with each other.<\/li><li>Assumes a digit separator and evaluates all numbers after removing all commas &#8220;,&#8221;.<\/li><li>{Growth Value} and {Growth Rate} are calculated. <ol><li>&#8220;Infinity&#8221; is output for the zero denominator.<\/li><\/ol><\/li><li>Value Rate and the values of the specified B column IDs are output in TSV.<ol><li>{Growth Value} {Growth Rate} {B-Column0} {B-Column1}\u2026<\/li><\/ol><\/li><\/ol>\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-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" 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=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/compare-numeric-cells-2021-en.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-attachment-id=\"84099\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-compare-numeric-cells\/attachment\/two-tsv-strings-compare-numeric-cells-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-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=\"Two-Tsv-Strings-Compare-Numeric-Cells-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-capture-en-1024x576.png?resize=1024%2C576&#038;ssl=1\" alt=\"\" class=\"wp-image-84099\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-capture-en.png?resize=768%2C432&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-capture-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\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=\"7uDXQD7NKy\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/\">TSV String; Re-order Columns<\/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; Re-order Columns&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-reorder-columns\/embed\/#?secret=UBEvqE7F86#?secret=7uDXQD7NKy\" data-secret=\"7uDXQD7NKy\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"f4IkEGrsxU\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-numeric\/\">TSV String, Filter by Numeric<\/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, Filter by Numeric&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-filter-by-numeric\/embed\/#?secret=No151mk3jn#?secret=f4IkEGrsxU\" data-secret=\"f4IkEGrsxU\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Compares numeric column strings in TSV-A and TSV-B, and lists the amount of change from A to B. If there is no string that matches the key column of A, it will not be listed. If there are multiple matches, they will be compared to the numbers in the key rows above them.<\/p>\n","protected":false},"author":3,"featured_media":84097,"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":[389],"class_list":["post-110461","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":2,"uagb_excerpt":"Compares numeric column strings in TSV-A and TSV-B, and lists the amount of change from A to B. If there is no string that matches the key column of A, it will not be listed. If there are multiple matches, they will be compared to the numbers in the key rows above them.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-sJD","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":84096,"url":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-compare-numeric-cells\/","url_meta":{"origin":110461,"position":0},"title":"Two Tsv Strings, Compare Numeric Cells","author":"IMAMURA, Genichi","date":"2020-01-30","format":false,"excerpt":"Compares numeric column strings in TSV-A and TSV-B, and lists the amount of change from A to B. If there is no string that matches the key column of A, it will not be listed. If there are multiple matches, it will be compared with the key above.","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, Compare Numeric Cells","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-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-Compare-Numeric-Cells-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-Compare-Numeric-Cells-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-Compare-Numeric-Cells-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-Compare-Numeric-Cells-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":110461,"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":110461,"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":84105,"url":"https:\/\/support.questetra.com\/ja\/addons\/two-tsv-strings-compare-numeric-cells\/","url_meta":{"origin":110461,"position":3},"title":"2\u3064\u306eTSV\u6587\u5b57\u5217, \u6570\u5024\u30bb\u30eb\u306e\u6bd4\u8f03","author":"IMAMURA, Genichi","date":"2020-01-30","format":false,"excerpt":"TSV\u6587\u5b57\u5217A\u3068TSV\u6587\u5b57\u5217B\u306e\u6570\u5024\u30bb\u30eb\u540c\u58eb\u3092\u6bd4\u8f03\u3057\u3001A\u304b\u3089B\u3078\u306e\u6570\u5024\u5909\u5316\u91cf\u3092\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002A\u306e\u30ad\u30fc\u5217\u306b\u30de\u30c3\u30c1\u3059\u308b\u6587\u5b57\u5217\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u3001\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u5bfe\u8c61\u306b\u306a\u308a\u307e\u305b\u3093\u3002A\u306e\u30ad\u30fc\u5217\u3067\u8907\u6570\u30de\u30c3\u30c1\u3059\u308b\u5834\u5408\u3001\u3088\u308a\u4e0a\u306b\u3042\u308b\u30ad\u30fc\u884c\u306e\u6570\u5024\u3068\u6bd4\u8f03\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":"2\u3064\u306eTSV\u6587\u5b57\u5217, \u6570\u5024\u30bb\u30eb\u306e\u6bd4\u8f03","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-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\/01\/Two-Tsv-Strings-Compare-Numeric-Cells-ja.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-Compare-Numeric-Cells-ja.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-Compare-Numeric-Cells-ja.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-Compare-Numeric-Cells-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82388,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/","url_meta":{"origin":110461,"position":4},"title":"TSV String, Sort by Numeric","author":"IMAMURA, Genichi","date":"2019-12-03","format":false,"excerpt":"Sorts TSV text in the numerical order of the specified column. If each column values are \"123 jpy\", \"1,234 jpy\", and \"12 jpy\", they are sorted in the order of \"line including 12 jpy\", \"line including 123 jpy\", \"line including 1,234 jpy\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Sort by Numeric","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-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\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.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-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82695,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-numeric\/","url_meta":{"origin":110461,"position":5},"title":"TSV String, Filter by Numeric","author":"IMAMURA, Genichi","date":"2021-02-01","format":false,"excerpt":"Filters TSV strings using a numeric range. Only the rows where the specified numeric column is included in the numeric range are output. If you want to OR multiple ranges, specify them in comma separated form like \"-100","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Filter by Numeric","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-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\/12\/TSV-String-Filter-by-Numeric-en.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-en.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-en.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-en.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\/110461","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=110461"}],"version-history":[{"count":5,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/110461\/revisions"}],"predecessor-version":[{"id":114679,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/110461\/revisions\/114679"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/84097"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=110461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=110461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=110461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}