{"id":109865,"date":"2021-07-20T11:52:26","date_gmt":"2021-07-20T02:52:26","guid":{"rendered":"https:\/\/support.questetra.com\/?p=109865"},"modified":"2023-08-22T11:39:10","modified_gmt":"2023-08-22T02:39:10","slug":"tsv-string-add-static-value-to-all-lines-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-static-value-to-all-lines-2021\/","title":{"rendered":"TSV String; Add Static Value to All Lines"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><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; Add Static Value to All Lines<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Adds the new string cell to the end of all rows. If there are space characters or line feed characters at the beginning and end of the TSV, they will be deleted beforehand. If the number of tab separators does not match, an error will occur.<\/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> A: Select STRING DATA for Source TSV<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B: Set STRING for New Cell (e.g. &#8220;Tax Rate 10%&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> C: Select STRING DATA for Generated 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\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 cellStr = configs.get( &quot;conf_CellStr&quot; ) + &quot;&quot;;\nconst dataIdC = configs.get( &quot;conf_DataIdC&quot; ) + &quot;&quot;; \/\/ config required\nif( cellStr === &quot;&quot; ){\n  engine.log( &quot; AutomatedTask StringWarning:&quot; +\n              &quot; CellStr is empty&quot; );\n}\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nif( engine.findDataByNumber( dataIdA ) === null ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                   &quot; String {A} is null \\n&quot; );\n}\nconst inputTsv = (engine.findDataByNumber( dataIdA ) + &quot;&quot;).trim();\nif( inputTsv == &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; +\n                   &quot; String {A} is empty \\n&quot; );\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet   outputTsv = &quot;&quot;;\nconst arrInputTsv = inputTsv.split(&quot;\\n&quot;);\nengine.log( &quot; AutomatedTask MultilineString:&quot; + \n            &quot; String {A} as TSV, number of lines &quot; + arrInputTsv.length );\nconst arrHeaderCells = arrInputTsv[0].split(&quot;\\t&quot;);\nengine.log( &quot; AutomatedTask SinglelineString:&quot; + \n            &quot; TSV Header, number of cells &quot; + arrHeaderCells.length );\n\nfor (let i=0; i &lt; arrInputTsv.length; i++){\n  const arrCells = arrInputTsv[i].split(&quot;\\t&quot;);\n  if( arrCells.length !== arrHeaderCells.length ){\n    throw new Error( &quot;\\n AutomatedTask UnexpectedStringError:&quot; + \n      &quot; String {A} as TSV, number of delimiters in each row must be same: Row &quot; + i + &quot;\\n&quot;);\n  }\n  outputTsv += arrInputTsv[i] + &quot;\\t&quot; + cellStr;\n  if( i !== arrInputTsv.length - 1 ){\n    outputTsv += &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, outputTsv );\n\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,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADV0lEQVRYR8WXTUgUYRjHf5O2aSBu\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\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\/1aMhH-YBwpLrJ1FB8wU63DlDFysTvRQpa\/view?usp=drivesdk\" target=\"_blank\">Tsv-String-Add-Static-Value-to-All-Lines-2021.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-07-13 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1v1cMT7b_yZVMOEmuAT58jikvBe6kQgul\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Tsv-String-Add-Static-Value-to-All-Lines-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When deleting only newline characters at both ends of a string.\n<ul class=\"wp-block-list\">\n<li> \/\/const inputTsv = (engine.findDataByNumber( dataIdA ) + &#8220;&#8221;).trim();<\/li>\n\n\n\n<li> const inputTsv = (engine.findDataByNumber( dataIdA ) + &#8220;&#8221;).replace(\/^[\\n]*\/, &#8220;&#8221;).replace(\/[\\n]*$\/, &#8220;&#8221;);<\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" aria-label=\"Tsv-String-Add-Static-Value-to-All-Lines-202107.xml (opens in a new tab)\" href=\"https:\/\/drive.google.com\/file\/d\/16KoJfsP3EOeI8v5OoEwvACTFh9s0Jfv_\/view?usp=sharing\" target=\"_blank\">Tsv-String-Add-Static-Value-to-All-Lines-202107.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-07-13 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/14QMMcdoNm6YLvokrbW69K1fAMq5FNptI\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Tsv-String-Add-Static-Value-to-All-Lines-202308.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/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-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-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\/2021\/07\/TSV-String-Add-Static-Value-to-All-Lines-2021-en.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"540\" data-attachment-id=\"90951\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-static-value-to-all-lines\/attachment\/tsv-string-add-static-value-diagram\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/tsv-string-add-static-value-diagram.png?fit=960%2C540&amp;ssl=1\" data-orig-size=\"960,540\" data-comments-opened=\"0\" data-image-title=\"tsv-string-add-static-value-diagram\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/tsv-string-add-static-value-diagram.png?fit=960%2C540&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/tsv-string-add-static-value-diagram.png?resize=960%2C540&#038;ssl=1\" alt=\"\" class=\"wp-image-90951\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/tsv-string-add-static-value-diagram.png?w=960&amp;ssl=1 960w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/tsv-string-add-static-value-diagram.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/tsv-string-add-static-value-diagram.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Adds the new string cell to the end of all rows. If there are space characters or line feed characters at the beginning and end of the TSV, they will be deleted beforehand. If the number of tab separators does not match, an error will occur<\/p>\n","protected":false},"author":3,"featured_media":78004,"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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_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":[169],"tags":[451],"faq_section":[],"class_list":["post-109865","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-tsv-csv"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/TSV-String-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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":1,"uagb_excerpt":"Adds the new string cell to the end of all rows. If there are space characters or line feed characters at the beginning and end of the TSV, they will be deleted beforehand. If the number of tab separators does not match, an error will occur","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-sA1","jetpack-related-posts":[{"id":77998,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-static-value-to-all-lines\/","url_meta":{"origin":109865,"position":0},"title":"TSV String; Add Static Value to All Lines","author":"IMAMURA, Genichi","date":"2019-07-26","format":false,"excerpt":"Adds the new string cell to the end of all rows. If there are space characters or line feed characters at the beginning and end of the TSV, they will be deleted beforehand. If the number of tab separators does not match, an error will occur.","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-Add-Static-Value-to-All-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\/2019\/07\/TSV-String-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-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-Add-Static-Value-to-All-Lines-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78242,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-prefix-to-column\/","url_meta":{"origin":109865,"position":1},"title":"TSV String; Add Prefix to Column","author":"IMAMURA, Genichi","date":"2019-08-02","format":false,"excerpt":"Generates a new TSV with concatenating the prefix Str to all cells in the column. The concatenated strings are added at the end of the line. Available at categorization etc. 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\/08\/Tsv-String-Add-Prefix-to-Column-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\/08\/Tsv-String-Add-Prefix-to-Column-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/Tsv-String-Add-Prefix-to-Column-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/Tsv-String-Add-Prefix-to-Column-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/Tsv-String-Add-Prefix-to-Column-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78049,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-delete-header-lines\/","url_meta":{"origin":109865,"position":2},"title":"Multiline String; Delete Header Lines","author":"IMAMURA, Genichi","date":"2019-07-29","format":false,"excerpt":"Deletes the header lines of a multiline string, like CSV text or TSV text. Note that blank characters at the end or beginning of string data are deleted in advance. If singleline text, an empty string will be returned.","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\/Multiline-String-Delete-Head-Lines.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\/Multiline-String-Delete-Head-Lines.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Multiline-String-Delete-Head-Lines.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Multiline-String-Delete-Head-Lines.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Multiline-String-Delete-Head-Lines.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84857,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table\/","url_meta":{"origin":109865,"position":3},"title":"Converter: TSV-String to Table","author":"IMAMURA, Genichi","date":"2020-02-28","format":false,"excerpt":"Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: TSV-String to Table","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-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\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.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":109865,"position":4},"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":83960,"url":"https:\/\/support.questetra.com\/en\/addons\/two-tsv-strings-extract-cell-mismatched-lines\/","url_meta":{"origin":109865,"position":5},"title":"Two Tsv Strings, Extract Cell-Mismatched Lines","author":"IMAMURA, Genichi","date":"2020-01-29","format":false,"excerpt":"Extracts B lines that DO NOT 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, an empty string is returned. If they are completely different, all lines in B are 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-Mismatched Lines","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-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-Mismatched-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-Mismatched-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-Mismatched-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-Mismatched-Lines-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/TSV-String-Add-Static-Value-to-All-Lines-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/109865","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=109865"}],"version-history":[{"count":13,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/109865\/revisions"}],"predecessor-version":[{"id":149890,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/109865\/revisions\/149890"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/78004"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=109865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=109865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=109865"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=109865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}