From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id sHGeJloe5GF5cAEAgWs5BA (envelope-from ) for ; Sun, 16 Jan 2022 14:32:10 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id ICQvI1oe5GF1mQAAauVa8A (envelope-from ) for ; Sun, 16 Jan 2022 14:32:10 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 4FA4230D22 for ; Sun, 16 Jan 2022 14:32:10 +0100 (CET) Received: from localhost ([::1]:48272 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n95dh-0005lX-E3 for larch@yhetil.org; Sun, 16 Jan 2022 08:32:09 -0500 Received: from eggs.gnu.org ([209.51.188.92]:53418) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n95c0-0005dw-Ip for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 08:30:26 -0500 Received: from [2a00:1450:4864:20::32e] (port=39535 helo=mail-wm1-x32e.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1n95bw-0006Mr-IX for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 08:30:23 -0500 Received: by mail-wm1-x32e.google.com with SMTP id d18-20020a05600c251200b0034974323cfaso17715258wma.4 for ; Sun, 16 Jan 2022 05:30:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=4E/2547HMuenlYtPwY+ASk6tKmVOCvrHJ1mucaMbfQM=; b=PAv1/Qy7AyZPapxXA19Wm1VaoF5cmxDqyet+GReVyH/Pm5jcMgEOoDkWSk0x0j0BTM n3s9fWuZYoGZNKToZ/S0ZQn1cDvdovALnkVIi5uXWyfpi1VDKESrRanQ7CUEKjmoxcl1 aBXMccyRcF79CfRlO8+F0oP7bxntBhKXwZ45kbupxfh+t6/Exq5EF1nC3p4BckGW4oj1 wFm/i9nC7Ndk88hMKALo0WFzDOVCohq/Jgt7vAjmaLNb/Dip1pvxOGRjve1AbLNc4s6M cpUu4yaRbqwcpGHvLJ7sv8lrJRdfRfi/piVJpWt1KXRwhIhoeKCDR4vN0VmuVYkXOczS KIfQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=4E/2547HMuenlYtPwY+ASk6tKmVOCvrHJ1mucaMbfQM=; b=IryqMX9pcvTxeITuTuJV26xnq0lQG53oeypZhHkA2kaKGULP+F/ShNjM4kjcr576lD 24Crp+IOJtLoAyOLev0ZPYb77svfTiAM3JkOf6qLFx/zjwQugKKd3XOkD7GJ/g+028dN oVUeD0IVijI8XKec7areVSaM3U70w3DwAjMgKlcer6TPiNz2Nqte/Ty7tgHlPRlTpSIg M8DbuXUPLxu00wtBamWkpN1MF2/KHFXwYvy6Vth0bSpmVpfrTsZ8xS7rYRNFbo7VJvhC WH345B+1jTIOcs2mVoUgG26TRUt6+92sYveZq3B+BMl0DmLt1hvlAdFBRH5zbU1wecf0 ndhw== X-Gm-Message-State: AOAM533Ahs4k9lwZZUkPX41jtRNy3N0RkipH8ve5da+OJjjSxxOa2Pg8 +480dGJHDaxn82EXxLvxVP0= X-Google-Smtp-Source: ABdhPJxxAHTlfdmNUYTcl6FOQPh/Qu3jG+KoWF24HsK8RibpUp3Fa5WK6IHLEITGEqmRb3jLZEo+EQ== X-Received: by 2002:a5d:4f8b:: with SMTP id d11mr15904159wru.69.1642339816973; Sun, 16 Jan 2022 05:30:16 -0800 (PST) Received: from localhost ([2a02:908:1d0:8d20:d4e3:87a8:ad14:a57b]) by smtp.gmail.com with ESMTPSA id f141sm5040454wmf.30.2022.01.16.05.30.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 16 Jan 2022 05:30:16 -0800 (PST) From: Jeremie Juste To: John Hendy Subject: Re: R terminal output does not match src block output due to ">" character in results References: Date: Sun, 16 Jan 2022 14:30:14 +0100 In-Reply-To: (John Hendy's message of "Tue, 11 Jan 2022 17:30:41 -0600") Message-ID: <877dazu7tl.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a00:1450:4864:20::32e (failed) Received-SPF: pass client-ip=2a00:1450:4864:20::32e; envelope-from=jeremiejuste@gmail.com; helo=mail-wm1-x32e.google.com X-Spam_score_int: -12 X-Spam_score: -1.3 X-Spam_bar: - X-Spam_report: (-1.3 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, PDS_HP_HELO_NORDNS=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: emacs-orgmode Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1642339930; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=4E/2547HMuenlYtPwY+ASk6tKmVOCvrHJ1mucaMbfQM=; b=doG9rUgX0wcxpJ9bg4xt74/rrIqT/kebdpvxcSL/tIgo3qRBNqltg4p+chgYLJToKrcM/0 8g6wX3PEqiTdMob7MPkXv3rmaI039tfdaMOBv/RCKjL9cAxALVBiwo4RodD1Ep/t7lMd7C 9bwajEr7CpbiyEOwmKR0iQmM3glK834XcbF5ndeYHUfHif+C9p2HAyBNNfEDa+4MOBFgfx V4IIg/lWQ1g3xWGSBq40uRXkTL7UO11RIPGHSyL/V/Rrd89zzbwPT4t8hx/CoXsdQ6xF5v KrKb9SIqrve6zotalr4QrXSprQZBgtrVPRCTjM4W+TUr2879YxQIEFzRgbSkBA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1642339930; a=rsa-sha256; cv=none; b=eeDFbE/sO99IGX7X3oitODi1tu7PRhl1DfOyyF44+W95EubONiSGDoq8dLykuvelL5OCGM kLkf2K+XuD2zYVBwaz+l6f3uOQ9nemovbD3mTmljkCetWPsB2BQkhqvn/zXInnqaRmiyBL nxkzLSX+QGgiwwhSRjSniYDx+0quP9NX4WlzgZwQCT3nGlCCKaP2MtwEz6be7+zi/twA3h XgqCi2PJtrczucw3wiZSyED/OwpEt5/LeAd2ROtWdI6cSY6QriIzbW9t/T7HOPahcW/BtP alt6vtv7AX8uHDnQpz989Yek6uYI0U9KjSTiiazECuEIP6uMl2PWhj4fPUeKiw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b="PAv1/Qy7"; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -4.33 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b="PAv1/Qy7"; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: 4FA4230D22 X-Spam-Score: -4.33 X-Migadu-Scanner: scn1.migadu.com X-TUID: X337sWMlhufQ Hello John, As promised, I'm coming back about the formatting of NA_characters_. In org-mode 9.5 NA_characters_ are not printed anymore with :results value. See example 2 and 3 for more details. Please let me know if this post solves your issues. Woudl updating to 9.5 be an option for you? Best regards, Jeremie #+BEGIN_SRC elisp (org-version) #+END_SRC #+RESULTS: : 9.5 #+BEGIN_SRC elisp (emacs-version) #+end_src #+RESULTS: : GNU Emacs 27.2 (build 1, x86_64-pc-linux-gnu, GTK+ Version 3.24.24) : of 2021-11-26 * Example 1 #+BEGIN_SRC R :results output data.frame(abc=NA_character_) #+end_src #+RESULTS: : abc : 1 * Example 2 #+BEGIN_SRC R :results value a <- data.frame(column1=NA_character_,column2=1:10) #+end_src #+RESULTS: | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | | 8 | | | 9 | | | 10 | * Example 3 #+BEGIN_SRC R :results value :colnames yes library(RSQLite) con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "df", data.frame(column1=NA_character_,column2=1:10)) dbGetQuery(con, "SELECT * FROM df") #+end_src #+RESULTS: | column1 | column2 | |---------+---------| | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | | 8 | | | 9 | | | 10 |