{"id":82245,"date":"2019-11-25T15:42:38","date_gmt":"2019-11-25T06:42:38","guid":{"rendered":"https:\/\/support.questetra.com\/?p=82245"},"modified":"2022-05-26T13:34:33","modified_gmt":"2022-05-26T04:34:33","slug":"tsv-string-filter-by-text","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/","title":{"rendered":"TSV String, Filter by Text"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5e54c;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFFF66;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text-2021\/_\">https:\/\/support.questetra.com\/addons\/tsv-string-filter-by-text-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-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=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<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\">TSV String, Filter by Text<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">\n\n\n\n<p class=\"wp-block-paragraph\">Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as &#8220;USA,U.S.,United States&#8221;.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2019-11-25 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/\">https:\/\/support.questetra.com\/addons\/tsv-string-filter-by-text\/<\/a><\/p>\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\n\n\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> A: Select STRING DATA for TSV String<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> B-target: Set Column ID to be Searched (eg &#8220;0&#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=\"fal fa-pen-square fa-lg\"><\/i><\/span> B-texts: Set Search Texts (eg &#8220;USA&#8221; &#8220;USA,U.S.&#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=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> C: Select STRING DATA for Filterd TSV (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n\n\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<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ (c) 2019, Questetra, Inc. (the MIT License)\n\/\/ Notes:\n\/\/ Cannot specify search terms that contain a comma.\n\/\/ For \"AND search\", try to place this Automated Step serially.\n\/\/ Special characters in search text settings have no meaning (literal string).\n\/\/ Notes(ja):\n\/\/ \u30ab\u30f3\u30de\u3092\u542b\u3080\u691c\u7d22\u8a9e\u306f\u6307\u5b9a\u3067\u304d\u307e\u305b\u3093\n\/\/ \"AND\u691c\u7d22\" \u306f\u81ea\u52d5\u5de5\u7a0b\u306e\u76f4\u5217\u914d\u7f6e\u3092\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\n\/\/ \u691c\u7d22\u30c6\u30ad\u30b9\u30c8\u8a2d\u5b9a\u306e\u7279\u6b8a\u6587\u5b57\u306b\u610f\u5473\u306f\u3042\u308a\u307e\u305b\u3093\uff08\u30ea\u30c6\u30e9\u30eb\u6587\u5b57\u5217\uff09\n\n\n\/\/\/\/\/\/\/\/ START \"main()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA     = configs.get( \"conf_DataIdA\" ) + \"\";     \/\/ config required\nconst targetColId = configs.get( \"conf_TargetColId\" ) + \"\"; \/\/ config required\nconst searchTexts = configs.get( \"conf_SearchTexts\" ) + \"\"; \/\/ config required\nconst dataIdC     = configs.get( \"conf_DataIdC\" ) + \"\";     \/\/ config required\n\nif( targetColId === \"\" ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {Column ID} is empty \\n\" );\n}\nif( searchTexts === \"\" ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {Search Texts} is empty \\n\" );\n}\nconst numTargetColId = parseInt( targetColId );\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nconst inputString = engine.findDataByNumber( dataIdA ) + \"\";\nconst arrInputString = inputString.split(\"\\n\");\nengine.log( \" AutomatedTask MultilineString:\" + \n            \" TSV {A}, number of lines: \" + arrInputString.length );\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet   outputString = \"\";\nconst arrSearchTexts = searchTexts.split(\",\");\nlet   arrSearchRegExp = &#091;];\nfor( let i = 0; i &lt; arrSearchTexts.length; i++ ){\n  engine.log( \" AutomatedTask Search Text&#091;\" + i +\"]: \" + arrSearchTexts&#091;i] );\n  if( arrSearchTexts&#091;i] === \"\" ){\n    throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                     \" Config {Search Text&#091;\" + i +\"]} is empty \\n\" );\n  }\n  let contain = new RegExp( arrSearchTexts&#091;i]\n                            .replace(\/&#091;.*+?^=!:${}()|&#091;\\]\\\/\\\\]\/g, '\\\\$&amp;')\n                          ); \/\/ Escaping for a literal string search\n  \/\/ For a wider range of values, comment out and use Patterns with special characters\n  arrSearchRegExp.push( contain );\n}\nfor( let i = 0; i &lt; arrInputString.length; i++ ){\n  let arrTsvLine = arrInputString&#091;i].split(\"\\t\");\n  for( let j = 0; j &lt; arrSearchRegExp.length; j++ ){\n    if( arrSearchRegExp&#091;j].test( arrTsvLine&#091; numTargetColId ] ) ){\n      outputString += arrInputString&#091;i];\n      outputString += \"\\n\";\n      break;\n    }\n  }\n}\noutputString = outputString.replace(\/&#091;\\n]*$\/, \"\");\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( outputString === \"\" ){\n  engine.log( \" AutomatedTask DataUpdating: Output Text empty\" );\n}\nengine.setDataByNumber( dataIdC, outputString );\n\n} \/\/\/\/\/\/\/\/ END \"main()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/code><\/pre>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADkElEQVRYR82XW0gUURjHf6NmrmWW\nlV0pxe1mdJUiootJ9djtqaJ9sCV3tQgFqbfqoYcuUvlQ7UIWXbA3IyiIILUo8MGsKPIhwYV0i7ba\n0tzUtIkz6+js7OzurCV2HmfO+f9\/853vfOcbiVEekml\/N6nI7EJiEzIrkMgCJg2s9yPjQeIFMnVI\n1OAgYEY7NsA1ptPLUcAJpJgRBboBF8mcppCP0dZEB3DhRKICGGfSWD+tC5lynLgirY8M4OYSUDxM\nY\/2yyzgoMdIyBnBRjcSef2QelJG5jZO9es1wAIMvz52Uy7a521iduZrstGxmpM4gNSk1RMv304ev\n20fzt2bqvfXUtNbQ+aszZiRCAYJ7flldZZtno2xJGUsnLyVBSqCjt4P2rna8AS8fAh8GxROlRHIm\n5DA1ZaoCZ0myEOgL8OD9A86+OkvDp4YhEJlibU4MAQSzvUVNuCPLjnAs7xh9v\/u447mjCL31vzW1\nKzuzdlK6pJS109bi+eHBVmvTQnSRjFU9HUMAbs4DparDlQ1XKFxQiKvZxcGnB00Z6yc17WrCmm5V\n1t98d1P7+gIOysSDIIAoMvBFe84FgH2hnc\/dn6l8U0nl60qjPTUEEzlzPO84O7J20NPfYwQg6sRk\nUayCAC72IRGC6F7v5sCiA0gDjEJIJJmn00NrZ6sC89z3nPTkdCVHLIkW5qfPZ874OUwcOxGRF2J8\n7\/1OydMSqluqQ2FlbDi5pUagCtivnbE7ZzcX110kY2zGsMKvLmr0NVJwr8AoeldxYFcj0ITECr1T\ncW4xJ\/JOkGnJjBtCRkaYH352OPQUqEoyL3CyUo3AV83FEmKWPzOfc2vOsXzK8sHtiEWjnhz7Y3u0\nvPHjIEMFkKOJpo1Jo2pjFeJ4JSUkRfX39\/g59fIUZ16dicUJDiRTAKrSyVUnObT4kJJ4RqOlo4Xy\nhnLueu7GNhczNAARt0CvtD1rOxVrKrBOsA6+6pf7edj2kKInRbR1tZkzB80WuDBMwkhKW2Zv4Xr+\ndaXsilHnrVMyPa6hS8KwYxhNrGBmATc23WDWuFnKtEftj9h8f3Nc\/kDIMQwrRCMOoCtEYaV4hAF0\npVi46S6jEQbQXUbCTXcdjyBAhOtYOOoakkgQf5WEERsS1c1EMyoq49bZWwfbMtEl1XprzZyCsOb0\nP2xK44iEmU8emBNnW64qj+qPiQoxqr9m2hiP2s9pHBs9nKl\/AKYYaTCS9AqCAAAAAElFTkSuQmCC\" alt=\"\"\/><\/figure><\/div>\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-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/a\/questetra.com\/file\/d\/17CujN8yPOEwW_B6ueaLku83tvRW-X7X7\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Filter-by-Text.xml (opens in a new tab)\">Tsv-String-Filter-by-Text.xml<\/a><\/li><\/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\" 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\/2019\/11\/tsv-string-filter-by-text.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-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-capture-en.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"82248\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/attachment\/tsv-string-filter-by-text-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-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=\"TSV-String-Filter-by-Text-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as &quot;USA,U.S.,United States&quot;.\" class=\"wp-image-82248\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-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-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Cannot specify search terms that contain a comma.<\/li><li>For &#8220;AND search&#8221;, try to place this Automated Step serially.<\/li><li>Special characters in search text settings have no meaning (literal string).<\/li><\/ol>\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=\"XBsQ6yVzPS\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv\/\">Questetra BPMS: Process, Batch Extract as TSV<\/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;Questetra BPMS: Process, Batch Extract as TSV&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-as-tsv\/embed\/#?secret=3ZdfkmmaSh#?secret=XBsQ6yVzPS\" data-secret=\"XBsQ6yVzPS\" 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=\"iLytAHEcDs\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/multiline-string-filter-by-text\/\">Multiline String, Filter by Text<\/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;Multiline String, Filter by Text&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/multiline-string-filter-by-text\/embed\/#?secret=Gdx8ZS8X6l#?secret=iLytAHEcDs\" data-secret=\"iLytAHEcDs\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as &#8220;USA,U.S.,United States&#8221;.<\/p>\n","protected":false},"author":2,"featured_media":82246,"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":"","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":"","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":[],"class_list":["post-82245","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-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":"Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as \"USA,U.S.,United States\".","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-lox","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":83123,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-out-by-text\/","url_meta":{"origin":82245,"position":0},"title":"TSV String, Filter Out by Text","author":"IMAMURA, Genichi","date":"2019-12-26","format":false,"excerpt":"Filters out TSV lines by any search text (Exclude Filter). Only lines that DO NOT contain the search text in the specified column are output. If OR search with multiple texts, specify them as a comma-separated list such as \"USA,U.S.,United States\".","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 Out by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-Out-by-Text-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-Out-by-Text-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-Out-by-Text-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-Out-by-Text-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-Out-by-Text-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":82245,"position":1},"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":[]},{"id":82682,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date\/","url_meta":{"origin":82245,"position":2},"title":"TSV String, Filter by Date","author":"IMAMURA, Genichi","date":"2019-12-12","format":false,"excerpt":"Filters TSV strings using a date range. Only the rows where the specified date column is included in the date range are output. If OR multiple ranges, specify in comma separated like \"2020-01-01","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 Date","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-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-Date-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-Date-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-Date-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-Date-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82669,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-datetime\/","url_meta":{"origin":82245,"position":3},"title":"TSV String, Filter by Datetime","author":"IMAMURA, Genichi","date":"2019-12-12","format":false,"excerpt":"Filters TSV strings using a Datetime range. Only the rows where the specified Datetime column is included in the Datetime range are output. If OR multiple ranges, like \"2020-01-01 00:00","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 Datetime","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Datetime-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-Datetime-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-Datetime-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-Datetime-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-Datetime-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82229,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-filter-by-text\/","url_meta":{"origin":82245,"position":4},"title":"Multiline String, Filter by Text","author":"IMAMURA, Genichi","date":"2019-11-22","format":false,"excerpt":"Filters multiple-line string with any search text. Only lines that contain the search text are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as \"USA, U.S., United States\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Multiline String, Filter by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":109225,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-out-by-text-2021\/","url_meta":{"origin":82245,"position":5},"title":"TSV String, Filter Out by Text","author":"Hirotaka NISHI","date":"2021-07-13","format":false,"excerpt":"Filters out TSV lines by any search text (Exclude Filter). Only lines that DO NOT contain the search text in the specified column are output. If you want to do an OR search with multiple texts, specify them as a comma-separated list such as \"USA,U.S.,United States\".","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 Out by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-Out-by-Text-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-Out-by-Text-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-Out-by-Text-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-Out-by-Text-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-Out-by-Text-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\/82245","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=82245"}],"version-history":[{"count":5,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82245\/revisions"}],"predecessor-version":[{"id":109249,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82245\/revisions\/109249"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/82246"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=82245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=82245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=82245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}