Powershell Default User

[Lakshmana]

@scottalanmiller Its already there when i am copy pasting its not showing

[dbeato]

@scottalanmiller said in Powershell Default User:

@lakshmana said in Powershell Default User:

@dbeato said in Powershell Default User:

@black3dynamite said in Powershell Default User:

@lakshmana said in Powershell Default User:

@dbeato said in Powershell Default User:

[string]$file = 'C:$env:UserName\fILENAME'
)

Get-Item : Cannot find path 'C:$env:Username\Tickets' because it does not exist.

It should be 'C:\Users\$env:USERNAME\filename'

That's right...

Get-Item : Cannot find path 'C:\Users$env:USERNAME\filename' because it does not exist.

Still missing the \

If you quote it, it shows. I am not sure if it is a bug on NodeBB.

[scottalanmiller]

@lakshmana said in Powershell Default User:

@scottalanmiller Its already there when i am copy pasting its not showing

Oh, you have to escape it.

[dbeato]

This is a small sample I did and it worked:

[scottalanmiller]

Are you sure that the filename exists?

[dbeato]

Better example:

[Lakshmana]

@scottalanmiller said in Powershell Default User:

Are you sure that the filename exists?

The files exists inside that folder and before doing this i have mentioned as in .bat but that has to runned in the all the machine means it should get the current user details so only asked for the same which is not working when tried to execute in the powershell

[dbeato]

@lakshmana said in Powershell Default User:

@scottalanmiller said in Powershell Default User:

Are you sure that the filename exists?

The files exists inside that folder and before doing this i have mentioned as in .bat but that has to runned in the all the machine means it should get the current user details so only asked for the same which is not working when tried to execute in the powershell

So are you running this via a task or when the user logs in?

[black3dynamite]

@lakshmana said in Powershell Default User:

@dbeato said in Powershell Default User:

@black3dynamite said in Powershell Default User:

@lakshmana said in Powershell Default User:

@dbeato said in Powershell Default User:

[string]$file = 'C:$env:UserName\fILENAME'
)

Get-Item : Cannot find path 'C:$env:Username\Tickets' because it does not exist.

It should be 'C:\Users\$env:USERNAME\filename'

That's right...

Get-Item : Cannot find path 'C:\Users$env:USERNAME\filename' because it does not exist.

C:\$env:Username\Tickets should be 'C:\Users\$env:USERNAME\Tickets'

[Lakshmana]

@black3dynamite said in Powershell Default User:

@lakshmana said in Powershell Default User:

@dbeato said in Powershell Default User:

@black3dynamite said in Powershell Default User:

@lakshmana said in Powershell Default User:

@dbeato said in Powershell Default User:

[string]$file = 'C:$env:UserName\fILENAME'
)

Get-Item : Cannot find path 'C:$env:Username\Tickets' because it does not exist.

It should be 'C:\Users\$env:USERNAME\filename'

That's right...

Get-Item : Cannot find path 'C:\Users$env:USERNAME\filename' because it does not exist.

C:\$env:Username\Tickets should be 'C:\Users\$env:USERNAME\Tickets'

I have changed already

[Lakshmana]

@dbeato said in Powershell Default User:

@lakshmana said in Powershell Default User:

@scottalanmiller said in Powershell Default User:

Are you sure that the filename exists?

The files exists inside that folder and before doing this i have mentioned as in .bat but that has to runned in the all the machine means it should get the current user details so only asked for the same which is not working when tried to execute in the powershell

So are you running this via a task or when the user logs in?

This is the powershell which converts into .csv to .xlsx in the machine in the folder mentioned

[Lakshmana]

@lakshmana The $env:USERNAME is not working inside string it seems ?Any suggestions ?

[manxam]

@lakshmana : It works fine, but you're using the wrong quotes.
[string]$file = "C:\Users\$env:username\blah"

Variable names cannot be replaced in a string delimited with '
$test = 'My variable'
$this = "This is $test"
PS > $this
PS > "This is My Variable"

[Lakshmana]

@manxam Thanks now it works in command prompt from the .bat file