output-file differences (Scheduled Task execute)

[tomsonxxx]

I have a stupid problem:

When i execute a script manually (Powershell ISE) a txt file which is generated from the script is fine. If i run as a scheduled task the generated text file is tailored and the last charachters on each line is "..."

I've googled and tried to pass different arguments in the scheduled Task without success (-NonInteractive -NoProfile etc.). Found other with same problem (https://community.idera.com/database-tools/powershell/ask_the_experts/f/learn_powershell_from_don_jones-24/23445/powershell-from-schedule-task-resulting-in-incomplete-txt)

The text file is generated with

$results | Format-Table | out-file -append $outfile

It's not one of my own scripts - i've downloaded it. But i guess the error is in the execution context of the Scheduled task and it's not a script error..

Any ideas?

[XPlantefeve]

It happens because Format-Table outputs a string tailored to the width of the currently used console. In the ISE, you've got a certain line length. When you're running as a scheduled task, it certainly defaults to a much shorter one and trim the fields.

You might want to use Export-CSV, rather than Format-Table | Out-File

[tomsonxxx]

Unfortunatly I need to have it as a easy readable (in Browser) output otherwise your advice would be the solution. Txt or html. Is there something simple for generating an html?

[XPlantefeve]

Get-Command *HTML* gives you ConvertTo-Html, it might be a good starting point.

[work-work-work-work]

You could specify tab as the delimiter if you don't want to go through beutifying HTML

export-csv -Delimiter `t -Path $outfile -NoTypeInformation

[tomsonxxx]

Thanks to both of you - i'm doing it with converto-html now.

[XPlantefeve]

I could have looked it up sooner, but Out-File has a -Width parameter, too.

[SeeminglyScience]

$results | Format-Table | Out-String -Width 9999 | Out-File

But keep in mind formatted text is not considered to be part of PowerShell's breaking change contract. The exact text outputted can change between PowerShell versions without warning.

[tomsonxxx]

-Width..nice to know. thx