René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"The last cell of an empty column read by `ConvertFrom-Csv` is inconsistently `$Null`","articleBody":"If the last cell of *an unquoted* `Csv` file is empty, the cmdlets `ConvertFrom-Csv` and `Import-Csv` inconsistently returns a `$Null` rather than am empty string.\r\n\r\n### Steps to reproduce\r\n\r\n```PowerShell\r\n$Data = ConvertFrom-Csv @'\r\nId,Name,Note\r\n01,John,\r\n02,Jack,\r\n03,Ryan,Just a note\r\n04,Luke,\r\n05,Noah,\r\n'@\r\n\r\n$Data.Note.ForEach{ if ($Null -eq $_) { 'Null' } else { 'String' } }\r\n```\r\n\r\n### Expected behavior\r\n\r\n```console\r\nString\r\nString\r\nString\r\nString\r\nString\r\n```\r\n\r\n\r\n### Actual behavior\r\n\r\n```console\r\nString\r\nString\r\nString\r\nString\r\nNull\r\n```\r\n\r\nAs shown above all other cells in the above `Note` column are interpreted as string, except for the last cell with appears to be `$Null`. This would have been correct if the last comma was omitted but that is not the case.\r\n\r\n\r\n### Error details\r\n\r\n_No response_\r\n\r\n### Environment data\r\n\r\n```powershell\r\nName                           Value\r\n----                           -----\r\nPSVersion                      7.2.5\r\nPSEdition                      Core\r\nGitCommitId                    7.2.5\r\nOS                             Microsoft Windows 10.0.22000\r\nPlatform                       Win32NT\r\nPSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}\r\nPSRemotingProtocolVersion      2.3\r\nSerializationVersion           1.1.0.1\r\nWSManStackVersion              3.0\r\n```\r\n\r\nSee also: [how to filter empty values in a column in powershell](https://stackoverflow.com/questions/75659764/how-to-filter-empty-values-in-a-column-in-powershell)","author":{"url":"https://github.com/iRon7","@type":"Person","name":"iRon7"},"datePublished":"2022-07-18T10:22:14.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":21},"url":"https://github.com/17702/PowerShell/issues/17702"}