{"id":82682,"date":"2019-12-12T17:15:09","date_gmt":"2019-12-12T08:15:09","guid":{"rendered":"https:\/\/support.questetra.com\/?p=82682"},"modified":"2022-06-01T15:20:49","modified_gmt":"2022-06-01T06:20:49","slug":"tsv-string-filter-by-date","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date\/","title":{"rendered":"TSV String, Filter by Date"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;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:#FFF4CC;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-date-2021\/_\">https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date-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-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\">TSV String, Filter by Date<\/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 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 &#8220;2020-01-01&lt;2020-01-07,2020-01-21&lt;2020-01-27&#8221;.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2019-12-12 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date\/\">https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date\/<\/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> B-target: Set Date-info Column ID for Filtering (eg &#8220;0&#8221; )<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> B-range: Set Date Filter (eg &#8220;2010-01-01&lt;2010-01-31&#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\/\/ Supported date format is \"YYYY-MM-DD\".\n\/\/ For \"AND search\", try to place this Automated Step serially.\n\/\/ Equals at range boundary values are included in the filter range.\n\/\/  (No Problem \"2019-10-05&lt;2019-10-05\")\n\/\/\n\/\/ Notes(ja):\n\/\/ \u5bfe\u5fdc\u3059\u308b\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306f \"YYYY-MM-DD\" \u3067\u3059\n\/\/ \"AND\u691c\u7d22\" \u306f\u81ea\u52d5\u5de5\u7a0b\u306e\u76f4\u5217\u914d\u7f6e\u3092\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\n\/\/ \u7bc4\u56f2\u5883\u754c\u5024\u306b\u304a\u3051\u308b\u30a4\u30b3\u30fc\u30eb\u306f\u30d5\u30a3\u30eb\u30bf\u7bc4\u56f2\u306b\u542b\u307e\u308c\u307e\u3059\n\/\/ \uff08\u554f\u984c\u306e\u306a\u3044\u30d5\u30a3\u30eb\u30bf\u4f8b \"2019-10-05&lt;2019-10-05\"\uff09\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 rangeFilters = configs.get( \"conf_RangeFilters\" ) + \"\";  \/\/ config required\nconst dataIdC      = configs.get( \"conf_DataIdC\" ) + \"\";       \/\/ config required\nengine.log( \" AutomatedTask Config: Target Column ID: \" + targetColId );\nengine.log( \" AutomatedTask Config: Range Filters: \" + rangeFilters );\n\nif( targetColId === \"\" ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {Column ID} is empty \\n\" );\n}\nconst numTargetColId = parseInt( targetColId );\n\nif( rangeFilters === \"\" ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {Range Fileters} is empty \\n\" );\n}\nconst arrRangeFilters = rangeFilters.split(\",\");\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 ==\n\/\/ BPMS Date Format\nconst regBpmsYMD = \/^\\d{4}-\\d{2}-\\d{2}$\/;\n\n\/\/ parse Filters\nlet arrFilterFromTo = &#091;];\nfor( let i = 0; i &lt; arrRangeFilters.length; i++ ){\n  let arrRangeMinMax = arrRangeFilters&#091;i].split(\"&lt;\");\n  if( arrRangeMinMax.length !== 2 ){\n    throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                     \" {Range Fileter} must have one '&lt;': \" + \n                     arrRangeFilters&#091;i] + \" \\n\" );\n  }\n  if( ! regBpmsYMD.test( arrRangeMinMax&#091;0] ) ){\n    throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                     \" Config DateRangeFr Format Error \\n\" );\n  }\n  if( ! regBpmsYMD.test( arrRangeMinMax&#091;1] ) ){\n    throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                     \" Config DateRangeTo Format Error \\n\" );\n  }\n  let arrDatePartsFr = arrRangeMinMax&#091;0].split(\"-\");\n  let arrDatePartsTo = arrRangeMinMax&#091;1].split(\"-\");\n  let dateFrom = new Date( arrDatePartsFr&#091;0], arrDatePartsFr&#091;1] - 1, arrDatePartsFr&#091;2] );\n  let dateTo   = new Date( arrDatePartsTo&#091;0], arrDatePartsTo&#091;1] - 1, arrDatePartsTo&#091;2] );\n  \/\/ \"Note: TimeZoneOffset has been added\"\n\n  if( dateFrom &gt; dateTo ){\n    throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                     \" {Range Fileter} must be Ascending Order: \" + \n                     arrRangeFilters&#091;i] + \" \\n\" );\n  }\n  arrFilterFromTo.push( &#091; dateFrom, dateTo] );\n}\n\n\/\/ Target matches Filter or not\nlet outputString = \"\";\nfor( let i = 0; i &lt; arrInputString.length; i++ ){\n  let arrTsvLine     = arrInputString&#091;i].split(\"\\t\");\n  if( ! regBpmsYMD.test( arrTsvLine&#091; numTargetColId ] ) ){ continue; }\n  let arrTargetValue  = arrTsvLine&#091; numTargetColId ].split(\"-\");\n  let dateTargetValue = new Date( arrTargetValue&#091;0], arrTargetValue&#091;1] - 1, arrTargetValue&#091;2] );\n  \/\/ \"Note: TimeZoneOffset has been added\"\n\n  for( let j = 0; j &lt; arrFilterFromTo.length; j++ ){\n    if( arrFilterFromTo&#091;j]&#091;0] &lt;= dateTargetValue &amp;&amp; dateTargetValue &lt;= arrFilterFromTo&#091;j]&#091;1] ){\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\/1gnMkxFPYvfKAGRpc6VkEsieiQH6MXEDl\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Filter-by-Date.xml (opens in a new tab)\">Tsv-String-Filter-by-Date.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\/12\/tsv-string-filter-by-date.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\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"82685\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date\/attachment\/tsv-string-filter-by-date-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-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-Date-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-capture-en.png?fit=1024%2C576&amp;ssl=1\" alt=\"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 &quot;2020-01-01<2020-01-07,2020-01-21<2020-01-27&quot;.\" class=\"wp-image-82685\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-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><span style=\"font-size: 1rem;\">Supported date format is &#8220;YYYY-MM-DD&#8221;.<\/span><\/li><li>For &#8220;AND search&#8221;, try to place this Automated Step serially.<\/li><li>Equals at range boundary values are included in the filter range.<ol><li> (No Problem &#8220;2019-10-05&lt;2019-10-05&#8221;)<\/li><\/ol><\/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=\"cF6MdJxKCK\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/\">TSV String, Filter by Text<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cTSV String, Filter by Text\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/embed\/#?secret=zRTpifWXTh#?secret=cF6MdJxKCK\" data-secret=\"cF6MdJxKCK\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8220;2020-01-01<2020-01-07,2020-01-21<2020-01-27\".\n<\/p>\n","protected":false},"author":2,"featured_media":82683,"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":[],"faq_section":[],"class_list":["post-82682","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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\/12\/TSV-String-Filter-by-Date-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":1,"uagb_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","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-lvA","jetpack-related-posts":[{"id":82669,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-datetime\/","url_meta":{"origin":82682,"position":0},"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":82695,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-numeric\/","url_meta":{"origin":82682,"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":109453,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date-2021\/","url_meta":{"origin":82682,"position":2},"title":"TSV String, Filter by Date","author":"Hirotaka NISHI","date":"2021-07-19","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 \"2021-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":109451,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-datetime-2021\/","url_meta":{"origin":82682,"position":3},"title":"TSV String, Filter by Datetime","author":"Hirotaka NISHI","date":"2021-07-19","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 \"2021-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":70961,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-filteringbydate\/","url_meta":{"origin":82682,"position":4},"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;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-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":[]},{"id":82688,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-filter-by-date\/","url_meta":{"origin":82682,"position":5},"title":"TSV\u6587\u5b57\u5217, \u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf","author":"IMAMURA, Genichi","date":"2019-12-12","format":false,"excerpt":"\u65e5\u4ed8\u7bc4\u56f2\u3092\u4f7f\u3063\u3066TSV\u6587\u5b57\u5217\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u307e\u3059\u3002\u6307\u5b9a\u306e\u65e5\u4ed8\u30ab\u30e9\u30e0\u304c\u65e5\u4ed8\u7bc4\u56f2\u306b\u542b\u307e\u308c\u308b\u884c\u306e\u307f\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\u8907\u6570\u306e\u7bc4\u56f2\u3092 OR \u6307\u5b9a\u3057\u305f\u3044\u5834\u5408\u306f \"2020-01-01","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"TSV\u6587\u5b57\u5217, \u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-ja.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\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82682","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=82682"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82682\/revisions"}],"predecessor-version":[{"id":109727,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82682\/revisions\/109727"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/82683"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=82682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=82682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=82682"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=82682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}