From unknown Sun Jun 15 08:58:45 2025 X-Loop: help-debbugs@gnu.org Subject: bug#37242: orgtbl-to-tsv drops empty cell Resent-From: Tak Kunihiro Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Sat, 31 Aug 2019 07:32:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 37242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: 37242@debbugs.gnu.org Cc: tkk@misasa.okayama-u.ac.jp X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.156723669417377 (code B ref -1); Sat, 31 Aug 2019 07:32:02 +0000 Received: (at submit) by debbugs.gnu.org; 31 Aug 2019 07:31:34 +0000 Received: from localhost ([127.0.0.1]:54984 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1i3xrB-0004WC-MA for submit@debbugs.gnu.org; Sat, 31 Aug 2019 03:31:33 -0400 Received: from lists.gnu.org ([209.51.188.17]:43734) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1i3xr9-0004W4-Qe for submit@debbugs.gnu.org; Sat, 31 Aug 2019 03:31:32 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:34616) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1i3xr7-0007Tp-UB for bug-gnu-emacs@gnu.org; Sat, 31 Aug 2019 03:31:31 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50,RCVD_IN_DNSWL_NONE autolearn=disabled version=3.3.2 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1i3xr6-0005M1-R0 for bug-gnu-emacs@gnu.org; Sat, 31 Aug 2019 03:31:29 -0400 Received: from mlsec.cc.okayama-u.ac.jp ([42.127.236.175]:38206) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1i3xr6-00059Q-CF for bug-gnu-emacs@gnu.org; Sat, 31 Aug 2019 03:31:28 -0400 Received: from alml002.ouadm.okayama-u.ac.jp (unknown [42.127.236.168]) by mlsec.cc.okayama-u.ac.jp with smtp id 70e4_0719_101e454c_a0cc_4a0f_9f0b_8f52b7bfe534; Sat, 31 Aug 2019 16:31:13 +0900 Received: from localhost (p1286214-omed01.tokyo.ocn.ne.jp [153.236.37.213]) by alml002.ouadm.okayama-u.ac.jp (Postfix) with ESMTPSA id 62A914C0A85; Sat, 31 Aug 2019 16:31:07 +0900 (JST) Date: Sat, 31 Aug 2019 16:31:02 +0900 (JST) Message-Id: <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> From: Tak Kunihiro X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-NAI-Spam-Flag: NO X-NAI-Spam-Level: X-NAI-Spam-Threshold: 11 X-NAI-Spam-Score: 0.7 X-NAI-Spam-Rules: 6 Rules triggered TS_MSG_REP_20=0.6, GEN_SPAM_FEATRE=0.1, EDT_SA_AU_PASS=0, EDT_SA_DN_PASS=0, EDT_SA_TS_PASS=0, RV6624=0 X-NAI-Spam-Version: 2.3.0.9418 : core <6624> : inlines <7139> : streams <1831418> : uri <2893150> X-detected-operating-system: by eggs.gnu.org: Genre and OS details not recognized. X-Received-From: 42.127.236.175 X-Spam-Score: -1.6 (-) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.6 (--) When org-mode table is converted to tab delimitated text using orgtbl-to-tsv, empty cell is dropped out. I think this is bug. GNU Emacs 26.3 (build 1, x86_64-w64-mingw32) of 2019-08-29 runemacs -Q (require 'org-table) (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) nil) ; => "aaa\nbbb\nddd" (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) '(:backend ascii)) ; => " aaa \n bbb \n \n ddd " From unknown Sun Jun 15 08:58:45 2025 X-Loop: help-debbugs@gnu.org Subject: bug#37242: orgtbl-to-tsv drops empty cell Resent-From: Bastien Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Mon, 17 Feb 2020 07:33:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 37242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Tak Kunihiro Cc: 37242@debbugs.gnu.org Received: via spool by 37242-submit@debbugs.gnu.org id=B37242.158192473932140 (code B ref 37242); Mon, 17 Feb 2020 07:33:02 +0000 Received: (at 37242) by debbugs.gnu.org; 17 Feb 2020 07:32:19 +0000 Received: from localhost ([127.0.0.1]:37946 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j3at9-0008MK-H5 for submit@debbugs.gnu.org; Mon, 17 Feb 2020 02:32:19 -0500 Received: from eggs.gnu.org ([209.51.188.92]:51400) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j3at7-0008M7-T1 for 37242@debbugs.gnu.org; Mon, 17 Feb 2020 02:32:18 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]:48363) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1j3asz-00083V-KR; Mon, 17 Feb 2020 02:32:10 -0500 Received: from lns-bzn-32-82-254-31-120.adsl.proxad.net ([82.254.31.120]:37630 helo=guerry) by fencepost.gnu.org with esmtpsa (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.82) (envelope-from ) id 1j3ass-0005zE-EC; Mon, 17 Feb 2020 02:32:06 -0500 Received: by guerry (Postfix, from userid 1000) id D05FE1A60367; Mon, 17 Feb 2020 08:31:56 +0100 (CET) From: Bastien Organization: GNU Message-ID: <874kvpllee.fsf@gnu.org> References: <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> Date: Mon, 17 Feb 2020 08:31:56 +0100 In-Reply-To: <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> (Tak Kunihiro's message of "Sat, 31 Aug 2019 16:31:02 +0900 (JST)") User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) Hi Tak, Tak Kunihiro writes: > When org-mode table is converted to tab delimitated text using > orgtbl-to-tsv, empty cell is dropped out. I think this is bug. > > GNU Emacs 26.3 (build 1, x86_64-w64-mingw32) of 2019-08-29 > runemacs -Q > (require 'org-table) > (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) nil) ; => "aaa\nbbb\nddd" > (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) '(:backend ascii)) ; => " aaa \n bbb \n \n ddd " (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) nil) returns the same output than orgtbl-to-csv, which is to ignore empty *lines* when the backend is not set ("nil" here). I don't think this is a bug. (orgtbl-to-tsv '(("aaa" "AAA") ("bbb" "BBB") ("" "") ("ddd" "DDD")) nil) returns something sensible. Let me know if I miss something. Otherwise I'll close this bug in a month or so. Thanks, -- Bastien From unknown Sun Jun 15 08:58:45 2025 X-Loop: help-debbugs@gnu.org Subject: bug#37242: orgtbl-to-tsv drops empty cell Resent-From: Tak Kunihiro Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Tue, 18 Feb 2020 07:14:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 37242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: bzg@gnu.org Cc: 37242@debbugs.gnu.org, tkk@misasa.okayama-u.ac.jp Received: via spool by 37242-submit@debbugs.gnu.org id=B37242.158201002218817 (code B ref 37242); Tue, 18 Feb 2020 07:14:01 +0000 Received: (at 37242) by debbugs.gnu.org; 18 Feb 2020 07:13:42 +0000 Received: from localhost ([127.0.0.1]:39471 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j3x4f-0004tR-V5 for submit@debbugs.gnu.org; Tue, 18 Feb 2020 02:13:42 -0500 Received: from mlsec.cc.okayama-u.ac.jp ([42.127.236.175]:18561) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j3x4c-0004t9-OT for 37242@debbugs.gnu.org; Tue, 18 Feb 2020 02:13:39 -0500 Received: from alml002.ouadm.okayama-u.ac.jp (unknown [42.127.236.168]) by mlsec.cc.okayama-u.ac.jp with smtp id 6b53_7cae_50880149_f039_44c8_96cb_405d5b43d278; Tue, 18 Feb 2020 16:13:27 +0900 Received: from localhost (vesta.misasa.okayama-u.ac.jp [150.46.48.154]) by alml002.ouadm.okayama-u.ac.jp (Postfix) with ESMTPSA id B65104C0930; Tue, 18 Feb 2020 16:13:26 +0900 (JST) Date: Tue, 18 Feb 2020 16:13:26 +0900 (JST) Message-Id: <20200218.161326.1345119448000335334.tkk@misasa.okayama-u.ac.jp> From: Tak Kunihiro In-Reply-To: <874kvpllee.fsf@gnu.org> References: <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> <874kvpllee.fsf@gnu.org> X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-NAI-Spam-Flag: NO X-NAI-Spam-Threshold: 11 X-NAI-Spam-Score: 0 X-NAI-Spam-Rules: 4 Rules triggered EDT_SA_AU_PASS=0, EDT_SA_DN_PASS=0, EDT_SA_TS_PASS=0, RV6737=0 X-NAI-Spam-Version: 2.3.0.9418 : core <6737> : inlines <7190> : streams <1847667> : uri <2989908> X-Spam-Score: 1.3 (+) X-Spam-Report: Spam detection software, running on the system "debbugs.gnu.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: Dear Bastien, >> When org-mode table is converted to tab delimited text using >> orgtbl-to-tsv, empty cell is dropped out. I think this is bug. >> >> GNU Emacs 26.3 (build 1, x86_64-w64-mingw32) of 2019-08-29 >> ru [...] Content analysis details: (1.3 points, 10.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -0.0 RCVD_IN_DNSWL_NONE RBL: Sender listed at https://www.dnswl.org/, no trust [42.127.236.175 listed in list.dnswl.org] 1.3 RCVD_IN_RP_RNBL RBL: Relay in RNBL, https://senderscore.org/blacklistlookup/ [42.127.236.175 listed in bl.score.senderscore.com] -0.0 SPF_PASS SPF: sender matches SPF record 0.0 SPF_HELO_NONE SPF: HELO does not publish an SPF Record X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: 0.3 (/) Dear Bastien, >> When org-mode table is converted to tab delimited text using >> orgtbl-to-tsv, empty cell is dropped out. I think this is bug. >> >> GNU Emacs 26.3 (build 1, x86_64-w64-mingw32) of 2019-08-29 >> runemacs -Q >> (require 'org-table) >> (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) nil) ; => "aaa\nbbb\nddd" >> (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) '(:backend ascii)) ; => " aaa \n bbb \n \n ddd " > > (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) nil) returns the same > output than orgtbl-to-csv, which is to ignore empty *lines* when the > backend is not set ("nil" here). > > I don't think this is a bug. > > (orgtbl-to-tsv '(("aaa" "AAA") ("bbb" "BBB") ("" "") ("ddd" "DDD")) nil) > returns something sensible. What orgtbl-to-tsv/csv does is to convert delimiters. In my opinion, to drop out empty lines is overwork. This comes from orgtbl-to-generic. I cannot tell the behavior from docstring. If this is not a bug, I feel like this behavior is random one. From unknown Sun Jun 15 08:58:45 2025 X-Loop: help-debbugs@gnu.org Subject: bug#37242: orgtbl-to-tsv drops empty cell Resent-From: Bastien Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Tue, 18 Feb 2020 07:45:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 37242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Tak Kunihiro Cc: 37242@debbugs.gnu.org Received: via spool by 37242-submit@debbugs.gnu.org id=B37242.158201185221644 (code B ref 37242); Tue, 18 Feb 2020 07:45:01 +0000 Received: (at 37242) by debbugs.gnu.org; 18 Feb 2020 07:44:12 +0000 Received: from localhost ([127.0.0.1]:39486 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j3xYB-0005d1-TA for submit@debbugs.gnu.org; Tue, 18 Feb 2020 02:44:12 -0500 Received: from eggs.gnu.org ([209.51.188.92]:41702) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j3xY9-0005cp-RG for 37242@debbugs.gnu.org; Tue, 18 Feb 2020 02:44:10 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]:42229) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1j3xY2-0001z2-C7; Tue, 18 Feb 2020 02:44:02 -0500 Received: from lns-bzn-32-82-254-31-120.adsl.proxad.net ([82.254.31.120]:45630 helo=guerry) by fencepost.gnu.org with esmtpsa (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.82) (envelope-from ) id 1j3xY1-0006OT-OX; Tue, 18 Feb 2020 02:44:02 -0500 Received: by guerry (Postfix, from userid 1000) id B6ACA1A60367; Tue, 18 Feb 2020 08:43:59 +0100 (CET) From: Bastien Organization: GNU References: <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> <874kvpllee.fsf@gnu.org> <20200218.161326.1345119448000335334.tkk@misasa.okayama-u.ac.jp> Date: Tue, 18 Feb 2020 08:43:59 +0100 In-Reply-To: <20200218.161326.1345119448000335334.tkk@misasa.okayama-u.ac.jp> (Tak Kunihiro's message of "Tue, 18 Feb 2020 16:13:26 +0900 (JST)") Message-ID: <87k14ks5kw.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) Dear Tak, Tak Kunihiro writes: > What orgtbl-to-tsv/csv does is to convert delimiters. In my opinion, > to drop out empty lines is overwork. Empty lines in csv/tsv files (when they are not part of a double-quoted field) are ignored or should be. For example, the Python CSV parser ignores them. So Org does the right thing at not reprensenting them at all IMHO. > This comes from orgtbl-to-generic. I cannot tell the behavior from > docstring. If this is not a bug, I feel like this behavior is random > one. Yes, I don't consider this a bug. If you want to improve the documentation, can you submit a patch? Thanks, -- Bastien From unknown Sun Jun 15 08:58:45 2025 X-Loop: help-debbugs@gnu.org Subject: bug#37242: orgtbl-to-tsv drops empty cell Resent-From: Tak Kunihiro Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Wed, 04 Mar 2020 23:21:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 37242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Bastien Cc: 37242@debbugs.gnu.org, tkk@misasa.okayama-u.ac.jp Received: via spool by 37242-submit@debbugs.gnu.org id=B37242.158336405115439 (code B ref 37242); Wed, 04 Mar 2020 23:21:01 +0000 Received: (at 37242) by debbugs.gnu.org; 4 Mar 2020 23:20:51 +0000 Received: from localhost ([127.0.0.1]:41960 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j9dJq-00040x-RM for submit@debbugs.gnu.org; Wed, 04 Mar 2020 18:20:50 -0500 Received: from mail-pl1-f181.google.com ([209.85.214.181]:37968) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j9dJp-00040l-0N for 37242@debbugs.gnu.org; Wed, 04 Mar 2020 18:20:49 -0500 Received: by mail-pl1-f181.google.com with SMTP id p7so1751750pli.5 for <37242@debbugs.gnu.org>; Wed, 04 Mar 2020 15:20:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=eDxczUOfW+6VMqV4y7SPhJBb+9ZHVF7SA4PAFX+kbQI=; b=Sz7MCTCMeEmuR0JbHFy+DDAzJS0pPGEe4UIXKg7AEXb2pGRY82mVZ2r4W8W7t+8I9t ECAmEf131736w6C7P+32sgjCc/OUfIHR/3vPqwZKhkxaeBOCFdGq8bIWH+sIkOS9YlyA iPogrpMIv4jOUYHoe4NROc1aLesb0R2WJ+MzUO4dvIJ9F5iXN2W6dU6avmnsEi8ljeCx 6k/fdNEd+ODmHHm28iK9um1jn1mH6B7XzZqNLVaDLdwtdUB1EXgYbddnu5d8a7R7HvWb ed+8IAi+jz1UngVDy5p3Tn931zcGKcFbk5Fg726YZFe6mJr5u0x5NPdFZgZR4ok2kOHw natg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:cc:subject:references:date :in-reply-to:message-id:user-agent:mime-version; bh=eDxczUOfW+6VMqV4y7SPhJBb+9ZHVF7SA4PAFX+kbQI=; b=JA5vCWvw0BvW1AENrtKbKPrQvrt5DrqYZH4Ob9ePm4XDMxXOguDtQp4IQyxvL4zf0K WVnM+/hUOrisNKsVFQjRWFvkxsamFY0QtYZ6QDJ71ksP9gXKAEHER6j9tHEYIHZQGbkY QkuyD5FRV8RlAXFQ9IDv5vEm3TsNRIpv0ENjKsq98Uw9VOUGKgzgMdHxQyYAZe5KSi0f eUaF6Fe5I9R+7i5ZbXguamX8vs46foBwwk8f9EZPN9nHPD0akFpyZt5NcmTm8lg7+6oC G0x1pxaPbn4M7UXdz5QOVGsX1R2RudbwXBAGCaq0lquu6u8dldFNj08YXBjZ4PYc+tWw dODA== X-Gm-Message-State: ANhLgQ0OtWx6bucNZFNOHdqh6sXa5QcSircPhg5hvs7vpw+It6WU7TXD +rZEyScJl0ndzDwvOdRzWW4= X-Google-Smtp-Source: ADFU+vuo1g6qlYxQHt7WdJ3WFYM29czr9UBWxaa80GuAaReJttoCTnm8MV8lCs2qVh12w2erD2HyBg== X-Received: by 2002:a17:90a:ac05:: with SMTP id o5mr5634831pjq.143.1583364043224; Wed, 04 Mar 2020 15:20:43 -0800 (PST) Received: from DreamMini2019.local (vesta.misasa.okayama-u.ac.jp. [150.46.48.154]) by smtp.gmail.com with ESMTPSA id r13sm29222963pgf.1.2020.03.04.15.20.40 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 04 Mar 2020 15:20:41 -0800 (PST) From: Tak Kunihiro X-Google-Original-From: Tak Kunihiro References: <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> <874kvpllee.fsf@gnu.org> <20200218.161326.1345119448000335334.tkk@misasa.okayama-u.ac.jp> <87k14ks5kw.fsf@gnu.org> Date: Thu, 05 Mar 2020 08:20:39 +0900 In-Reply-To: <87k14ks5kw.fsf@gnu.org> (Bastien's message of "Tue, 18 Feb 2020 08:43:59 +0100") Message-ID: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (darwin) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: 0.0 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Dear Bastien, >> What orgtbl-to-tsv/csv does is to convert delimiters. In my opinion, >> to drop out empty lines is overwork. > > Empty lines in csv/tsv files (when they are not part of a > double-quoted field) are ignored or should be. > > For example, the Python CSV parser ignores them. > > So Org does the right thing at not reprensenting them at all IMHO. > >> This comes from orgtbl-to-generic. I cannot tell the behavior from >> docstring. If this is not a bug, I feel like this behavior is random >> one. > > Yes, I don't consider this a bug. If you want to improve the > documentation, can you submit a patch? I tried to go though orgtbl-to-generic, but I cannot find out how the line was dropped. I'm okay, please close the bug. -Tak From unknown Sun Jun 15 08:58:45 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: Tak Kunihiro Subject: bug#37242: closed (Re: bug#37242: orgtbl-to-tsv drops empty cell) Message-ID: References: <878shk9jm6.fsf@gnu.org> <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> X-Gnu-PR-Message: they-closed 37242 X-Gnu-PR-Package: emacs Reply-To: 37242@debbugs.gnu.org Date: Fri, 22 May 2020 13:37:02 +0000 Content-Type: multipart/mixed; boundary="----------=_1590154622-32184-1" This is a multi-part message in MIME format... ------------=_1590154622-32184-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #37242: orgtbl-to-tsv drops empty cell which was filed against the emacs package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 37242@debbugs.gnu.org. --=20 37242: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D37242 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1590154622-32184-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 37242-done) by debbugs.gnu.org; 22 May 2020 13:36:58 +0000 Received: from localhost ([127.0.0.1]:58466 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jc7r8-0008Mr-4j for submit@debbugs.gnu.org; Fri, 22 May 2020 09:36:58 -0400 Received: from eggs.gnu.org ([209.51.188.92]:42930) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jc7r6-0008Me-Id for 37242-done@debbugs.gnu.org; Fri, 22 May 2020 09:36:56 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:48486) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jc7r1-0008Gy-AA; Fri, 22 May 2020 09:36:51 -0400 Received: from lns-bzn-32-82-254-31-120.adsl.proxad.net ([82.254.31.120]:34600 helo=guerry) by fencepost.gnu.org with esmtpsa (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.82) (envelope-from ) id 1jc7r0-0000To-Ko; Fri, 22 May 2020 09:36:51 -0400 Received: by guerry (Postfix, from userid 1000) id 174A51A603E5; Fri, 22 May 2020 15:36:49 +0200 (CEST) From: Bastien To: Tak Kunihiro Subject: Re: bug#37242: orgtbl-to-tsv drops empty cell Organization: GNU References: <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> <874kvpllee.fsf@gnu.org> <20200218.161326.1345119448000335334.tkk@misasa.okayama-u.ac.jp> <87k14ks5kw.fsf@gnu.org> Date: Fri, 22 May 2020 15:36:49 +0200 In-Reply-To: (Tak Kunihiro's message of "Thu, 05 Mar 2020 08:20:39 +0900") Message-ID: <878shk9jm6.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: 37242-done Cc: 37242-done@debbugs.gnu.org, tkk@misasa.okayama-u.ac.jp X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) Hi Tak Kunihiro, Tak Kunihiro writes: > I tried to go though orgtbl-to-generic, but I cannot find out how the > line was dropped. I'm okay, please close the bug. Done, thanks. -- Bastien ------------=_1590154622-32184-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at submit) by debbugs.gnu.org; 31 Aug 2019 07:31:34 +0000 Received: from localhost ([127.0.0.1]:54984 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1i3xrB-0004WC-MA for submit@debbugs.gnu.org; Sat, 31 Aug 2019 03:31:33 -0400 Received: from lists.gnu.org ([209.51.188.17]:43734) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1i3xr9-0004W4-Qe for submit@debbugs.gnu.org; Sat, 31 Aug 2019 03:31:32 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:34616) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1i3xr7-0007Tp-UB for bug-gnu-emacs@gnu.org; Sat, 31 Aug 2019 03:31:31 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50,RCVD_IN_DNSWL_NONE autolearn=disabled version=3.3.2 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1i3xr6-0005M1-R0 for bug-gnu-emacs@gnu.org; Sat, 31 Aug 2019 03:31:29 -0400 Received: from mlsec.cc.okayama-u.ac.jp ([42.127.236.175]:38206) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1i3xr6-00059Q-CF for bug-gnu-emacs@gnu.org; Sat, 31 Aug 2019 03:31:28 -0400 Received: from alml002.ouadm.okayama-u.ac.jp (unknown [42.127.236.168]) by mlsec.cc.okayama-u.ac.jp with smtp id 70e4_0719_101e454c_a0cc_4a0f_9f0b_8f52b7bfe534; Sat, 31 Aug 2019 16:31:13 +0900 Received: from localhost (p1286214-omed01.tokyo.ocn.ne.jp [153.236.37.213]) by alml002.ouadm.okayama-u.ac.jp (Postfix) with ESMTPSA id 62A914C0A85; Sat, 31 Aug 2019 16:31:07 +0900 (JST) Date: Sat, 31 Aug 2019 16:31:02 +0900 (JST) Message-Id: <20190831.163102.2050984724735970943.tkk@misasa.okayama-u.ac.jp> To: bug-gnu-emacs@gnu.org Subject: orgtbl-to-tsv drops empty cell From: Tak Kunihiro X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-NAI-Spam-Flag: NO X-NAI-Spam-Level: X-NAI-Spam-Threshold: 11 X-NAI-Spam-Score: 0.7 X-NAI-Spam-Rules: 6 Rules triggered TS_MSG_REP_20=0.6, GEN_SPAM_FEATRE=0.1, EDT_SA_AU_PASS=0, EDT_SA_DN_PASS=0, EDT_SA_TS_PASS=0, RV6624=0 X-NAI-Spam-Version: 2.3.0.9418 : core <6624> : inlines <7139> : streams <1831418> : uri <2893150> X-detected-operating-system: by eggs.gnu.org: Genre and OS details not recognized. X-Received-From: 42.127.236.175 X-Spam-Score: -1.6 (-) X-Debbugs-Envelope-To: submit Cc: tkk@misasa.okayama-u.ac.jp X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.6 (--) When org-mode table is converted to tab delimitated text using orgtbl-to-tsv, empty cell is dropped out. I think this is bug. GNU Emacs 26.3 (build 1, x86_64-w64-mingw32) of 2019-08-29 runemacs -Q (require 'org-table) (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) nil) ; => "aaa\nbbb\nddd" (orgtbl-to-tsv '(("aaa") ("bbb") ("") ("ddd")) '(:backend ascii)) ; => " aaa \n bbb \n \n ddd " ------------=_1590154622-32184-1--