{"id":111957,"date":"2021-08-30T14:23:22","date_gmt":"2021-08-30T05:23:22","guid":{"rendered":"https:\/\/support.questetra.com\/?p=111957"},"modified":"2023-08-22T18:22:43","modified_gmt":"2023-08-22T09:22:43","slug":"multiline-string-delete-empty-lines-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-delete-empty-lines-2021\/","title":{"rendered":"Multiline String, Delete Empty Lines"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Multiline String, Delete Empty Lines<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> A1: Set Original Text<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-caret-square-down fa-lg\"><\/i><\/span> B1: Select STRING DATA that stores Output Text (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\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strInput         = configs.get( &quot;StrConfA1&quot; );          \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\/\n  if( strInput       === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A1: Text} is empty \\n&quot; );\n  }\nconst strPocketOutput  = configs.getObject( &quot;SelectConfB1&quot; ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nconst arrInput = strInput.split(&quot;\\n&quot;);\nengine.log( &quot; AutomatedTask: Number of Lines: &quot; + arrInput.length );\n\nlet strOutput  = &quot;&quot;;\nfor( let i = 0; i &lt; arrInput.length; i++ ){\n  if( arrInput[i] === &quot;&quot; ){\n    engine.log( &quot; AutomatedTask Deleted LineId: &quot; + i );\n    continue;\n  } \/\/ Skip blank lines\n  strOutput  += arrInput[i] + &quot;\\n&quot;;\n}\n\nstrOutput = strOutput.slice( 0, -1 ); \/\/ delete last &quot;\\n&quot;\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( strPocketOutput, strOutput );\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\/*\nNotes:\n- When the process reaches this automated task, the Text in the string data is automatically processed.\n    - TSV data, Access log, Email body, etc.\n    - {Number of lines} = {Number of line breaks} + 1\n- All blank lines in the text are automatically removed.\n    - Not only the blank line in the middle of the multiline string,\n    - but also the blank line at the end and the blank line at the beginning are deleted.\n\nAPPENDIX:\n- The deleted row ID (starting with zero) is logged.\n\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308bText\u304c\u81ea\u52d5\u7684\u306b\u52a0\u5de5\u3055\u308c\u307e\u3059\u3002\n    - TSV\u30c7\u30fc\u30bf\u3001\u30a2\u30af\u30bb\u30b9\u30ed\u30b0\u3001\u30e1\u30fc\u30eb\u672c\u6587\u306a\u3069\n    - {\u884c\u306e\u6570} = {\u6539\u884c\u306e\u6570} + 1\n- \u30c6\u30ad\u30b9\u30c8\u5185\u306e\u5168\u3066\u306e\u7a7a\u884c\u304c\u81ea\u52d5\u7684\u306b\u53d6\u308a\u9664\u304b\u308c\u307e\u3059\u3002\n    - \u8907\u6570\u884c\u6587\u5b57\u5217\u306b\u3042\u308b\u9014\u4e2d\u7a7a\u884c\u306e\u307f\u306a\u3089\u305a\u3001\u672b\u5c3e\u7a7a\u884c\u3084\u5148\u982d\u7a7a\u884c\u3082\u524a\u9664\u3055\u308c\u307e\u3059\u3002\n\nAPPENDIX-ja:\n- \u524a\u9664\u3055\u308c\u305f\u884c\u306eID\uff08\u30bc\u30ed\u59cb\u307e\u308a\uff09\u306f\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\n*\/\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,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADkElEQVRYR8WXW0gUURjHf+MtK7to\nERF2AUUrNsmCEnzYLkJJlhBBJfWwFe66CFkbaA\/1nCAlIblG5kNh+xR0kS7kluCSFSRsmRU+ZFlk\nt7VytfIyMbNNu267O2ej2PM2M+f7n\/\/5zv\/7\/mckYjwk4fUbmILMViTWIpOLxCIg9Ve8B5kXSHQi\ncxuJi5gZEsHWJ9DEXH5QCViAZBFQ4BtgJ4lqTLyNFBOZgB0LEjXAVMGFg6d5kTmEBXu4+PAEGjgF\nlP3lwsFh9ZixhsIKTcBOMxI7\/9HiPhiZC1goCcb8k8C\/3bluJiYS8J15vcjONy3YRHJ8Mjf7bvJ1\n5KtIiJaJskBN+An41N4jIriSzBLq8utIjEuk8l4lp54ochEeXpLI1KrDT6CBE0CFCEyjsRFTtgkJ\nidbXrRS0FIiEBc6pxcwB5YWPgNJk4KNInWfNyOLyhstkz8xWQz3fPZS7ymnuaY6GhNInZinNykfA\nzi4kzokgHF5+mKMrj6rn7xO3jKPHQYnzD4FHhpPZjYXzWgYagT0iBK5uvMq6eesYk8dISUxRQ3oH\ne9lxawcd7zpEILQ5ZzGzV8vAQyRy9aIL5xfStKaJ55+fM\/B9gKKFRaoORsZHOO4+TtX9Kj0I\/3eZ\nTiys0DLwKcBYwoIoyt+3eB+1j2pxf3KrlZA6yedHnR86MV4xRlOSHsykaQRkPerTEqfRtrmNtOQ0\nNd1dni71OXe2L3GDI4PRl6QZSZiAdamV6tXVON84Kb5RrC5ak1fDfsN+EuIS1OeWly0UXS\/S24v\/\newAB3SNwrHewPWN7RPD+4X5Md0xce3VNhETAEdiJKMK8OXk4ChyMjY\/h6ndNADekGn4fw7g8zunu\n05S1C5hokAgjluGxVceoWFbBmadn1KYTOLSj0Ury2cAzttzYolaKzphQhhEbkavYRcb0jJDp1cSp\nidE76qXqXhV1XXVRNaKwrVgznu6BbvIv5YcEVTJ0MOegak6CYgxqxUpUCDNSOt6RFUcwzjPS\/rYd\n210bD94\/mEAifWo6pUtKseXYmJKg7AO1F5x8fBL7Ezt93r5QpIPMSJkSZMfubW4MaQaGRodQxBUn\nxakLOF87f7ufQk7xhqT4JIZHh1VfUEa8FM\/khMl8+fEFa7s12KjC2LESGcWFRE9hYb\/LhLmQaBEx\nvZJpJGJ6Kf0\/mYjyWu7PRAx\/TDQSMf01C5RyzH5O\/7rexAJ\/Av2AWTB+TSFiAAAAAElFTkSuQmCC\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\/1tCnJj8dEnfQRKVfG_q1CM_J4nWf4z7nd\/view?usp=drivesdk\" target=\"_blank\">Multiline-String-Delete-Empty-Lines-2021.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-08-27 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1BOUbX-JFfaK2I7N_h2nq5tK4ebaxmjpF\/view?usp=drive_link\" target=\"_blank\" rel=\"noreferrer noopener\">Multiline-String-Delete-Empty-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=\"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.<br>Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When the process reaches this automated task, the Text in the string data is automatically processed.\n<ul class=\"wp-block-list\">\n<li>TSV data, Access log, Email body, etc.<\/li>\n\n\n\n<li>{Number of lines} = {Number of line breaks} + 1<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>All blank lines in the text are automatically removed.\n<ul class=\"wp-block-list\">\n<li>As well as blank lines in the middle of a multiline string, blank lines at the beginning and the end are also deleted.<\/li>\n<\/ul>\n<\/li>\n<\/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-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"111945\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/multiline-string-delete-empty-lines-2021-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-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=\"multiline-string-delete-empty-lines-2021-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted.\" class=\"wp-image-111945\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default q-box\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-config-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1199\" height=\"608\" data-attachment-id=\"111949\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/multiline-string-delete-empty-lines-2021-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-config-en.png?fit=1199%2C608&amp;ssl=1\" data-orig-size=\"1199,608\" 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=\"multiline-string-delete-empty-lines-2021-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-config-en.png?fit=1024%2C519&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-config-en.png?resize=1199%2C608&#038;ssl=1\" alt=\"Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted.\" class=\"wp-image-111949\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-config-en.png?w=1199&amp;ssl=1 1199w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-config-en.png?resize=600%2C304&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-config-en.png?resize=1024%2C519&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-config-en.png?resize=768%2C389&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-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The deleted row ID (starting with zero) is logged.<\/li>\n<\/ul>\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=\"Q6qtk53wrl\"><a href=\"http:\/\/support.questetra.com\/en\/addons\/tsv-string-create-cross-tab-for-numerical-sum-2021\/\">TSV String, Create Cross Tab for Numerical Sum<\/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, Create Cross Tab for Numerical Sum&#8221; &#8212; Questetra Support\" src=\"http:\/\/support.questetra.com\/addons\/tsv-string-create-cross-tab-for-numerical-sum-2021\/embed\/#?secret=ZrHG3MTsFJ#?secret=Q6qtk53wrl\" data-secret=\"Q6qtk53wrl\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted.<\/p>\n","protected":false},"author":2,"featured_media":111953,"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":"Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[365,389,2535],"class_list":["post-111957","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-easy-config-addon","tag-tsv-csv","tag-workflow-automation"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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":3,"uagb_excerpt":"Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-t7L","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":78049,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-delete-header-lines\/","url_meta":{"origin":111957,"position":0},"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":96520,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-dequeue-first\/","url_meta":{"origin":111957,"position":1},"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":[]},{"id":109652,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-delete-header-lines-2021\/","url_meta":{"origin":111957,"position":2},"title":"Multiline String; Delete Header Lines","author":"Hirotaka NISHI","date":"2021-07-14","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":117198,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-multiline-string-to-singleline-csv-string-2021\/","url_meta":{"origin":111957,"position":3},"title":"Converter: Multiline-String to Singleline-CSV-String","author":"IMAMURA, Genichi","date":"2021-11-22","format":false,"excerpt":"Converts a multiline string to a CSV string. Converts each row of a multiline string as the value of each cell in the CSV. If commas are included they will be deleted in advance. Lines with only line feed code are recognized as empty data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter, Multiline-String to Singleline-CSV-String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":111968,"url":"https:\/\/support.questetra.com\/ja\/addons\/multiline-string-delete-empty-lines-2021\/","url_meta":{"origin":111957,"position":4},"title":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u7a7a\u884c\u306e\u524a\u9664","author":"IMAMURA, Genichi","date":"2021-08-30","format":false,"excerpt":"\u5168\u3066\u306e\u7a7a\u767d\u884c\u3092\u53d6\u308a\u9664\u304d\u307e\u3059\u3002\u30c6\u30ad\u30b9\u30c8\uff08TSV\u3084CSV\u3092\u542b\u3080\uff09\u306e\u672b\u5c3e\u306b\u3042\u308b\u6539\u884c\u3082\u524a\u9664\u3055\u308c\u307e\u3059\u3002\u3082\u3057\u305d\u306e\u884c\u306b\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u304c\u4e00\u6587\u5b57\u3067\u3082\u3042\u308c\u3070\u3001\u524a\u9664\u3055\u308c\u307e\u305b\u3093\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":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u7a7a\u884c\u306e\u524a\u9664","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-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\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-delete-empty-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":109653,"url":"https:\/\/support.questetra.com\/en\/addons\/multiline-string-delete-footer-lines-2021\/","url_meta":{"origin":111957,"position":5},"title":"Multiline String; Delete Footer Lines","author":"Hirotaka NISHI","date":"2021-07-20","format":false,"excerpt":"Deletes the Footer lines of a multiline string, like legacy Banking Formats or legacy EDI Data. 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-Footer-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\/Multiline-String-Delete-Footer-Lines-en.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-Footer-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\/Multiline-String-Delete-Footer-Lines-en.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-Footer-Lines-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\/111957","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=111957"}],"version-history":[{"count":8,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111957\/revisions"}],"predecessor-version":[{"id":149980,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111957\/revisions\/149980"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/111953"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=111957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=111957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=111957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}