How to format the file in powershell

Question

am trying to format one file which is like below.

IPAddresss    HostName                  Result
none sinuiy01.infra.go2uti.com                NotValid
none  sinuid20.devtst.go2uti.com                NotValid
172.21.40.204  USEM9999.essilor.res                  Success
172.21.40.204  webmail.nscorp.com                NotValid
172.21.40.204  nsc.nscorp.com                Unsuccess
172.21.40.204  bp-nsc.nscorp.com                NotValid

But need result like below:--

IPAddresss         HostName                                Result
none               sinuiy01.infra.go2uti.com               NotValid
none               sinuid20.devtst.go2uti.com              NotValid
172.21.40.204      USEM9999.essilor.res                    Success
172.21.40.204      webmail.nscorp.com                      NotValid
172.21.40.204      nsc.nscorp.com                          Unsuccess
172.21.40.204      bp-nsc.nscorp.com                       NotValid

Could you please suggest whcih function I should use to get the above results?

Below is the script:-

Here is the script am working on

"IPAddresss    HostName                  Result" | Out-File -Append D:\CEP\testlogging.txt 
$lines = Get-Content myfile.txt | Where {$_ -notmatch "((^#)|(^\s+$))"}
foreach ($line in $lines) {
    $fields = $line -split '\s+'
    $ip = $fields[0]
    for ($i = 1; $i -lt $fields.Length; $i++) {
        $ESXHost = $fields[$i]
    echo "Host $ESXHOST"
    try
        {
        $currentConnection = Test-Connection $ESXHost -ErrorAction stop

        if($currentConnection.Count -gt 0)
            {
            $hostIP = ($currentConnection)[$i].IPV4Address.IPAddressToString

            echo "hostIp $hostIP"
                if ($hostIP -eq $ip) 
                { 

                "$hostIP  $ESXHost                  Success" | Format-Table -Wrap -AutoSize | Out-File -Append D:\CEP\testlogging.txt 



                }
                else 
                {

                "$hostIP  $ESXHost                  Unsuccessful" | Format-Table -Wrap -AutoSize | Out-File -Append D:\CEP\testlogging.txt
                }
            }

        }

What format is the file? And are you outputting that data from PowerShell to the file or are you reading the file in to then be formatted by PowerShell? Do you have the Code that you have been working on? — Richard
– Richard, Commented Jul 31, 2013 at 10:26
file is .txt, and am trying it in the power shell script. Something like Format-Table -Wrap -AutoSize | Out-File -Append D:\CEP\testlogging.txt — sharsour
– sharsour, Commented Jul 31, 2013 at 10:30
Are you trying to format by position (fixed # of characters) or with a specific delimiter? — alroc
– alroc, Commented Jul 31, 2013 at 12:57

JPBlanc · Accepted Answer · 2013-07-31 12:45:55Z

1

you can try :

Get-Content C:\temp\t1.txt | % {$_ -replace ' +',' ' }| % { $parts = $_.split(' '); Write-output ("{0,-15}{1,-30}{2,-8}" -f $parts[0],$parts[1],$parts[2])} | Out-File  C:\temp\t2.txt

answered Jul 31, 2013 at 12:45

JPBlanc

73k17 gold badges137 silver badges180 bronze badges

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

Comments

Richard · Accepted Answer · 2013-07-31 13:14:22Z

1

As you are using a string to output the data to the text file you could try the following String formatting to space out the variable in the string evenly. In the example below the spacing is 25 characters between each value:

[string]::Format("{0,-25}{1,-25}{2,-25}",$hostIP,$ESXHost,"Success") | Out-File -Append D:\CEP\testlogging.txt

Syntax:

$I - This is the parameter number to be inserted (0 or more)
$C - The number of total characters before the next variable.
(Negative numbers make the word start from the left)

[string]::Format("{$I,$C}",Parameter1,Parameter2)

There is also a shorthand way of performing the same action using the -f operator:

"{0,-25}{1,-25}{2,-25}" -f $hostIP,$ESXHost,"Success" | Out-File -Append D:\CEP\testlogging.txt

edited Jul 31, 2013 at 13:14

answered Jul 31, 2013 at 12:41

Richard

7,0685 gold badges48 silver badges61 bronze badges

Collectives™ on Stack Overflow

How to format the file in powershell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related