{"id":109455,"date":"2021-07-14T13:44:23","date_gmt":"2021-07-14T04:44:23","guid":{"rendered":"https:\/\/support.questetra.com\/?p=109455"},"modified":"2023-08-21T18:02:01","modified_gmt":"2023-08-21T09:02:01","slug":"tsv-string-sort-by-text-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text-2021\/","title":{"rendered":"TSV String, Sort by Text"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><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 Text<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> 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 &#8220;line that contains Feb&#8221;, &#8220;line that contains Jan&#8221; and &#8220;line that contains March&#8221;.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"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=\"far 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=\"far 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<\/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>\/\/ GraalJS Script (engine type: 2)\n\/\/ (c) 2021, Questetra, Inc. (the MIT License)\n\/\/ Notes:\n\/\/ If specifying multiple sort keys, use {Column ID} in CSV notation. (eg &quot;3,1,0&quot;)\n\/\/ Notes(ja):\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 &quot;3,1,0&quot; )\n\n\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA      = configs.get( &quot;conf_DataIdA&quot; ) + &quot;&quot;;      \/\/ config required\nconst targetColIds = configs.get( &quot;conf_TargetColIds&quot; ) + &quot;&quot;; \/\/ config required\nlet   sortOrder    = configs.get( &quot;conf_SortOrder&quot; ) + &quot;&quot;;    \/\/ config not required\nconst dataIdC      = configs.get( &quot;conf_DataIdC&quot; ) + &quot;&quot;;      \/\/ config required\nengine.log( &quot; AutomatedTask Config: Sort Key Column(s): &quot; + targetColIds );\nengine.log( &quot; AutomatedTask Config: Sort Order: &quot; + sortOrder );\n\nif( targetColIds === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {Sort Column} is empty \\n&quot; );\n}\nconst arrTargetColIds = targetColIds.split(&quot;,&quot;);\n\nif( sortOrder !== &quot;ASC&quot; ){\n  sortOrder = &quot;DESC&quot;;\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nconst inputString = engine.findDataByNumber( dataIdA ) + &quot;&quot;;\nlet   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 ==\narrInputString.sort( function( tsvlineA, tsvlineB ){\n  let arrTsvlineA = tsvlineA.split(&quot;\\t&quot;);\n  let arrTsvlineB = tsvlineB.split(&quot;\\t&quot;);\n\n  if( sortOrder === &quot;DESC&quot; ){\n    for( let i = 0; i &lt; arrTargetColIds.length; i++ ){\n      if( arrTsvlineA.length &lt;= arrTargetColIds[i] ||\n          arrTsvlineB.length &lt;= arrTargetColIds[i] ){\n        throw new Error( &quot;\\n AutomatedTask UnexpectedNumberError:&quot; +\n                         &quot; Number {Sort Key ID} is larger than TSV length \\n&quot; );\n      }\n      if( arrTsvlineA[ parseInt(arrTargetColIds[i]) ] &lt;\n          arrTsvlineB[ parseInt(arrTargetColIds[i]) ] ){ return 1; }\n      if( arrTsvlineA[ parseInt(arrTargetColIds[i]) ] &gt;\n          arrTsvlineB[ parseInt(arrTargetColIds[i]) ] ){ 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[i] ||\n          arrTsvlineB.length &lt;= arrTargetColIds[i] ){\n        throw new Error( &quot;\\n AutomatedTask UnexpectedNumberError:&quot; +\n                         &quot; Number {Sort Key ID} is larger than TSV length \\n&quot; );\n      }\n      if( arrTsvlineA[ parseInt(arrTargetColIds[i]) ] &gt;\n          arrTsvlineB[ parseInt(arrTargetColIds[i]) ] ){ return 1; }\n      if( arrTsvlineA[ parseInt(arrTargetColIds[i]) ] &lt;\n          arrTsvlineB[ parseInt(arrTargetColIds[i]) ] ){ 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(&quot;\\n&quot;) );\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACfElEQVRYR82XP2gTURzHPy+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\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1KbLtmUmvXGTAhc1M16EU-Jjq_S2EgDAs\/view?usp=drivesdk\" target=\"_blank\">Tsv-String-Sort-by-Text-2021.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-07-09 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1znRFHS0hzJ0RrSTzsy0lL3KP3F70Kw2d\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Tsv-String-Sort-by-Text-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-20 (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<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"> The Add-on import feature is available with <span style=\"background-color:rgba(0, 0, 0, 0);color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>If specifying multiple sort keys, use {Column ID} in CSV notation. (eg &#8220;3,1,0&#8221;)<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/tsv-string-sort-by-text-en.png?ssl=1\" alt=\"\" class=\"wp-image\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-capture-en.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"82378\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text\/attachment\/tsv-string-sort-by-text-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"TSV-String-Sort-by-Text-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-Text-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-Text-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"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 &quot;line that contains Feb&quot;, &quot;line that contains Jan&quot; and &quot;line that contains March&quot;.\" class=\"wp-image-82378\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-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-Text-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-Text-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-Text-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-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=\"OKrZvGvcBi\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/\">TSV String; Re-order Columns<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;TSV String; Re-order Columns&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-reorder-columns\/embed\/#?secret=bD8yLpmBFS#?secret=OKrZvGvcBi\" data-secret=\"OKrZvGvcBi\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8220;line that contains Feb&#8221;, &#8220;line that contains Jan&#8221; and &#8220;line that contains March&#8221;.<\/p>\n","protected":false},"author":3,"featured_media":82376,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[365,389],"class_list":["post-109455","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-easy-config-addon","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-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-Text-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-Text-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-Text-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-Text-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-Text-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-Text-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":3,"uagb_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\".","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-stp","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":82375,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text\/","url_meta":{"origin":109455,"position":0},"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;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/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":82382,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-sort-by-text\/","url_meta":{"origin":109455,"position":1},"title":"TSV\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30bd\u30fc\u30c8","author":"IMAMURA, Genichi","date":"2019-12-03","format":false,"excerpt":"\u6307\u5b9a\u30ab\u30e9\u30e0\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u9806\u3067TSV\u30c6\u30ad\u30b9\u30c8\u3092\u884c\u30bd\u30fc\u30c8\u3057\u307e\u3059\u3002\u5404\u884c\u306e\u30ab\u30e9\u30e0\u5024\u304c\u300cJan\u300d\u300cFeb\u300d\u300cMarch\u300d\u3060\u3063\u305f\u5834\u5408\u306f\u3001\u300cFeb\u3092\u542b\u3080\u884c\u300d\u300cJan\u3092\u542b\u3080\u884c\u300d\u300cMarch\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, \u30c6\u30ad\u30b9\u30c8\u30bd\u30fc\u30c8","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-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-Text-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-Text-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-Text-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-Text-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82388,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/","url_meta":{"origin":109455,"position":2},"title":"TSV String, Sort by Numeric","author":"IMAMURA, Genichi","date":"2019-12-03","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 of \"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":109626,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-sort-by-text-2021\/","url_meta":{"origin":109455,"position":3},"title":"TSV\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30bd\u30fc\u30c8","author":"Hirotaka NISHI","date":"2021-07-14","format":false,"excerpt":"\u6307\u5b9a\u30ab\u30e9\u30e0\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u9806\u3067TSV\u30c6\u30ad\u30b9\u30c8\u3092\u884c\u30bd\u30fc\u30c8\u3057\u307e\u3059\u3002\u5404\u884c\u306e\u30ab\u30e9\u30e0\u5024\u304c\u300cJan\u300d\u300cFeb\u300d\u300cMarch\u300d\u3060\u3063\u305f\u5834\u5408\u306f\u3001\u300cFeb\u3092\u542b\u3080\u884c\u300d\u300cJan\u3092\u542b\u3080\u884c\u300d\u300cMarch\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, \u30c6\u30ad\u30b9\u30c8\u30bd\u30fc\u30c8","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-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-Text-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-Text-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-Text-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-Text-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":109450,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric-2021\/","url_meta":{"origin":109455,"position":4},"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":78118,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/","url_meta":{"origin":109455,"position":5},"title":"TSV String; Re-order Columns","author":"IMAMURA, Genichi","date":"2021-02-01","format":false,"excerpt":"Extracts a new TSV string re-arranged by a column ID list from TSV string. ID repetition in the list is also possible. It can be used to narrow down necessary information or conform to the format. Removes whitespace from both ends of a string.","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\/2019\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-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\/109455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=109455"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/109455\/revisions"}],"predecessor-version":[{"id":149871,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/109455\/revisions\/149871"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/82376"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=109455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=109455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=109455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}