{"id":82388,"date":"2019-12-03T16:52:38","date_gmt":"2019-12-03T07:52:38","guid":{"rendered":"https:\/\/support.questetra.com\/?p=82388"},"modified":"2022-06-01T15:21:19","modified_gmt":"2022-06-01T06:21:19","slug":"tsv-string-sort-by-numeric","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/","title":{"rendered":"TSV String, Sort by Numeric"},"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-sort-by-numeric-2021\/_\">https:\/\/support.questetra.com\/addons\/tsv-string-sort-by-numeric-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, Sort 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\">Sorts TSV text in the numerical order of the specified column. If each column values are &#8220;123 jpy&#8221;, &#8220;1,234 jpy&#8221;, and &#8220;12 jpy&#8221;, they are sorted in the order of &#8220;line including <strong>12 jpy<\/strong>&#8220;, &#8220;line including <strong>123 jpy<\/strong>&#8220;, &#8220;line including <strong>1,234 jpy<\/strong>&#8220;.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2019-12-03 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/\">https:\/\/support.questetra.com\/addons\/tsv-string-sort-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><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-key: Set Column ID(s) for Sort Target (eg &#8220;0&#8221; &#8220;3,1&#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-order: Set DESC or ASC ( default &#8220;DESC&#8221; )<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 Sorted 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\/\/ Numeric parsing depends on JavaScript parseFloat().\n\/\/ If a \"prefix\" precedes a number, it will not be determined as a number. (eg \"$ 100\")\n\/\/ The period \".\" is recognized as a decimal point.\n\/\/ Assumes a digit separator and evaluates all numbers after removing all commas \",\".\n\/\/ If you want to specify multiple sort keys, use {Column ID} in CSV notation (eg \"3,1,0\")\n\/\/ Notes(ja):\n\/\/ \u6570\u5024\u5224\u5b9a\u306f JavaScript parseFloat() \u306b\u4f9d\u5b58\u3057\u307e\u3059\n\/\/ \u6570\u5024\u306e\u524d\u306b \"\u63a5\u982d\u8f9e\" \u304c\u3042\u308b\u3068\u6570\u5024\u3068\u3057\u3066\u5224\u5b9a\u3055\u308c\u307e\u305b\u3093 ( \u4f8b \"$100\" )\n\/\/ \u30d4\u30ea\u30aa\u30c9 \".\" \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 \",\" \u3092\u9664\u53bb\u3057\u305f\u3046\u3048\u3067\u6570\u5024\u5224\u5b9a\u3057\u307e\u3059\n\/\/ \u30bd\u30fc\u30c8\u30ad\u30fc\u3092\u8907\u6570\u6307\u5b9a\u3057\u305f\u3044\u5834\u5408\u3001{Column ID} \u3092CSV\u8868\u8a18\u3067\u884c\u3044\u307e\u3059 ( \u4f8b \"3,1,0\" )\n\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 targetColIds = configs.get( \"conf_TargetColIds\" ) + \"\"; \/\/ config required\nlet   sortOrder    = configs.get( \"conf_SortOrder\" ) + \"\";    \/\/ config not required\nconst dataIdC      = configs.get( \"conf_DataIdC\" ) + \"\";      \/\/ config required\nengine.log( \" AutomatedTask Config: Sort Key Column(s): \" + targetColIds );\nengine.log( \" AutomatedTask Config: Sort Order: \" + sortOrder );\n\nif( targetColIds === \"\" ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {Sort Column} is empty \\n\" );\n}\nconst arrTargetColIds = targetColIds.split(\",\");\n\nif( sortOrder !== \"ASC\" ){\n  sortOrder = \"DESC\";\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nconst inputString = engine.findDataByNumber( dataIdA ) + \"\";\nlet   arrInputString = inputString.split(\"\\n\");\nengine.log( \" AutomatedTask MultilineString:\" + \n            \" TSV {A}, number of lines: \" + arrInputString.length );\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\narrInputString.sort( function( tsvlineA, tsvlineB ){\n  let arrTsvlineA = tsvlineA.split(\"\\t\");\n  let arrTsvlineB = tsvlineB.split(\"\\t\");\n\n  if( sortOrder === \"DESC\" ){\n    for( let i = 0; i &lt; arrTargetColIds.length; i++ ){\n      if( arrTsvlineA.length &lt;= arrTargetColIds&#091;i] ||\n          arrTsvlineB.length &lt;= arrTargetColIds&#091;i] ){\n        throw new Error( \"\\n AutomatedTask UnexpectedNumberError:\" +\n                         \" Number {Sort Key ID} is larger than TSV length \\n\" );\n      }\n      if( parseFloat(arrTsvlineA&#091; parseInt(arrTargetColIds&#091;i]) ].replace( \/,\/g,\"\")) &lt;\n          parseFloat(arrTsvlineB&#091; parseInt(arrTargetColIds&#091;i]) ].replace( \/,\/g,\"\")) ){ return 1; }\n      if( parseFloat(arrTsvlineA&#091; parseInt(arrTargetColIds&#091;i]) ].replace( \/,\/g,\"\")) &gt;\n          parseFloat(arrTsvlineB&#091; parseInt(arrTargetColIds&#091;i]) ].replace( \/,\/g,\"\")) ){ return -1; }\n    }\n  }else{ \/\/ ASC: alphabetical from A to Z\n    for( let i = 0; i &lt; arrTargetColIds.length; i++ ){\n      if( arrTsvlineA.length &lt;= arrTargetColIds&#091;i] ||\n          arrTsvlineB.length &lt;= arrTargetColIds&#091;i] ){\n        throw new Error( \"\\n AutomatedTask UnexpectedNumberError:\" +\n                         \" Number {Sort Key ID} is larger than TSV length \\n\" );\n      }\n      if( parseFloat(arrTsvlineA&#091; parseInt(arrTargetColIds&#091;i]) ].replace( \/,\/g,\"\")) &gt;\n          parseFloat(arrTsvlineB&#091; parseInt(arrTargetColIds&#091;i]) ].replace( \/,\/g,\"\")) ){ return 1; }\n      if( parseFloat(arrTsvlineA&#091; parseInt(arrTargetColIds&#091;i]) ].replace( \/,\/g,\"\")) &lt;\n          parseFloat(arrTsvlineB&#091; parseInt(arrTargetColIds&#091;i]) ].replace( \/,\/g,\"\")) ){ return -1; }\n    }\n  }\n  return 0;\n});\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setDataByNumber( dataIdC, arrInputString.join(\"\\n\") );\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,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACfElEQVRYR82XP2gTURzHPy+RxLZQ\naAQpNUiHTqURU4TiKKUOdiiIDgYd1MJdnTRYAh06ZLMIcWovlOig6GbnThadpGixUEzBwUkE0XaJ\niAhPzutLcne59O6acGYKd7\/f733e9\/3+vBNE\/BO+1y\/Ti+QyggtIsgiGgYED\/z0knxFsIXmF4CUa\nP\/3EPhzgCYP8pgDowHE\/QYFfgEGCB9zkazuf9gAGOoKHQJ\/PhZ1mNST30TG8\/L0ByiwDcyEXdrqt\noHGnVazWAAbPEVzr0OJWGMkLdHLOmG6AkDsfHRildL7ExMkJYiJWX2d3f5f5t\/NsfNkwn7mUsANY\nZ74SZueL44ssZBdIxpM2d4lk9eMq2htNKTHXnBMNACvbP4VNuOK5IoWzBRKxhIu\/Uq0w+3pWPa+R\nYERVRwOgTAm4G2b3pk8AANP8ERr3zD8WgNlk4HuAOndxBgQw+8QJs1lZAAbXETwNu\/sQCphVcQOd\nZ0qBCnDLD0D+TJ58Jk9\/ot9mHhdxeo71IA5EbX7pyAH16jEat5UC7xFk\/QBsX9kmk8r4Ma3btASQ\nbKEzrhT40TRY2gbfubqDWfNBfh4K7KGRUgDSb8AOAoCG+G8AIj4CA1cSpvvS5EZyjKXGbKczeWqS\nod4hvyf2z85PErrKcP3SOlPpqZZlFWh1LwCwlaGrEYVJNi8wDwVsjcjVirsM4GjF1jywDaMuAziG\nkQngGMddBPAYx9ZQql9I1i6uMTM8c+QkrP2pUXxXZOnDkpUiEo8LicqgpivZ9OlpUslU0KS32Vf3\nq2x+21TPDrmSKbNIL6UtlDiSBJZzwGt5Q4kIP0wURKSfZs3aR\/Zx2oEEaBfiLy6JADB1SkvsAAAA\nAElFTkSuQmCC\" 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\/1pD5vkjT_Ov2EIFfEJhv2wqY0rPg9DFRS\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Sort-by-Numeric.xml (opens in a new tab)\">Tsv-String-Sort-by-Numeric.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-sort-by-numeric.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-Sort-by-Numeric-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"82392\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/attachment\/tsv-string-sort-by-numeric-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-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-Sort-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-Sort-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-Sort-by-Numeric-capture-en.png?fit=1024%2C576&amp;ssl=1\" alt=\"Sorts TSV text in the numerical order of the specified column. If each column values are &quot;123 jpy&quot;, &quot;1,234 jpy&quot;, and &quot;12 jpy&quot;, they are sorted in the order of &quot;line including 12 jpy&quot;, &quot;line including 123 jpy&quot;, &quot;line including 1,234 jpy&quot;.\" class=\"wp-image-82392\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-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-Sort-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-Sort-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-Sort-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\"><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><li>If a &#8220;prefix&#8221; precedes a number, it will not be determined as a number. (eg &#8220;$ 100&#8221;)<\/li><li>The period &#8220;.&#8221; is recognized as a decimal point.<\/li><li>Assumes a digit separator and evaluates all numbers after removing all commas &#8220;,&#8221;.<\/li><li>If you want to specify multiple sort keys, use {Column ID} in CSV notation (eg &#8220;3,1,0&#8221;)<\/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-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"BV5SUiB7QF\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text\/\">TSV String, Sort 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;TSV String, Sort by Text&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-sort-by-text\/embed\/#?secret=Dkm4YywOBo#?secret=BV5SUiB7QF\" data-secret=\"BV5SUiB7QF\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Sorts TSV text in the numerical order of the specified column. If each column values are &#8220;123 jpy&#8221;, &#8220;1,234 jpy&#8221;, and &#8220;12 jpy&#8221;, they are sorted in the order of &#8220;line including 12 jpy&#8221;, &#8220;line including 123 jpy&#8221;, &#8220;line including 1,234 jpy&#8221;.<\/p>\n","protected":false},"author":2,"featured_media":82389,"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-82388","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\/12\/TSV-String-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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-Sort-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":"Sorts TSV text in the numerical order of the specified column. If each column values are \"123 jpy\", \"1,234 jpy\", and \"12 jpy\", they are sorted in the order of \"line including 12 jpy\", \"line including 123 jpy\", \"line including 1,234 jpy\".","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-lqQ","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":109450,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric-2021\/","url_meta":{"origin":82388,"position":0},"title":"TSV String, Sort by Numeric","author":"Hirotaka NISHI","date":"2021-07-13","format":false,"excerpt":"Sorts TSV text in the numerical order of the specified column. If each column values are \"123 jpy\", \"1,234 jpy\", and \"12 jpy\", they are sorted in the order \"line including 12 jpy\", \"line including 123 jpy\", \"line including 1,234 jpy\"","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Sort by Numeric","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82397,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-sort-by-numeric\/","url_meta":{"origin":82388,"position":1},"title":"TSV\u6587\u5b57\u5217, \u6570\u5b57\u30bd\u30fc\u30c8","author":"IMAMURA, Genichi","date":"2019-12-03","format":false,"excerpt":"\u6307\u5b9a\u30ab\u30e9\u30e0\u306e\u6570\u5024\u9806\u3067TSV\u30c6\u30ad\u30b9\u30c8\u3092\u884c\u30bd\u30fc\u30c8\u3057\u307e\u3059\u3002\u5404\u30ab\u30e9\u30e0\u5024\u304c\u300c123\u5186\u300d\u300c1,234\u5186\u300d\u300c12\u5186\u300d\u3060\u3063\u305f\u5834\u5408\u306f\u3001\u300c12\u5186\u3092\u542b\u3080\u884c\u300d\u300c123\u5186\u3092\u542b\u3080\u884c\u300d\u300c1,234\u5186\u3092\u542b\u3080\u884c\u300d\u306e\u9806\u306b\u4e26\u3079\u66ff\u3048\u3089\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"TSV\u6587\u5b57\u5217, \u6570\u5b57\u30bd\u30fc\u30c8","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-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-Sort-by-Numeric-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-Sort-by-Numeric-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-Sort-by-Numeric-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-Sort-by-Numeric-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":109459,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-sort-by-numeric-2021\/","url_meta":{"origin":82388,"position":2},"title":"TSV\u6587\u5b57\u5217, \u6570\u5b57\u30bd\u30fc\u30c8","author":"Hirotaka NISHI","date":"2021-07-13","format":false,"excerpt":"\u6307\u5b9a\u30ab\u30e9\u30e0\u306e\u6570\u5024\u9806\u3067TSV\u30c6\u30ad\u30b9\u30c8\u3092\u884c\u30bd\u30fc\u30c8\u3057\u307e\u3059\u3002\u5404\u30ab\u30e9\u30e0\u5024\u304c\u300c123\u5186\u300d\u300c1,234\u5186\u300d\u300c12\u5186\u300d\u3060\u3063\u305f\u5834\u5408\u306f\u3001\u300c12\u5186\u3092\u542b\u3080\u884c\u300d\u300c123\u5186\u3092\u542b\u3080\u884c\u300d\u300c1,234\u5186\u3092\u542b\u3080\u884c\u300d\u306e\u9806\u306b\u4e26\u3079\u66ff\u3048\u3089\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"TSV\u6587\u5b57\u5217, \u6570\u5b57\u30bd\u30fc\u30c8","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-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-Sort-by-Numeric-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-Sort-by-Numeric-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-Sort-by-Numeric-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-Sort-by-Numeric-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82375,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text\/","url_meta":{"origin":82388,"position":3},"title":"TSV String, Sort by Text","author":"IMAMURA, Genichi","date":"2019-12-03","format":false,"excerpt":"Sorts TSV lines in the order of the character code of the specified column. If the column value for each line is Jan Feb March, the text is sorted in the order of \"line that contains Feb\", \"line that contains Jan\" and \"line that contains March\".","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 String, Sort by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-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-Sort-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-Sort-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-Sort-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-Sort-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":88658,"url":"https:\/\/support.questetra.com\/en\/addons\/stripe-charge-object-create\/","url_meta":{"origin":82388,"position":4},"title":"Stripe: Charge Object, Create","author":"IMAMURA, Genichi","date":"2020-06-03","format":false,"excerpt":"Creates the Charge object on the payment platform Stripe to charge the Customer ID (cus_12345678901234) for any amount in any currency. If the charging process fails, Charge object is not created and error log such as expired_card is output.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Stripe: Charge Object, Create","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Stripe-Charge-Object-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Stripe-Charge-Object-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Stripe-Charge-Object-Create-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Stripe-Charge-Object-Create-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Stripe-Charge-Object-Create-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":112482,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-create-summary-table-for-numeric-column-2021\/","url_meta":{"origin":82388,"position":5},"title":"TSV String, Create Summary Table for Numeric Column","author":"IMAMURA, Genichi","date":"2021-09-07","format":false,"excerpt":"Aggregates the values in a numeric column by aggregation-keys. Sum, Percentage, Count and Average are tabulated as a summary table TSV. For example, \"Sales for each client\" is aggregated from \"Sales log TSV\". Grand Total Tabulation.","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, Create Summary Table for Numeric Column","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-create-summary-table-for-numeric-column-2021-nocode-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\/2021\/09\/tsv-string-create-summary-table-for-numeric-column-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-create-summary-table-for-numeric-column-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-create-summary-table-for-numeric-column-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-create-summary-table-for-numeric-column-2021-nocode-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\/82388","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=82388"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82388\/revisions"}],"predecessor-version":[{"id":109796,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82388\/revisions\/109796"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/82389"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=82388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=82388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=82388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}