Convert Upper case to Lower Case on CSV content through PowerShell
Hello, I tried following PowerShell script and it work well but some how it convert whole string from Upper to lower. i need to keep first letter of string as upper , do not want to cover as lower for first letter. $a = "E:\User\Staff\cims" $b = (get-content "$a\staff.csv" -raw) (("$b").ToLower()).trim(" ") -split (",,") | Out-File -FilePath E:\User\Staff\cims\staff1.csv -Encoding UTF8 | Get-Process | Out-Host -Paging| Format-Table -wrap -Property Emp,LastFirst,Last,First,email.title,location Thank you