Powershell automatically using new line

Question

I'm in trouble with my script.

I'm grabbing paths out of an XML-File, that need to be modified.

$file = [xml](Get-Content "PATH\TO\XML.xml")

$file.here.is.my.attribute  | Format-Table -Wrap -AutoSize | out-file -filepath ".\PATHS.txt" -append

Powershell is inserting line-breaks in the middle of my path, because it's to long (Just read about buffersize). I tried to save it to an .XML File instead of an .TXT File but that didn't work for me.

Any Idea of a workaround?

File should look like this:

Path1\Path\Path\path  
Path2\Path\Path\path  
Path3\Path\Path\path

But it looks like:

Path1\Path\Path\  
path  
Path1\Path\Path\  
path  
Path1\Path\Path\  
path

XML-Example:

<?xml version="1.0" encoding="utf-8"?>
<unattend>
  <servicing>
    <package>
      <assemblyIdentity/>
      <source location="HERE\IS\MY\PATH"/>
    </package>
    <package>
      <assemblyIdentity/>
      <source location="HERE\IS\ANOTHER\PATH"/>
    </package>
    <package>
      <assemblyIdentity/>
      <source location="HERE\IS\ANOTHER\PATH"/>
    </package>
  </servicing>
</unattend>

and why precisely do you think you need to pipe Format-Table to Out-File? shouldnt it be either-or? — Jaqueline Vanek
– Jaqueline Vanek, Commented Jan 11, 2016 at 12:37
I used it to format the line automatically to the right length. But "autosize" is at its maximum — Daniel Groß
– Daniel Groß, Commented Jan 11, 2016 at 12:38
Are there multiples <package> elements in one <servicing>? Either way I can pull out that one with $xml.unattend.servicing.package.source.location You can get the attributes via dot notation as well. — Matt
– Matt, Commented Jan 11, 2016 at 13:08
you might be missing a ".location" at the end of "$file.here.is.my.attribute" -- not accessing the attribute value properly — Jaqueline Vanek
– Jaqueline Vanek, Commented Jan 11, 2016 at 13:10

Matt · Accepted Answer · 2016-01-11 13:17:26Z

1

First Format-Table is merely for console output. Trying to use for anything other than that will cause you issues. Given your sample XML you can just use dot notation to get all location's

In your example you were trying to output an object array with a location property. Calling the attribute using dot notation removes that layer from the output.

$xmlFile = [xml](Get-Content "PATH\TO\XML.xml")
$xmlFile.unattend.servicing.package.source.location | Set-Content ".\PATHS.txt"

I don't think you actually needed to be appending to the file in this case. However if you really are building a larger file then you can use Add-Content in place of Set-Content in my example.

Sample Output

HERE\IS\MY\PATH
HERE\IS\ANOTHER\PATH
HERE\IS\ANOTHER\PATH

answered Jan 11, 2016 at 13:17

Matt

47.1k9 gold badges90 silver badges125 bronze badges

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

1 Comment

Daniel Groß Over a year ago

Thank you so much, I nearly spend hours on that issue. :-)

Collectives™ on Stack Overflow

Powershell automatically using new line

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related