blocks|key|3841415|text|Olaf的评论应该已经很好地解决了这个问题。这是另一种方式，只是做他建议的不同的方式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3841416|Get-TransportRule+-Identity+'domain+block'+%7C+
++++select-Object+-ExpandProperty+SenderDomainIs+%7C+
++++++++Foreach+{
++++++++++++[pscustomobject]@{'Domain'+=+$_}
++++++++}+%7C+Export-Csv+c:\temp\domains.csv+-notype|code-block|syntax|javascript|3841417|CSV内容|3841418|get-content+C:\temp\domains.csv

"Domain"
"chess.com"
"jen.com"
"bob.com"
"joe.com"
"irish.com"
"ND.com"
"goirish.com"
"fieldnotes.com"|3841419|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Olaf's comments should have solved this fine. Here's another way, just different way of doing what he suggested.
<pre><code>Get-TransportRule -Identity 'domain block' | 
 select-Object -ExpandProperty SenderDomainIs | 
 Foreach {
 [pscustomobject]@{'Domain' = $_}
 } | Export-Csv c:\temp\domains.csv -notype
</code></pre>
CSV contents
<pre><code>get-content C:\temp\domains.csv

&quot;Domain&quot;
&quot;chess.com&quot;
&quot;jen.com&quot;
&quot;bob.com&quot;
&quot;joe.com&quot;
&quot;irish.com&quot;
&quot;ND.com&quot;
&quot;goirish.com&quot;
&quot;fieldnotes.com&quot;
</code></pre>

blocks|key|3841437|text|按如下方式导出：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3841438|$currentdomains+%7C+
++++ForEach-Object+{+return+[PSCustomObject]@{Domain+=+$_}}+%7C+
++++Export-Csv+...|code-block|syntax|javascript|3841439|3841440|说明：Export-Csv导出对象的属性，而不是对象本身。|offset|length|style|CODE|3841441|因为您的$currentdomains是System.String的列表，而System.String只包含Length属性，所以会将其导出。|3841442|因此，要导出字符串值，您必须导出一些对象，这些对象具有属性Domain+(或您想要任何其他属性)，并且该属性的值是感兴趣的字符串。|3841443|在PowerShell中创建此对象的最简单方法是使用从System.Hashtable+(也称为键值集合@{+})到PSCustomObject的转换。键成为PSCustomObject的属性，值成为它的属性的值。|BOLD|3841444|因此，使用ForEach-Object+{+return+[PSCustomObject]@{Domain+=+$_}}将字符串包装到PSCustomObject对象中，该对象具有单个(在其他情况下可能是多个)属性Domain。|3841445|Export-Csv枚举PSCustomObject的属性，根据它们的名称创建列(在本例中，您只有Domain属性，所以CSV中只有一个列Domain+)，并且作为一个值，它使用属性的.ToString()方法。|3841446|您的Domain属性的类型为System.String，因此System.String::ToString()返回string本身。|3841447|3841448|另一种方式：|3841449|(Get-TransportRule+"domain+block")+%7C+
++++ForEach-Object+{+return+[PSCustomObject]@{Domain+=+$_.SenderDomainIs}}+%7C+
++++Export-Csv+...|3841450|3841451|3841452|(Get-TransportRule+"domain+block")+%7C+
++++Select-Object+-Property+@(+
++++++++@{+
++++++++++++Label+=+'Domain'
++++++++++++Expression+=+{+return+$_.SenderDomainIs+}
++++++++},
++++++++'SenderDomainIs'+#+This+line+is+for+example:
++++++++#+There+can+be+other+properties+from+Get-TransportRule,+by+their+name,+like+"SenderDomainIs"+or+by+Label-Expression+conversion
++++++++)+%7C+
++++Export-Csv+...|3841453|entityMap^0|0|0|0|3|A|0|4|F|K|D|12|D|1I|6|0|T|6|0|R|G|1M|E|27|E|1G|4|0|5|1J|1V|E|2Z|6|0|C|E|1D|6|1X|6|2K|B|0|2|6|E|D|U|P|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1C|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1E|8|@$J|1F|K|1G|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1H|8|@$J|1I|K|1J|L|M]|$J|1K|K|1L|L|M]|$J|1M|K|1N|L|M]|$J|1O|K|1P|L|M]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1Q|8|@$J|1R|K|1S|L|M]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1T|8|@$J|1U|K|1V|L|M]|$J|1W|K|1X|L|M]|$J|1Y|K|1Z|L|M]|$J|20|K|21|L|T]]|9|@]|A|$]]|$1|U|3|V|5|6|7|22|8|@$J|23|K|24|L|M]|$J|25|K|26|L|M]|$J|27|K|28|L|M]]|9|@]|A|$]]|$1|W|3|X|5|6|7|29|8|@$J|2A|K|2B|L|M]|$J|2C|K|2D|L|M]|$J|2E|K|2F|L|M]|$J|2G|K|2H|L|M]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|2I|8|@$J|2J|K|2K|L|M]|$J|2L|K|2M|L|M]|$J|2N|K|2O|L|M]]|9|@]|A|$]]|$1|10|3|-4|5|6|7|2P|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|2Q|8|@]|9|@]|A|$]]|$1|13|3|14|5|D|7|2R|8|@]|9|@]|A|$E|F]]|$1|15|3|-4|5|6|7|2S|8|@]|9|@]|A|$]]|$1|16|3|12|5|6|7|2T|8|@]|9|@]|A|$]]|$1|17|3|18|5|D|7|2U|8|@]|9|@]|A|$E|F]]|$1|19|3|-4|5|6|7|2V|8|@]|9|@]|A|$]]]|1A|$]]

