我在读一个CSV 的电动外壳脚本。 脚本拉出具体的数据, 然后写到不同的 CSV 。 是否有一种方法我可以用“ 无效” 一词来取代任何“ ” 值?
我认为这应该给你一些东西 开始用...
@
Foo,Bar
"",""
Alfa,Beta
Gamma,""
"",Delta
@ | ConvertFrom-csv | Foreach-Object {
foreach ($Property in $_.PSObject.Properties) {
if ([string]::IsNullOrEmpty($Property.Value)) {
$_.($Property.Name) = NULL
}
}
$_
} | ConvertTo-Csv -NoTypeInformation
您 可以尝试 尝试将“ ” 替换为“ NULL ”, 但如果您有更复杂的数据, 它可能会给您一些意外的结果, 在 PSObject 上工作 。 Propers 收藏没有这样的瑕疵/ 风险 。
I ve been working on this simple code that puts a CSV file into a nice table. But because the data is imported, styling ODD rows is a pretty hard thing to do. All I need would be a method to address ...
What would be the most efficient way to clean a user input that is a comma separated string made entirely on numbers - e.g 2,40,23,11,55 I use this function on a lot of my inputs function clean($...
Below is the sample csv file date,type1,type2,..... 2009-07-01,n1,n2,..... 2009-07-02,n21,n22,.... and so on... I want to add the values in each row and each column and print at the end and bottom ...
I am getting this sort of CSV data while making Http request to the CSV file. Very malformed string. response = "Subject";"Start Date";"Start Time";"End Date";"End Time";"All day event";"...
I m stumped with a problem illustrated in the sample below: "ID","NAME","PHONE","REF","DISCARD" 1,"JOHN",12345,, 2,"PETER",6232,, 3,"JON",12345,, 4,"PETERSON",6232,, 5,"ALEX",7854,, 6,"JON",12345,, ...
I’m at a very basic level with Flex and with programming in general. I am working on a project where I have data in an Excel (.csv) format, it’s a large Excel plot/matrix where each cell has a ...
I have some text file like this, with several 5000 lines: 5.6 4.5 6.8 "6.5" (new line) 5.4 8.3 1.2 "9.3" (new line) so the last term is a number between double quotes. What I want to do is, ...
Is there a PHP string function that transforms a multi-line string into a single-line string? I m getting some data back from an API that contains multiple lines. For example: <p>Some Data</...