检查csv中是否有空白字段,如果存在空白则写入输出 [英] check csv for blank fields and write output if exist blank
本文介绍了检查csv中是否有空白字段,如果存在空白则写入输出的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是一个csv示例:
1- 2018-11-07,hostname-184,IP_INFO, 10.2334.40.334, 255.255.255.0,
2 - 2018-11-07,hostname-184,IP_INFO, 334.204.334.68, 255.255.255.0,
3- 2018-11-07,hostname,7.1.79-8,IP_INFO, 142.334.89.3342, 255.255.255.0,
4- 2018-11-07,hostname,7.1.80-7,IP_INFO, 13342.221.334.87, 255.255.255.0,
5- 2018-11-07,hostname-155,IP_INFO, 142.2334.92.212, 255.255.255.0,
6 - 2018-11-07,hostname-184,IP_INFO, , , 1
7- 2018-11-07,hostname-184,IP_INFO, 10.19334.60.3343, 255.255.255.0,
那么我如何检查两个空格是否为空白(如第6行)?
so how can i check if the las two spaces are in blank (like line 6 ) ?
想法是使用这样的东西:
The idea is to use something like this:
$contentdnsparsed = Get-Content $destination_RAW_NAS\DNS_NAS_PARSED_0
For($i=0;$i -lt $contentdnsparsed.count;$i++){
if($contentdnsparsed[$i] -match "running")
{
$Global:MatchDNS = $OK } Else {$Global:MatchDNS = $FAIL }
}
如果在,"之后的空格4和5中匹配某物",则输出=确定,否则=失败.
If match "something" in the space 4 and 5 after the "," output = OK else = FAIL.
谢谢你们
推荐答案
尽管您为我们提供了一个非常糟糕的CSV文件示例,但您应该使用Import-Csv
cmdlet.
由于csv没有标题,因此您需要为它们提供-Header
参数,如下所示:
Although you give us a rather bad example of a CSV file, you should use the Import-Csv
cmdlet.
Because the csv has no headers, you need to supply these with the -Header
parameter like below:
$csvContent = Import-Csv -Path "$destination_RAW_NAS\DNS_NAS_PARSED_0" -Header @("Date","HostName", "InfoType","IPAddress","Subnet")
$csvContent | ForEach-Object {
# test for empty IPAddress fields in the CSV
if ([string]::IsNullOrEmpty($_.IPAddress)) {
Write-Host "$($_.HostName) = FAIL" -ForegroundColor Red
# somewhere in your code you have declared the variables $Global:MatchDNS, $FAIL and $OK I guess..
$Global:MatchDNS = $FAIL
}
else {
Write-Host "$($_.HostName) = OK" -ForegroundColor Green
$Global:MatchDNS = $OK
}
}
希望有帮助
这篇关于检查csv中是否有空白字段,如果存在空白则写入输出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文