Export like this:
<pre><code>$currentdomains | 
 ForEach-Object { return [PSCustomObject]@{Domain = $_}} | 
 Export-Csv ...
</code></pre>
<hr>
Explanation: <code>Export-Csv</code> exports object's properties, not objects itself. 
Because your <code>$currentdomains</code> is list of <code>System.String</code>s, and <code>System.String</code> contains only <code>Length</code> property, it is exported.
So, to export string value, you must export some object, which have property <code>Domain</code> (or anything else you want) and value of this property is string of interest.
The easiest way to create this object in PowerShell is to use covretion from <code>System.Hashtable</code> (also known as key-value collection @{ }) to <code>PSCustomObject</code>. Keys become properties of <code>PSCustomObject</code> and Values become values of it's properties.
So, with <code>ForEach-Object { return [PSCustomObject]@{Domain = $_}}</code> you wrap your string into <code>PSCustomObject</code> object, which gives you Object with single (maybe multiple in other case) property <code>Domain</code>.
Export-Csv enumerates properties of <code>PSCustomObject</code>, creates columns from their names (in this case you have only <code>Domain</code> property, so only one column <code>Domain</code> will be in CSV) and as a value, it uses property's <code>.ToString()</code> method.
Your <code>Domain</code> property has a type <code>System.String</code>, so <code>System.String::ToString()</code> returns string itself.
<hr>
Alternative way:
<pre><code>(Get-TransportRule &quot;domain block&quot;) | 
 ForEach-Object { return [PSCustomObject]@{Domain = $_.SenderDomainIs}} | 
 Export-Csv ...
</code></pre>
<hr>
Alternative way:
<pre><code>(Get-TransportRule &quot;domain block&quot;) | 
 Select-Object -Property @( 
 @{ 
 Label = 'Domain'
 Expression = { return $_.SenderDomainIs }
 },
 'SenderDomainIs' # This line is for example:
 # There can be other properties from Get-TransportRule, by their name, like &quot;SenderDomainIs&quot; or by Label-Expression conversion
 ) | 
 Export-Csv ...
</code></pre>

I am exporting domains in a transport rule and the output does not contain a header so it does not export to CSV properly.
Trying this code:
<pre><code>$CurrentDomains = (Get-TransportRule &quot;domain block&quot;).SenderDomainIs
</code></pre>
This outputs:
<pre><code>PS C:\Users\user&gt; $CurrentDomains
chess.com
jen.com
bob.com
joe.com
irish.com
ND.com
goirish.com
fieldnotes.com
</code></pre>
As you see there is no &quot;title&quot; so when i run an export-csv it just shows up as numbers:
<pre><code>$currentdomains | export-csv c:\temp\domains.csv -notype
</code></pre>
The output of the CSV looks like this:
<pre><code>Length
9
7
7
7
7
9
6
11
14
</code></pre>
I need the output to look like this with Domain as the header:
<pre><code>Domain
chess.com
domain2.com
domain3.com
domain4.com
fieldnotes.com
goirish.com
mydomain.com
</code></pre>
How do I make that happen?

Adding header for CSV file

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在导出传输规则中的域，但输出不包含报头，因此无法正确导出为CSV。尝试以下代码：$CurrentDomains = (Get-TransportRule "domain block").SenderDomainIs这将输出以下内容：PS C:\Users\user> $CurrentDomainschess.com...

问正在为CSV文件添加标头
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问正在为CSV文件添加标头EN