{"id":82375,"date":"2019-12-03T11:49:41","date_gmt":"2019-12-03T02:49:41","guid":{"rendered":"https:\/\/support.questetra.com\/?p=82375"},"modified":"2021-07-14T13:58:32","modified_gmt":"2021-07-14T04:58:32","slug":"tsv-string-sort-by-text","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text\/","title":{"rendered":"TSV String, Sort by Text"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5e54c;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFFF66;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text-2021\/\">https:\/\/support.questetra.com\/addons\/tsv-string-sort-by-text-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">TSV String, 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\">\n\n\n\n<p class=\"wp-block-paragraph\">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\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2019-12-02 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text\/\">https:\/\/support.questetra.com\/addons\/tsv-string-sort-by-text\/<\/a><\/p>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> A: Select STRING DATA for TSV String<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> B-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\/\/ If specifying multiple sort keys, use {Column ID} in CSV notation. (eg \"3,1,0\")\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 \"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( arrTsvlineA&#091; parseInt(arrTargetColIds&#091;i]) ] &lt;\n          arrTsvlineB&#091; parseInt(arrTargetColIds&#091;i]) ] ){ return 1; }\n      if( arrTsvlineA&#091; parseInt(arrTargetColIds&#091;i]) ] &gt;\n          arrTsvlineB&#091; parseInt(arrTargetColIds&#091;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&#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( arrTsvlineA&#091; parseInt(arrTargetColIds&#091;i]) ] &gt;\n          arrTsvlineB&#091; parseInt(arrTargetColIds&#091;i]) ] ){ return 1; }\n      if( arrTsvlineA&#091; parseInt(arrTargetColIds&#091;i]) ] &lt;\n          arrTsvlineB&#091; parseInt(arrTargetColIds&#091;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(\"\\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\/1G013wy8nLk56ZSSyrATbf3IYU89VxbkR\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Sort-by-Text.xml (opens in a new tab)\">Tsv-String-Sort-by-Text.xml<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/tsv-string-sort-by-text.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/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-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>If specifying 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=\"tQTHJsI3KB\"><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; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;TSV String; Re-order Columns&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-reorder-columns\/embed\/#?secret=hqubasRayc#?secret=tQTHJsI3KB\" data-secret=\"tQTHJsI3KB\" 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":2,"featured_media":82376,"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":[169],"tags":[365,389],"class_list":["post-82375","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":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":1,"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-lqD","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":109455,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text-2021\/","url_meta":{"origin":82375,"position":0},"title":"TSV String, Sort by Text","author":"Hirotaka NISHI","date":"2021-07-14","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":82375,"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":109626,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-sort-by-text-2021\/","url_meta":{"origin":82375,"position":2},"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":82388,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/","url_meta":{"origin":82375,"position":3},"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":109450,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric-2021\/","url_meta":{"origin":82375,"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":70901,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-changeorder\/","url_meta":{"origin":82375,"position":5},"title":"Change Order of Tsv","author":"Hirotaka NISHI","date":"2018-11-15","format":false,"excerpt":"Sorting the columns of the TSV in the order as indicated","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.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\/82375","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=82375"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82375\/revisions"}],"predecessor-version":[{"id":109643,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82375\/revisions\/109643"}],"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=82375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=82375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=82375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}