{"id":110467,"date":"2021-08-02T16:00:15","date_gmt":"2021-08-02T07:00:15","guid":{"rendered":"https:\/\/support.questetra.com\/?p=110467"},"modified":"2025-09-22T16:08:46","modified_gmt":"2025-09-22T07:08:46","slug":"two-tsv-strings-extract-cell-matched-lines-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-matched-lines-2021\/","title":{"rendered":"Two Tsv Strings, Extract Cell-Matched Lines"},"content":{"rendered":"\n<div class=\"wp-block-uagb-container uagb-block-8623210e alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<h2 class=\"wp-block-heading has-border-color has-ast-global-color-8-border-color has-ast-global-color-5-color has-ast-global-color-8-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-1\" style=\"border-width:5px;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0.5em;padding-right:1em;padding-bottom:0.5em;padding-left:1em;font-size:clamp(0.984em, 0.984rem + ((1vw - 0.2em) * 0.86), 1.5em);\">Recommended Alternative<\/h2>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-42ec112d\">\n<p class=\"wp-block-paragraph\"><strong><strong>Built-in automatic processing step [<\/strong><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/\" target=\"_blank\" rel=\"noreferrer noopener\">Update CSV Data<\/a><strong>] can also be used to perform the same processing. (Recommended)<\/strong><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The settings for [Update CSV Data] when extracting rows where cells match by comparing specific columns in two TSV strings are as follows:<\/p>\n\n\n\n<ul style=\"margin-bottom:1em\">\n<li>C1: <span style=\"font-style:italic\">Data field for entering the source TSV string<\/span><\/li>\n<li>C1a: \u201cTSV\u201d \/ \u201cNo header (data starts from row 1)\u201d<\/li>\n<li>C1b: <span style=\"font-style:italic\">Table name for calling in C3 (e.g., TSV string A)<\/span><\/li>\n<li>C2: <span style=\"font-style:italic\">Data field for entering the target TSV string to compare against<\/span><\/li>\n<li>C2a: \u201cTSV\u201d \/ \u201cNo header (data starts from row 1)\u201d<\/li>\n<li>C2b: <span style=\"font-style:italic\">Table name to be called in C3 (e.g., TSV String B)<\/span><\/li>\n<li>C3: Specify the query below<br>(Replace \u201cTSV string A\u201d, \u201cTSV string B\u201d, \u201ccol2\u201d, and \u201ccol3\u201d with actual table and column names.)\n<pre class=\"wp-block-code\" style=\"margin-bottom:0;padding:1em 2em 1em\"><code>-- Extract rows from TSV string B matching the conditions below\nSELECT t2.*\nFROM \"TSV string B\" AS t2\n\n-- Rows where the 3rd column (col3) of TSV string A matches the 2nd column (col2) of TSV string B\nWHERE t2.\"col2\" IN (SELECT \"col3\" FROM \"TSV string A\");<\/code><\/pre><\/li>\n<li>C4: &#8220;Save the entire table to a single data item in CSV \/ TSV format&#8221;<\/li>\n<li>C4a: <span style=\"font-style:italic\">Data item storing the resulting TSV string<\/span><\/li>\n<li>C4b: \u201cTSV\u201d \/ \u201cNo header (data starts from row 1)\u201d<\/li>\n<li>C4c: \u201cOnly when necessary\u201d<\/li><\/ul>\n<\/div>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Two Tsv Strings, Extract Cell-Matched Lines<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that have a matching cell in A. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.<\/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-id: Set ID of column to compare<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-id: Set ID of column to compare<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> C: Select STRING DATA for Extracted TSV String (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\/\/ GraalJS Script (engine type: 2)\n\/\/ \n\/\/ Notes:\n\/\/ Compares cells and extracts lines.\n\/\/ To extract the customers with whom they have on-going transactions in list A.\n\/\/ Also for extracting sales records that are registered in product master A.\n\/\/ Line sorting is NOT required.\n\/\/ \n\/\/ Notes(ja):\n\/\/ \u30bb\u30eb\u3092\u6bd4\u8f03\u3057\u3001\u884c\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002\n\/\/ \u524d\u6708\u53d6\u5f15\u5148\u4e00\u89a7A\u306b\u3082\u30ea\u30b9\u30c8\u3055\u308c\u305f\u7d99\u7d9a\u53d6\u5f15\u5148\u3092\u62bd\u51fa\u3059\u308b\u3068\u3044\u3063\u305f\u30b1\u30fc\u30b9\u306b\u5229\u7528\u3067\u304d\u307e\u3059\u3002\n\/\/ \u5546\u54c1\u30de\u30b9\u30bfA\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u5546\u54c1\u58f2\u4e0a\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3059\u308b\u3068\u3044\u3063\u305f\u30b1\u30fc\u30b9\u306b\u3082\u5229\u7528\u3067\u304d\u307e\u3059\u3002\n\/\/ \u884c\u30bd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002\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 idA     = configs.get( &quot;conf_IdA&quot; ) + &quot;&quot;;      \/\/ config required\nconst strB    = configs.get( &quot;conf_StrB&quot; ) + &quot;&quot;;     \/\/ config required\nconst idB     = configs.get( &quot;conf_IdB&quot; ) + &quot;&quot;;      \/\/ config required\nconst dataIdC = configs.get( &quot;conf_DataIdC&quot; ) + &quot;&quot;;  \/\/ config 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( idA === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {ID A} is empty \\n&quot; );\n}\nif( idB === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {ID B} is empty \\n&quot; );\n}\nconst zeroPositiveInt = \/^([1-9]\\d*|0)$\/; \/\/ RegExp\nlet numIdA = -1;\nif( zeroPositiveInt.test( idA ) ){\n  numIdA = parseInt(idA, 10);\n}else{\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config Number {ID A} must be a positive integer or zero \\n&quot; );\n}\nlet numIdB = -1;\nif( zeroPositiveInt.test( idB ) ){\n  numIdB = parseInt(idB, 10);\n}else{\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config Number {ID B} must be a positive integer or zero \\n&quot; );\n}\n\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][numIdB] === twoDimArrayA[j][numIdA] ){\n      engine.log( &quot; AutomatedTask Match:&quot; +\n                  &quot; B[&quot; + i + &quot;][&quot; + numIdB + &quot;] ==&quot; +\n                  &quot; A[&quot; + j + &quot;][&quot; + numIdA + &quot;]&quot; );\n      strOutput += arrStrB[i] + &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<figure class=\"wp-block-image 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>\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 href=\"https:\/\/drive.google.com\/file\/d\/1m0RsLvQxKjPjGfL8dbjOcT-I9asPD7gf\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Two-Tsv-Strings-Extract-Cell-Matched-Lines-2021.xml<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-07-29 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-matched-lines-2021\/\">https:\/\/support.questetra.com\/addons\/two-tsv-strings-extract-cell-matched-lines-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<ul class=\"wp-block-list\">\n<li>Compares cells and extracts lines.<\/li>\n\n\n\n<li>Can be used to extract customers with whom who you have on-going transactions in list A.<\/li>\n\n\n\n<li>Also for extracting sales records that are registered in product master A.<\/li>\n\n\n\n<li>Line sorting is NOT required.<\/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-large\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/2-tsv-strings-extract-cell-matched-lines-en.png?ssl=1\" alt=\"\" class=\"wp-image\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"83947\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-matched-lines\/attachment\/two-tsv-strings-extract-cell-matched-lines-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-title=\"Two-Tsv-Strings-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i1.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-capture-en.png?fit=1024%2C576&amp;ssl=1\" alt=\"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.\" class=\"wp-image-83947\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-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=\"mfGq7dCeZC\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv-2021\/\">Questetra BPMS: Process, Batch Extract as TSV<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Questetra BPMS: Process, Batch Extract as TSV&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-as-tsv-2021\/embed\/#?secret=1TvdQVZsfi#?secret=mfGq7dCeZC\" data-secret=\"mfGq7dCeZC\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that have a matching cell in A. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.<\/p>\n","protected":false},"author":3,"featured_media":83945,"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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[451],"faq_section":[],"class_list":["post-110467","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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-Extract-Cell-Matched-Lines-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 a specific column of TSV string A with a specific column of B and extracts the rows of B that have a matching cell in A. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-sJJ","jetpack-related-posts":[{"id":83944,"url":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-matched-lines\/","url_meta":{"origin":110467,"position":0},"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":110467,"position":1},"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":84096,"url":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-compare-numeric-cells\/","url_meta":{"origin":110467,"position":2},"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":110466,"url":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-mismatched-lines-2021\/","url_meta":{"origin":110467,"position":3},"title":"Two Tsv Strings, Extract Cell-Mismatched Lines","author":"Hirotaka NISHI","date":"2021-08-02","format":false,"excerpt":"Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that do not have a cell match for A. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are\u2026","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":70950,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-filteringbynumber\/","url_meta":{"origin":110467,"position":4},"title":"TSV Filtering by Number","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Filter the rows on tab-delimited text (TSV) stored in String type Data Item by a range of numbers and save it","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\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70961,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-filteringbydate\/","url_meta":{"origin":110467,"position":5},"title":"TSV Filtering by Date","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Filter a row in a tab-delimited text (TSV) stored in a String type Data Items by date range and save. dateString should be in a format recognized by the Date.parse() method. Date-only strings (e.g. \"1970-01-01\") are treated as UTC, not local. *Note dateString should be in a format recognized by\u2026","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":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-date-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-date-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-date-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-date-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-date-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/110467","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=110467"}],"version-history":[{"count":8,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/110467\/revisions"}],"predecessor-version":[{"id":177726,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/110467\/revisions\/177726"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/83945"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=110467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=110467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=110467"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=110467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}