{"id":82695,"date":"2021-02-01T13:30:00","date_gmt":"2021-02-01T04:30:00","guid":{"rendered":"https:\/\/support.questetra.com\/?p=82695"},"modified":"2023-08-22T16:03:36","modified_gmt":"2023-08-22T07:03:36","slug":"tsv-string-filter-by-numeric","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-numeric\/","title":{"rendered":"TSV String, Filter by Numeric"},"content":{"rendered":"\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 Numeric<\/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 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 &#8220;-100&lt;36.4,37.5&lt;100&#8221;.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">(C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-numeric\/\">https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-numeric\/<\/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> A: Select STRING DATA for TSV String<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B-target: Set Numeric 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 Numeric Filter (eg &#8220;0&lt;100&#8221; &#8220;-100&lt;36.4,37.5&lt;100&#8221;)<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 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 (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\/\/ (c) 2019, Questetra, Inc. (the MIT License)\n\/\/ Notes:\n\/\/ Numeric parsing depends on JavaScript parseFloat().\n\/\/ If a &quot;prefix&quot; precedes a number, it will not be determined as a number. (eg &quot;$ 100&quot;)\n\/\/ The period &quot;.&quot; is recognized as a decimal point.\n\/\/ Assumes a digit separator and evaluates all numbers after removing all commas &quot;,&quot;.\n\/\/ If infinity, specify &quot;(-)Infinity&quot;. (eg. &quot;-Infinity&lt;36.4,37.5&lt;Infinity&quot;)\n\/\/ For &quot;AND search&quot;, try to place this Automated Step serially.\n\/\/ Equals at range boundary values are included. (No Problem &quot;37.0&lt;37.0&quot;)\n\/\/\n\/\/ Notes(ja):\n\/\/ \u6570\u5024\u5224\u5b9a\u306f JavaScript parseFloat() \u306b\u4f9d\u5b58\u3057\u307e\u3059\n\/\/ \u6570\u5024\u306e\u524d\u306b &quot;\u63a5\u982d\u8f9e&quot; \u304c\u3042\u308b\u3068\u6570\u5024\u3068\u3057\u3066\u5224\u5b9a\u3055\u308c\u307e\u305b\u3093 ( \u4f8b &quot;$100&quot; )\n\/\/ \u30d4\u30ea\u30aa\u30c9 &quot;.&quot; \u306f\u5c0f\u6570\u70b9\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u307e\u3059\n\/\/ \u6841\u533a\u5207\u308a\u6587\u5b57\u3092\u60f3\u5b9a\u3057\u3001\u5168\u3066\u306e\u30ab\u30f3\u30de &quot;,&quot; \u3092\u9664\u53bb\u3057\u305f\u3046\u3048\u3067\u6570\u5024\u5224\u5b9a\u3057\u307e\u3059\n\/\/ \u7121\u9650\u5927\u306f &quot;(-)Infinity&quot; \u3092\u6307\u5b9a\u3057\u307e\u3059 \uff08\u4f8b &quot;-Infinity&lt;36.4,37.5&lt;Infinity&quot;\uff09\n\/\/ &quot;AND\u691c\u7d22&quot; \u306f\u81ea\u52d5\u5de5\u7a0b\u306e\u76f4\u5217\u914d\u7f6e\u3092\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\n\/\/ \u7bc4\u56f2\u5883\u754c\u5024\u306f\u30d5\u30a3\u30eb\u30bf\u7bc4\u56f2\u306b\u542b\u307e\u308c\u307e\u3059 \uff08\u554f\u984c\u306e\u306a\u3044\u8a2d\u5b9a\u4f8b &quot;37.0&lt;37.0&quot;\uff09\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA      = configs.get( &quot;conf_DataIdA&quot; ) + &quot;&quot;;       \/\/ config required\nconst targetColId  = configs.get( &quot;conf_TargetColId&quot; ) + &quot;&quot;;   \/\/ config required\nconst rangeFilters = configs.get( &quot;conf_RangeFilters&quot; ) + &quot;&quot;;  \/\/ config required\nconst dataIdC      = configs.get( &quot;conf_DataIdC&quot; ) + &quot;&quot;;       \/\/ config required\nengine.log( &quot; AutomatedTask Config: Target Column ID: &quot; + targetColId );\nengine.log( &quot; AutomatedTask Config: Range Filters: &quot; + rangeFilters );\n\nif( targetColId === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {Column ID} is empty \\n&quot; );\n}\nconst numTargetColId = parseInt( targetColId );\n\nif( rangeFilters === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {Range Fileters} is empty \\n&quot; );\n}\nconst arrRangeFilters = rangeFilters.split(&quot;,&quot;);\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nconst inputString = engine.findDataByNumber( dataIdA ) + &quot;&quot;;\nconst arrInputString = inputString.split(&quot;\\n&quot;);\nengine.log( &quot; AutomatedTask MultilineString:&quot; + \n            &quot; TSV {A}, number of lines: &quot; + arrInputString.length );\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/ parse Filters\nlet arrFilterFromTo = [];\nfor( let i = 0; i &lt; arrRangeFilters.length; i++ ){\n  let arrRangeMinMax = arrRangeFilters[i].split(&quot;&lt;&quot;);\n  if( arrRangeMinMax.length !== 2 ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; {Range Fileter} must have one &#39;&lt;&#39;: &quot; + \n                     arrRangeFilters[i] + &quot; \\n&quot; );\n  }\n  let numRangeMin = parseFloat( arrRangeMinMax[0] );\n  let numRangeMax = parseFloat( arrRangeMinMax[1] );\n  if( numRangeMin &gt; numRangeMax ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; {Range Fileter} must be Ascending Order: &quot; + \n                     arrRangeFilters[i] + &quot; \\n&quot; );\n  }\n  arrFilterFromTo.push( [ numRangeMin, numRangeMax] );\n}\n\n\/\/ Target matches Filter or not\nlet outputString = &quot;&quot;;\nfor( let i = 0; i &lt; arrInputString.length; i++ ){\n  let arrTsvLine     = arrInputString[i].split(&quot;\\t&quot;);\n  let numTargetValue = parseFloat( arrTsvLine[ numTargetColId ].replace( \/,\/g,&quot;&quot;) );\n  if( isNaN(numTargetValue) ){ continue; }\n  for( let j = 0; j &lt; arrFilterFromTo.length; j++ ){\n    if( arrFilterFromTo[j][0] &lt;= numTargetValue &&\n        numTargetValue &lt;= arrFilterFromTo[j][1] ){\n      outputString += arrInputString[i];\n      outputString += &quot;\\n&quot;;\n      break;\n    }\n  }\n}\noutputString = outputString.replace(\/[\\n]*$\/, &quot;&quot;);\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( outputString === &quot;&quot; ){\n  engine.log( &quot; AutomatedTask DataUpdating: Output Text empty&quot; );\n}\nengine.setDataByNumber( dataIdC, outputString );\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\"><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>\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\"><\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Filter-by-Numeric.xml (opens in a new tab)\" href=\"https:\/\/drive.google.com\/file\/d\/1EMzjgpwA7tCsqS5yoR4D1v0vmVz_Ieul\/view?usp=sharing\" target=\"_blank\">Tsv-String-Filter-by-Numeric.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-01-13 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1lRgDRKqGwcbvv2-97-rJ7BtCB_Ila9lG\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Tsv-String-Filter-by-Numeric-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<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\" loading=\"lazy\" decoding=\"async\" width=\"1049\" height=\"800\" data-attachment-id=\"102030\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/tsv-string-filter-by-numeric-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/tsv-string-filter-by-numeric.png?fit=1049%2C800&amp;ssl=1\" data-orig-size=\"1049,800\" 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-numeric\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/tsv-string-filter-by-numeric.png?fit=826%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/tsv-string-filter-by-numeric.png?resize=1049%2C800&#038;ssl=1\" alt=\"\" class=\"wp-image-102030\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/tsv-string-filter-by-numeric.png?w=1049&amp;ssl=1 1049w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/tsv-string-filter-by-numeric.png?resize=413%2C315&amp;ssl=1 413w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/tsv-string-filter-by-numeric.png?resize=826%2C630&amp;ssl=1 826w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/tsv-string-filter-by-numeric.png?resize=768%2C586&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/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\/12\/TSV-String-Filter-by-Numeric-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"82701\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-numeric\/attachment\/tsv-string-filter-by-numeric-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-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-Numeric-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-Numeric-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-Numeric-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"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 &quot;-100<36.4,37.5<100&quot;.\" class=\"wp-image-82701\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-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-Numeric-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-Numeric-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-Numeric-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\">\n<li>Numeric parsing depends on JavaScript <a href=\"https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseFloat\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"parseFloat() (opens in a new tab)\">parseFloat()<\/a>.<\/li>\n\n\n\n<li>If a &#8220;prefix&#8221; precedes a number, it will not be determined as a number. (eg &#8220;$ 100&#8221;)<\/li>\n\n\n\n<li>The period &#8220;.&#8221; is recognized as a decimal point.<\/li>\n\n\n\n<li>Assumes a digit separator and evaluates all numbers after removing all commas &#8220;,&#8221;.<\/li>\n\n\n\n<li>If infinity, specify &#8220;(-)Infinity&#8221;. (eg. &#8220;-Infinity&lt;36.4,37.5&lt;Infinity&#8221;)<\/li>\n\n\n\n<li>For &#8220;AND search&#8221;, try to place this Automated Step serially.<\/li>\n\n\n\n<li>Equals at range boundary values are included. (No Problem &#8220;37.0&lt;37.0&#8221;)<\/li>\n<\/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=\"FaDqtgV8QJ\"><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=EKlU7SS6pQ#?secret=FaDqtgV8QJ\" data-secret=\"FaDqtgV8QJ\" 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 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 &#8220;-100<36.4,37.5<100\".\n<\/p>\n","protected":false},"author":2,"featured_media":82696,"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":[389],"class_list":["post-82695","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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-Numeric-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":2,"uagb_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","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-lvN","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":82682,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date\/","url_meta":{"origin":82695,"position":0},"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":82695,"position":1},"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":82245,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/","url_meta":{"origin":82695,"position":2},"title":"TSV String, Filter by Text","author":"IMAMURA, Genichi","date":"2019-11-25","format":false,"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\".","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 Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-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\/TSV-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\/TSV-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\/TSV-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\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":83123,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-out-by-text\/","url_meta":{"origin":82695,"position":3},"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":82229,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-filter-by-text\/","url_meta":{"origin":82695,"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":109451,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-datetime-2021\/","url_meta":{"origin":82695,"position":5},"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":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82695","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=82695"}],"version-history":[{"count":10,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82695\/revisions"}],"predecessor-version":[{"id":149953,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82695\/revisions\/149953"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/82696"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=82695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=82695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=82695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}