René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"`Export-Csv` / `ConvertTo-Csv`: Stringification of array-valued property values depends on whether they happen to be `[psobject]`-wrapped","articleBody":"### Prerequisites\r\n\r\n- [X] Write a descriptive title.\r\n- [X] Make sure you are able to repro it on the [latest released version](https://github.com/PowerShell/PowerShell/releases)\r\n- [X] Search the existing issues.\r\n- [X] Refer to the [FAQ](https://github.com/PowerShell/PowerShell/blob/master/docs/FAQ.md).\r\n- [X] Refer to [Differences between Windows PowerShell 5.1 and PowerShell](https://learn.microsoft.com/powershell/scripting/whats-new/differences-from-windows-powershell).\r\n\r\n### Steps to reproduce\r\n\r\nNote:\r\n* Arguably, the stringification of an incidentally `[psobject]`-wrapped value makes _more_ sense.\r\n  * See also: #20383\r\n* Ultimately, this is yet another manifestation of #5579 in that the way in which the calculated property's value is created involves an incidental (and otherwise invisible) `[psobject]` wrapper.\r\n\r\n```powershell\r\n\u0026 {\r\n  [psobject]::new() | Select-Object @{Name = \"Groups\"; Expression = { 'a', 'b', 'c' } } \r\n  [pscustomobject] @{ Groups = 'a', 'b', 'c' }\r\n} | ConvertTo-Csv\r\n```\r\n\r\n\r\n### Expected behavior\r\n\r\n```console\r\n\"Groups\"\r\n\"a b c\"\r\n\"a b c\"\r\n```\r\n\r\n\r\n### Actual behavior\r\n\r\n```console\r\n\"Groups\"\r\n\"a b c\"\r\n\"System.Object[]\"\r\n```\r\n\r\nThat is, without the incidental `[psobject]` wrapper, simple `.ToString()` stringification was applied.\r\n\r\n### Error details\r\n\r\n_No response_\r\n\r\n### Environment data\r\n\r\n```powershell\r\nPowerShell 7.4.0-preview.6\r\n```\r\n\r\n\r\n### Visuals\r\n\r\n_No response_","author":{"url":"https://github.com/mklement0","@type":"Person","name":"mklement0"},"datePublished":"2023-10-06T22:00:48.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/20450/PowerShell/issues/20450"}