Getting “System.Collections.Generic.List`1[System.String]” in CSV File export when data is okay on screen

by

If an object you export as CSV with Export-Csv or ConvertTo-Csv has property values that contain a collection (array) of values, these values are stringified via their .ToString() method, which results in an unhelpful representation, as in the case of your array-valued .IPV4Addresses property.

To demonstrate this with the ConvertTo-Csv cmdlet (which works analogously to Export-Csv, but returns the CSV data instead of saving it to a file):

PS> [pscustomobject] @{ col1 = 1; col2 = 2, 3 } | ConvertTo-Csv
"col1","col2"
"1","System.Object[]"

That is, the array 2, 3 stored in the .col2 property was unhelpfully stringified as System.Object[], which is what you get when you call .ToString() on a regular PowerShell array; other .NET collection types – such as [System.Collections.Generic.List[string]] in your case – stringify analogously; that is, by their type name.

Assuming you want to represent all values of an array-valued property in a single CSV column, to fix this problem you must decide on a meaningful string representation for the collection as a whole and implement it using Select-Object with a calculated property:

E.g., you can use the -join operator to create a space-separated list of the elements:

PS> [pscustomobject] @{ col1 = 1; col2 = 2, 3 } | 
      Select-Object col1, @{ n='col2'; e={ $_.col2 -join ' ' } } |
        ConvertTo-Csv
"col1","col2"
"1","2 3"

Note how array 2, 3 was turned into string '2 3'.

More Related Contents:

  1. Not all properties displayed
  2. Select the values of one property on all objects of an array in PowerShell
  3. Comparing two arrays & get the values which are not common
  4. Objects with no ‘.Count’ Property – use of @() (array subexpression operator) vs. [Array] cast
  5. Get-ChildItem.Length is Wrong
  6. Array.Add vs +=
  7. How do I pass an array as a parameter to another script?
  8. Spark 2.0.x dump a csv file from a dataframe containing one array of type string
  9. Pipe complete array-objects instead of array items one at a time?
  10. PowerShell copy an array completely
  11. A cmdlet which returns multiple objects, what collection type is it, if any? [PowerShell]
  12. How to add hashtable to multidimensional array? Cannot assign values via member-access enumeration
  13. Data Rows to String to Array issue
  14. Create a Single-Element Json Array Object Using PowerShell
  15. Powershell: Piping output of pracl command to array
  16. Return Multidimensional Array From Function
  17. PowerShell array initialization
  18. How do I call New-Object for a constructor which takes a single array parameter?
  19. Why is a leading comma required when creating an array?
  20. PowerShell doesn’t return an empty array as an array
  21. PS Script is exporting an empty CSVs
  22. How do I create array of arrays in PowerShell?
  23. MongoDB: How do I update a single subelement in an array, referenced by the index within the array?
  24. Algorithm to find k smallest numbers in array of n items
  25. How to remove all quotations mark in the csv file using powershell script?
  26. Algorithm to rotate an array in linear time
  27. Using jsonb_set() for updating specific jsonb array value
  28. JavaScript array to CSV
  29. In a CUDA kernel, how do I store an array in “local thread memory”?
  30. How do I remove an array item in TypeScript?

Leave a Comment