Continue a file path in the next line in R

Question

When a render this script with the RMarkdown, the path of a file exceeds the limit of the PDF.

df_reserva = read_excel('E:/OneDrive/FACULDADE/Semestre 6/Métodos Quantitativos Aplicados a Políticas Públicas e Sociais/Trabalho Final/Bases de Dados/forms.xlsx')

I want to add some line breaks, so the code looks like this

df_reserva = read_excel('E:/OneDrive/FACULDADE/Semestre 6/    
Métodos Quantitativos Aplicados a Políticas Públicas e Sociais/    
Trabalho Final/Bases de Dados/forms.xlsx')

Any tips here?

Do you want to add line breaks? Use ```\\``` or ```\newline``` — manro, Jan 06 '22 at 12:19

score 1 · Answer 1 · answered Jan 07 '22 at 04:56

1

Does this work?

p1 <- 'E:/OneDrive/FACULDADE/Semestre 6/'
p2 <- 'Métodos Quantitativos Aplicados a Políticas Públicas e Sociais/'
p3 <- 'Trabalho Final/Bases de Dados/forms.xlsx'
df_reserva <- read_excel(paste0(p1, p2, p3))

answered Jan 07 '22 at 04:56

dcarlson

10,936
2
15
18

It works! But is there any possibility to do it like in Python, where we can use "\" to continue on the next line? Thanks a lot! – Felipe Queiroz Jan 07 '22 at 17:41
I don't think so since the the backslash and new line will be included in the string. See [Split code over multiple lines in an R script](https://stackoverflow.com/questions/6329962/split-code-over-multiple-lines-in-an-r-script) for some other approaches. – dcarlson Jan 08 '22 at 02:19

score 1 · Accepted Answer · answered Jan 14 '22 at 08:57

You should use file.path(). For instance:

df_reserva = read_excel(file.path('E:/OneDrive/FACULDADE/Semestre 6',
                                  'Métodos Quantitativos Aplicados a Políticas Públicas e Sociais',
                                  'Trabalho Final/Bases de Dados/forms.xlsx')

If you use R > 4.1.0 you can also use basepipe (|>) to make it more readable by avoiding nested parenthesis:

file.path('E:/OneDrive/FACULDADE/Semestre 6',
          'Métodos Quantitativos Aplicados a Políticas Públicas e Sociais',
          'Trabalho Final/Bases de Dados/forms.xlsx') |>
    read_excel() -> df_reserva

Continue a file path in the next line in R

2 Answers2