在Powershell Script中,如何将'%5c'分隔的CSV文件转换为'/'分隔的CSV文件? [英] In Powershell Script, how to convert '%5c' delimted CSV file to '/' delimited CSV file?
本文介绍了在Powershell Script中,如何将'%5c'分隔的CSV文件转换为'/'分隔的CSV文件?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我写了一个powershell脚本来重温NAME& VM的路径(virtula机器)并将它们保存在CSV文件中,但是当有' / '时它显示为'%5c '我不知道它为什么显示像这样,我不知道如何更改它。
这是我的powershell代码:
功能Get-Path {
param($ Object)
$ path = $ object.Name
$ parent = Get-View $ Object.ExtensionData.ResourcePool
while($ parent){
$ path = $ parent.Name + / + $ path
if($ parent.Parent){
$ parent = Get-View $ parent.Parent
}
else {$ parent = $ null}
}
$ path
}
Get-VM`
|选择名称,@ {N = 路径; E = {(Get-Path -Object $ _ )-replace ^。*?资源}}`
| ConvertTo-Csv -NoTypeInformation`
| Select-Object -Skip 1 `
| Set-Content -Path C:\\\azaz \ test.csv
解决方案
对象)
< span class =code-sdkkeyword>
path =
object.Name
I wrote a powershell script to retrive NAME & PATH of VM's(virtula machine) and save them in CSV file, But when ever there is '/' it displays as '%5c' i have no idea why its showing like that and I dont know how to change it.
Here is my powershell CODE:
function Get-Path{
param($Object)
$path = $object.Name
$parent = Get-View $Object.ExtensionData.ResourcePool
while($parent){
$path = $parent.Name + "/" + $path
if($parent.Parent){
$parent = Get-View $parent.Parent
}
else{$parent = $null}
}
$path
}
Get-VM `
| Select Name, @{N="Path";E={(Get-Path -Object $_) -replace "^.*?Resources"}} `
| ConvertTo-Csv -NoTypeInformation `
| Select-Object -Skip 1 `
| Set-Content -Path C:\izaz\test.csv
解决方案
Object)
path =
object.Name
这篇关于在Powershell Script中,如何将'%5c'分隔的CSV文件转换为'/'分隔的CSV文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文