From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.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 kK6WIAq+5GHuOgAAgWs5BA (envelope-from ) for ; Mon, 17 Jan 2022 01:53:30 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id wJLVHQq+5GG4vAAA9RJhRA (envelope-from ) for ; Mon, 17 Jan 2022 01:53:30 +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 08A993AAF1 for ; Mon, 17 Jan 2022 01:53:30 +0100 (CET) Received: from localhost ([::1]:52854 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n9GH3-00038m-6U for larch@yhetil.org; Sun, 16 Jan 2022 19:53:29 -0500 Received: from eggs.gnu.org ([209.51.188.92]:47752) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n9GBy-0001iE-Tc for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 19:48:14 -0500 Received: from [2607:f8b0:4864:20::92d] (port=33686 helo=mail-ua1-x92d.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1n9GBw-0000qt-KE for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 19:48:14 -0500 Received: by mail-ua1-x92d.google.com with SMTP id u6so27743370uaq.0 for ; Sun, 16 Jan 2022 16:48:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=uX6riATA64xUv15W7AU7ZfDLn/t7HeljS6/obQUrH2s=; b=I1Je1l3fY9TTMaCEq219SvdOa3us3E70EQC4MnVC3atCHxlTC7n3i1Ia6tiNkbLSOJ 4quod5lZyXCs79Vw3rDNoRneMj1/HdMfJBYtHgX9jiE3aYPhsYLDthhF977B1lo0f2GU xez7Olvml2y9xHJnyVxQ4rZqyZhGj67Rj5tUcasgbYp77ywWfTBH/LyHCi6y3+gMybvi h8qdZXHG6OZkUacq08bcxkMiQf2Bk297GZRTFc6pxHDgWQtbcGsYarYs/RqxQW6f7XV3 FX9XthqwJe1wD7fJLArUrQ0x0F4f0lhNP78AgvUd4xcjn8gi5ykQMcBxWJy2kodXb2Gs yc3A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=uX6riATA64xUv15W7AU7ZfDLn/t7HeljS6/obQUrH2s=; b=vhBQTHUpWv6jWG/G+7AkBFN2fO8x9oTbvctP5daohZuuY0jXgUW9GgMBqjd9Hradp+ d/mom9oWiJXNHp3eEqNhjKnQW5hYEqI8VUGFfcbiJHSf2Mzr2zG1t9UF1rpHrE5k/Ldp QcBlk0I1bTN/H5UY9ESKDjFrY5NlmRGWAc1hgzTmXl/DMjxopM0jyMxqACh2v4gLdvSo w4V8AX6/cmBTEl9itdduiUSt2LXHwOL67509UhLbxipkGskYExChnFgl7GQP7rRH0uvO QE7SdZfyxAp8CGjd/If2xifbhrdO7lxkwncgMa+ml/IUB9PgDCsZz/Uuxvl5IovPr1zR rTSQ== X-Gm-Message-State: AOAM531Z4JuEyHxDO+FdRww9STele1RMEpbj97cGTmFXcQF/B9b4nIJH fBDrLuBZjTwTR25hzrU2iUSCEt5MJIMuigsh7Oo= X-Google-Smtp-Source: ABdhPJx34q/+iddG5B5UVWt55D56tH2UDPzFTnP5rVAlWrOhYVqOxHQsvTfe3K2yM1SkTCoO058TdP3O0UIuXp+ag4s= X-Received: by 2002:a67:ffcb:: with SMTP id w11mr6686463vsq.62.1642380491006; Sun, 16 Jan 2022 16:48:11 -0800 (PST) MIME-Version: 1.0 References: <877dazu7tl.fsf@gmail.com> In-Reply-To: <877dazu7tl.fsf@gmail.com> From: John Hendy Date: Sun, 16 Jan 2022 18:48:00 -0600 Message-ID: Subject: Re: R terminal output does not match src block output due to ">" character in results To: Jeremie Juste Content-Type: text/plain; charset="UTF-8" X-Host-Lookup-Failed: Reverse DNS lookup failed for 2607:f8b0:4864:20::92d (failed) Received-SPF: pass client-ip=2607:f8b0:4864:20::92d; envelope-from=jw.hendy@gmail.com; helo=mail-ua1-x92d.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=1642380810; 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=uX6riATA64xUv15W7AU7ZfDLn/t7HeljS6/obQUrH2s=; b=b7uVJHlpgX82zusVImqcRSEvXcNCoMNtrsu+b8AqalI3utEQZG3WmU5h8FgjMMfcMn6rz6 3AdHwHMHGG2NpnjWxPXvRBOX39ZfJE49aZcSjwJ8kmjbeITdqE7e+BygMsRoCz01LNWHQu +P6d7oeOyrUeMRRoB/Xamv5t99zTgLwe0cStj5V7mcsiL1NKZT3j+uy0+yHxkBIbvMbZJS xGQqBOzYmQVr2niDeR+001Q0oJJFZ139FaENVCZSVtPaQOL+sxjxLr9ad/hLP9hNCi0O+d PP/vx5cOtlSPxLxrj95uoaNQJHyNxT/8CnzeNOEf0wwCKtf+ujEKfpg7L0ML0w== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1642380810; a=rsa-sha256; cv=none; b=g4uE+MssEUBRwPUDUmQ3ZTRPQmlnqiTNPVpgLFD2WInMK639FNfbI34QhpO1MtsaYfbqcj /9nXpWvsduCJg53+ePOkXs3NyUOUDnbiHuaOr4uTmLnX/f3gzSVT3iDXqW6SQGxH84CJ7w TR59pod8K8fBKoeBX8AxL85RrQuxLgAjMqod0TEMZI799ZOYLZ3LUZygHPXOj535qqEq2v fFW4d9DtQwCEkDxeWD9meWHw+PolMbJ5YdlGFlqlDsqu9p0BOpzD4UeXG+7uKnhlU/jNnn xiRy0FNZr5eTm8uxwGCimUcqq+RJq3hV7ABMG4d/W2ZwOxXlaq9F0uPEirrnxQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=I1Je1l3f; 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: -5.62 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=I1Je1l3f; 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: 08A993AAF1 X-Spam-Score: -5.62 X-Migadu-Scanner: scn0.migadu.com X-TUID: /p8XrIk7C8of On Sun, Jan 16, 2022 at 7:30 AM Jeremie Juste wrote: > > 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 > >From our other thread, I *think* I'm already on 9.5? Re-pasting my org-version answer here: #+begin_quote $ git log commit 7fa8173282f85c2ca03cc7f51f28f6adfb250610 (HEAD -> master, origin/master, origin/HEAD) Author: Ian Martins Date: Sat Jan 16 15:52:21 2021 -0500 But Mx-version: Org mode version 9.4.4 (release_9.4.4-186-g7fa817.dirty @ /home/jwhendy/.elisp/org/lisp/) So perhaps it appends the git commit to the system version? #+end_quote 9.5 appears 4mos old... so I think I'm on it? https://git.savannah.gnu.org/cgit/emacs/org-mode.git/ I'll try the example later. I'd like for this to work for :results output and :results value. I'm pretty sure I already explored :results value and found it to work. One thing that confused me was why I didn't get a header row with the org table coming from :results value? Thanks for the help and I'll get back to you early this week to confirm on the example below. John > #+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 | > >