英文:
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)} }
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。


评论