Manipulate CSV value without knowing column names

Asked Nov 07 '17 at 08:48

Active Nov 07 '17 at 08:59

Viewed 101 times

My script has to read in a CSV file and search for any value (other than the headers) which contains string longer than specific characters, and cut out the exceeding characters if found. And then write the whole data back as CSV file using Export-Csv again, with headers preserved. Input CSV files are all well-formed, with headers, however header names are variant among files and therefore cannot be determined in advance.

So far all Import-Csv relevant code samples/solutions I google'd need known column names, such as:

Import-Csv "file1.csv" | ForEach-Object {
  if ($_.aKnownColumnName -eq "someCondition") { doSomething() }
}

Is there a way to deal with my requirement above?

edited Nov 07 '17 at 08:59

Ansgar Wiechers

193,178
25
254
328

asked Nov 07 '17 at 08:48

Jyunhao Shih

1,287
2
8
9

To clarify - You want to trim any value in any column if it is longer than some length, unless it is a column header? – arco444 Nov 07 '17 at 08:55
@Snak3d0c Number of columns might change over time. – Jyunhao Shih Nov 07 '17 at 09:00
Note that for passing the current object downstream the pipeline you need to output it in the `ForEach-Object` loop. A line with just `$_` at the end of the loop will suffice for that. – Ansgar Wiechers Nov 07 '17 at 09:01
`((ipcsv '.\file.csv')[0].PSObject.Properties).Name` – colsw Nov 07 '17 at 10:15

Manipulate CSV value without knowing column names

0 Answers0