Extract only perticular data from excel coulmn by using powershell

Abhishek Reddy 61

Requirement is to fetch only name of service by cutting down before and after period, AAA.BBB.CCC is the service name which is writing to excel so while importing that excel we need to have trimmed it to display only BBB.

Please help here

Accepted answer

Rich Matheisen 45,096 Reputation points

2021-10-25T14:24:38.463+00:00
Try changing that "select" cmdlet to:

$res | Select-Object @{n='ServiceName';e={($_.ServiceName -split "\.")[1]}}, Status, MachineName
Please sign in to rate this answer.

1 person found this answer helpful.
Abhishek Reddy 61 Reputation points

2021-10-26T03:51:53.623+00:00

Thanks a lot for your swift response sir, it worked exactly how I wanted it to be.
Thank you for the help !
Sign in to comment

1 additional answer

SChalakov 10,261 Reputation points MVP

2021-10-25T09:41:48.68+00:00

Hey,

can you please post the script you have written? Please explain what is not working, what the challenges are?

Thanks in advnace!

Regards,
Stoyan
Please sign in to rate this answer.
Abhishek Reddy 61 Reputation points

2021-10-25T09:48:55.043+00:00

Hi Stoyan,
Please see below
'You chose option #6'
$services = Get-Content -Path "C:\SoftWares\Server\Services\Pitsburg.txt"
$machines = Get-Content -Path "C:\SoftWares\Server\Servers\Pitsburg.txt"
foreach ($computer in $machines)
{
Write-host "Services are going to be detailed on $computer" -b "green" -foregroundcolor "Black"
$res += foreach ($service in $services)
{
Get-Service -ComputerName $computer -Name $service
}
}
$res |select ServiceName,Status,MachineName | Export-Csv -NoTypeInformation -Encoding UTF8 -Path "C:\SoftWares\Server\Pitsburg Services.csv"
$R = Import-Csv -Path "C:\SoftWares\Server\Pitsburg Services.csv" | sort -Property "Status"
$R | Format-Table
break

This is the code, it is working fine but I wanted to shorten the service Name, as of now it writes in the excel and imports AAA.BBBB.CCCC but I wanted only BBBB.

Kindly help
Sign in to comment