Execute windows powershell command in Rstudio

Question

I want to execute in Rstudio this powershell command

[System.IO.File]::ReadLines(".\Dropbox\TesisGrado\R_Data\rawdata\5.Azules\200 ppfd\65.dm68i.e.r.1.dat")

I've tried many ways like

system( "[System.IO.File]::ReadLines", input= ".\\65.dm68i.e.r.1.dat")

shell("[System.IO.File]::ReadLines", input= ".\\Dropbox\\TesisGrado\\R_Data\\rawdata\\5.Azules\\200\ ppfd\\65.dm68i.e.r.1.dat")

system("cmd.exe", input = paste("powershell [System.IO.File]::ReadLines(\".\\Dropbox\\TesisGrado\\R_Data\\rawdata\\5.Azules\\200\ ppfd\\65.dm68i.e.r.1.dat\")"))

system("cmd.exe", input = paste("powershell [System.IO.File]::ReadLines(\"65.dm68i.e.r.1.dat\")"))

Getting this kind of error

Microsoft Windows [Versi¢n 10.0.16299.192]
(c) 2017 Microsoft Corporation. Todos los derechos reservados.

    C:\Users\Admin\Dropbox\TesisGrado\R_Data\rawdata\5.Azules\200 ppfd>powershell [System.IO.File]::ReadLines("65.dm68i.e.r.1.dat")
    En l¡nea: 1 Car cter: 29
    + [System.IO.File]::ReadLines(65.dm68i.e.r.1.dat)
    +                             ~
    Falta el par‚ntesis de cierre ')' en la llamada al m‚todo.
    En l¡nea: 1 Car cter: 29
    + [System.IO.File]::ReadLines(65.dm68i.e.r.1.dat)
    +                             ~~~~~~~~~~~~~~~~~~
    Token '65.dm68i.e.r.1.dat' inesperado en la expresi¢n o la instrucci¢n.
    En l¡nea: 1 Car cter: 47
    + [System.IO.File]::ReadLines(65.dm68i.e.r.1.dat)
    +                                               ~
    Token ')' inesperado en la expresi¢n o la instrucci¢n.
        + CategoryInfo          : ParserError: (:) [], ParentContainsErrorRecordException
        + FullyQualifiedErrorId : MissingEndParenthesisInMethodCall
     
    
    C:\Users\Admin\Dropbox\TesisGrado\R_Data\rawdata\5.Azules\200 ppfd>[1] 0

My current directory in Rstudio is C:/Users/Admin/Dropbox/TesisGrado/R_Data/rawdata/5.Azules/200 ppfd/

What i'm doing wrong? How can i read that file executing powershell command?

R's system and system2 do not deal well with arguments that have embedded spaces. I suggest using the ps package. — r2evans
– r2evans, Commented Oct 23, 2021 at 1:19

Mauro · Accepted Answer · 2023-11-11 16:18:45Z

1

In Rstudio, system() works just by specifying the file name, if you are in the directory that contains it. In PowerShell you must specify the full path, no matter if you are in the folder or not. Hence,

system2("cmd.exe", input = paste("powershell [System.IO.File]::ReadLines('.\\65.dm68i.e.r.1.dat')"))

The above code works. I had to change the quotation.

edited Nov 11, 2023 at 16:18

answered Oct 23, 2021 at 4:45

Mauro

1071 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

RokeJulianLockhart Over a year ago

Your answer is very difficult to understand. I think you should rephrase the first sentence.

Mauro Over a year ago

Like it now? Thanks

RokeJulianLockhart Over a year ago

Yeah, Mauro, stackoverflow.com/revisions/69685195/2 is much better. Thanks.

Collectives™ on Stack Overflow

Execute windows powershell command in Rstudio

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related