从SELECT结果中提取子字符串

huangapple go评论90阅读模式
英文:

Extract substring from a result in Select

问题

报告的错误出现在 .Substring 部分。

Select 中提取子字符串的有效方法如下:

Connect-ExchangeOnline
Get-DistributionGroup -ResultSize Unlimited
Get-DistributionGroupMember -Identity "Groupname" -ResultSize Unlimited |
Select FirstName, LastName, @{Name="FirstTwoCharsOfLastName"; Expression={$_.LastName.Substring(0,2)}}

请注意,我已经将 LastName.Substring(0,2) 封装在一个计算表达式中,并为新列指定了一个名称 "FirstTwoCharsOfLastName"。这将允许你从结果中提取姓氏的前两个字符。

英文:

I'm attempting to get a substring in a Select filter from a command result. Much like this

Connect-ExchangeOnline
Get-DistributionGroup -ResultSize Unlimited
Get-DistributionGroupMember -Identity "Groupname" -ResultSize Unlimited |
Select FirstName, LastName, LastName.Substring(0,2)

An error is reported at the .Substring apart.

What would a working way to extract a substring from a result with Select

答案1

得分: 1

最直接的方法是使用 Select-Object 过滤器中的散列表创建自定义属性:

Select FirstName, LastName, @{ Label="ShortName"; Expression={$_.LastName.Substring(0,2)} }
英文:

The most straightforward approach is to create a custom property using a hashtable in your Select-Object filter:

Select FirstName, LastName, @{ Label="ShortName";Expression={$_.LastName.Substring(0,2)} }

huangapple
  • 本文由 发表于 2023年2月23日 22:04:00
  • 转载请务必保留本文链接:https://go.coder-hub.com/75545865.html
  • powershell-7
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定