{"id":78118,"date":"2021-02-01T13:30:00","date_gmt":"2021-02-01T04:30:00","guid":{"rendered":"https:\/\/support.questetra.com\/?p=78118"},"modified":"2021-08-24T13:37:56","modified_gmt":"2021-08-24T04:37:56","slug":"tsv-string-reorder-columns","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/","title":{"rendered":"TSV String; Re-order Columns"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF4CC;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-convert-2021\/\">https:\/\/support.questetra.com\/en\/addons\/tsv-string-convert-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Tsv String; Re-order Columns<\/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\">Extracts a new TSV string from an existing TSV string sorted by the column ID list. Duplicate IDs in the list are also possible. This can be used to filter necessary information or conform to a format. Removes whitespace from both ends of a string.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">(C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/\">https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/<\/a><\/p>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul\">\n<li> A: Select STRING DATA for TSV Text<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B: Set Column ID List to Extract (e.g. &#8220;0,1,3,0&#8221;)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> C: Select STRING DATA for New TSV Text Re-ordered (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\/\/ (c) 2019, Questetra, Inc. (the MIT License)\n\n\/*\ninput tsv\nA1\tB1\tC1\tD1\tE1\nA2\tB2\tC2\tD2\tE2\ncolumn id list\n0,1,3,0\noutput tsv\nA1\tB1\tD1\tA1\nA2\tB2\tD2\tA2\n*\/\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\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 columns = configs.get( &quot;conf_Columns&quot; ) + &quot;&quot;; \/\/ config required\nconst dataIdC = configs.get( &quot;conf_DataIdC&quot; ) + &quot;&quot;; \/\/ config required\n\/\/ &#39;java.lang.String&#39; to javascript primitive &#39;string&#39; by &quot;&quot;\n\n\/\/ Design-time Config Format Check\nengine.log( &quot; AutomatedTask Config: Column ID List &quot; + columns );\nif ( columns.match(\/^[0-9][0-9,]*$\/) === null ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedConfigError:&quot; +\n  &quot; Config {Column ID List} allows only numbers and commas. \\n&quot; );\n}\nconst arrColumns  = columns.split(&quot;,&quot;);\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ Run-time Data Format Check\nif( engine.findDataByNumber( dataIdA ) === null ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                   &quot; String {A} as TSV is null \\n&quot; );\n}\nconst inputText = (engine.findDataByNumber( dataIdA ) + &quot;&quot;).trim();\nif( inputText === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                   &quot; String {A} as TSV is empty \\n&quot; );\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet   outputText = &quot;&quot;;\nconst arrInputText = inputText.split(&quot;\\n&quot;);\nengine.log( &quot; AutomatedTask MultilineString:&quot; + \n            &quot; String {A} as TSV, number of lines &quot; + arrInputText.length );\n\nfor( let i = 0; i &lt; arrInputText.length; i++ ){\n  let arrCellValues = arrInputText[i].split(&quot;\\t&quot;);\n  for( let j = 0; j &lt; arrColumns.length; j++ ){\n    if ( arrColumns[j] === &quot;&quot; ){\n      throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {Column ID List} must be CSV format \\n&quot; );\n    }\n    outputText += arrCellValues[ (arrColumns[j] - 0) ];\n    if( j !== arrColumns.length - 1 ){\n      outputText += &quot;\\t&quot;;\n    }\n  }\n  if( i !== arrInputText.length - 1 ){\n    outputText += &quot;\\n&quot;;\n  }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setDataByNumber( dataIdC, outputText );\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADV0lEQVRYR8WXTUgUYRjHf5O2aSBu\nEiFWVBQRWPlBQfTBih8HO5UnQSjFw3gQK0FBUDNBQg9mltiC1HbQk2BaHQrygzqV4opdooMFKmER\nKyIr1jbxzjg6+zHujJq9sOzCPvP8\/8\/z\/p+PkfjPR7KF7+YK4EIhHQknkL7yvBcFHxLie5gy+q36\njU7gCU6WuQHcBBXUyvEBbTi4Twnit+lZn0Anxezgng3gUCABXoLMMzMG5gQe0YakRr4Vpw2ZW5Ec\nRSbgxgNc3wrkVR8KHsooCfUZTsBm5Ak7E2g\/387bb295\/Onx+pwV7lOmamn1BBPQ7vyJ1cgFeG9e\nL3kH8phZnKH8XTn9X6MWwFWjJtYIaGqfsio4I7iE5mbOP4c\/4GdoZoiSkbBs63H5cHBEr441Am4a\ngNtWoxd2Dy88pPREKXExcUGPBZQA3Z+7uT5sKqM7yCreCnXxy63Wa6IdAsLWk+Wh6FgRsTtigx71\n\/\/ZT+6GW1snWSC59yOxZI6B1uD674MI+\/2A+Xa4uUnanGASv8GbmDQWvC1j4tWDmVtWCdgU2lW\/0\nWJ1WTU1GDU5HcJMc\/T5K9otscwIrFaERcDOs9nibp+lsEzn7cxj4OkBVWlUQieU\/yzR7m6kfrTfz\nOoJMlk7gC3DIDr4ArzxdqQpw8uckfVN9pCalcjzxOKeSTqmuxn+M43ruMsuCF5kMnYCyUXC9\/Gre\n16iNqPBoIR0XO0jalcRSYInGsUbueu9Gdi8j2SZgjDwUXEcx2ggx5r7MjUrA0hVYAdeRXl1+pXbI\n2cVZrg1dY3B2MJiEwgRlpFsWoR1wgXRu3zl6cnpIjk+mYayBlomW0CwYRBilDO2C60iNZxqpOFnB\ng48PqButC82AOpj0DJg2oo2CCzQxLxIdiUwvTkfSgKERab0grBVvBjxKVc0ja+ud6TD6h+ACN8Iw\n0saxqAZ1II0VjJG5N1MNRIxZvc7t9AsT23kcHA4fx8LasJCIIdN5qZP4mPitBBcoJguJTncTg8lC\ndlZTr9tu31IKT5EpDiW5XWt5WOTrZ0D\/V1tUxIpue1NacTEPFG\/sxUQnoVWHWKXFxyoRASxezdo2\n92oWemEiIwpZSKSj4EQiTTURg0XCh4IXieH1IrauAQuS3gqTvxXhUDBgMFNwAAAAAElFTkSuQmCC\" 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 rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Reorder-Columns-201907.xml (opens in a new tab)\" href=\"https:\/\/drive.google.com\/file\/d\/1UFy6IvPYQ7r2M1j3jF9QxxPTfs_GvROC\/view?usp=sharing\" target=\"_blank\">Tsv-String-Reorder-Columns-201907.xml<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Reorder-Columns-201909.xml (opens in a new tab)\" href=\"https:\/\/drive.google.com\/a\/questetra.com\/file\/d\/1Yx5M4gE8NdO1TYLa0jjRd-RsdYlm1G4N\/view?usp=sharing\" target=\"_blank\">Tsv-String-Reorder-Columns-201909.xml<\/a> (Deletes only newline characters at both ends of a string.)<ul><li>\/\/const inputText = (engine.findDataByNumber( dataIdA ) + &#8220;&#8221;).trim();<\/li><li>const inputText = (engine.findDataByNumber( dataIdA ) + &#8220;&#8221;).replace(\/^[\\n]*\/, &#8220;&#8221;).replace(\/[\\n]*$\/, &#8220;&#8221;);<\/li><\/ul><\/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\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-Tsv-String-Reorder-Columns-en.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"540\" data-attachment-id=\"90567\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/attachment\/capture-new-tsv-string-reorder-columns-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-Tsv-String-Reorder-Columns-en.png?fit=960%2C540&amp;ssl=1\" data-orig-size=\"960,540\" 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=\"capture-new-Tsv-String-Reorder-Columns-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-Tsv-String-Reorder-Columns-en.png?fit=960%2C540&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-Tsv-String-Reorder-Columns-en.png?resize=960%2C540&#038;ssl=1\" alt=\"\" class=\"wp-image-90567\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-Tsv-String-Reorder-Columns-en.png?w=960&amp;ssl=1 960w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-Tsv-String-Reorder-Columns-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/capture-new-Tsv-String-Reorder-Columns-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/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=\"AGtAuXJHml\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-static-value-to-all-lines\/\">TSV String; Add Static Value to All Lines<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cTSV String; Add Static Value to All Lines\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-static-value-to-all-lines\/embed\/#?secret=CFWmpYcqft#?secret=AGtAuXJHml\" data-secret=\"AGtAuXJHml\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>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.<\/p>\n","protected":false},"author":2,"featured_media":78119,"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":"{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":[389],"class_list":["post-78118","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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\/07\/Tsv-String-Reorder-Columns-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":10,"uagb_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.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-kjY","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":78118,"position":0},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.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\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76239,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/synchronize-users-chapter2\/","url_meta":{"origin":78118,"position":1},"title":"Synchronizing User Information with Local Data (User Information Chapter)","author":"Hirotaka NISHI","date":"2021-01-18","format":false,"excerpt":"Synchronize user information on Questetra BPM Suite with local data. The User information chapter introduces a Java program that synchronizes registration information required to login to Questetra BPM Suite.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.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\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":83944,"url":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-matched-lines\/","url_meta":{"origin":78118,"position":2},"title":"Two Tsv Strings, Extract Cell-Matched Lines","author":"IMAMURA, Genichi","date":"2020-01-29","format":false,"excerpt":"Extracts B lines that DO exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Two Tsv Strings, Extract Cell-Matched Lines","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-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\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Matched-Lines-en.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":78118,"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;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":76781,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/synchronize-users-chapter3\/","url_meta":{"origin":78118,"position":4},"title":"Synchronizing User Information in QBPMS with Local Data (Organizational Affiliation Chapter)","author":"Hirotaka NISHI","date":"2021-01-18","format":false,"excerpt":"Synchronize user information on Questetra BPM Suite with local data. In the Organizational Affiliation Chapter, we introduce you a Java program that synchronizes affiliation information such as \"which organization the user is affiliated to\".","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.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\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/sync-with-local-data-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96520,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-dequeue-first\/","url_meta":{"origin":78118,"position":5},"title":"Multiline String, Dequeue First","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Removes the first line from the multiline string. One line less than the original string. By placing in a loop flow or in a recursive workflow, data list can be processed sequentially.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Multiline String, Dequeue First","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Multiline-String-Dequeue-First-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\/10\/Multiline-String-Dequeue-First-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Multiline-String-Dequeue-First-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Multiline-String-Dequeue-First-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Multiline-String-Dequeue-First-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\/78118","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=78118"}],"version-history":[{"count":14,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/78118\/revisions"}],"predecessor-version":[{"id":111759,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/78118\/revisions\/111759"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/78119"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=78118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=78118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=78118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}