Convert Case - Convert upper case to lower case in specific csv column

user_13279207 0
Viewed 594

I need help to convert all values from specific csv column (Name) into lower case, using powershell script.

    Change ID       Name                ITSM_Info
183115          ZYXjjjKKK           Possible CRQ
183115          ZYXasdasdj          Possible CRQ
183115          ZYsdajjKKK          Possible CRQ
183115          ZYXjjjKKK           Possible CRQ
183115          abcjKKK             Possible CRQ
183115          ZY1222KKK           Possible CRQ
186081          ZY123qwerK          Possible CRQ

Expected output

  Change ID     Name                ITSM_Info
    183115          zyxjjjkkk           Possible CRQ
    183115          zyxasdasdj          Possible CRQ
    183115          zysdajjkkk          Possible CRQ
    183115          zyxjjjkkk           Possible CRQ
    183115          abcjkkk             Possible CRQ
    183115          zy1222kkk           Possible CRQ
    186081          zy123qwerk          Possible CRQ

Thank you for support.

powershell
2 Answers

The CSV values are all read in as strings by Import-Csv, and [string] already has a ToLower() method we can use for this!

$lowerCased = Import-Csv .\path\to.csv |ForEach-Object {
  $_.Name = $_.Name.ToLower()
  $_
}
user_7126490

This is work for me, 

$lower = Import-Csv "D:\CRQ.csv"  -Delimiter ';' 
$lower | ForEach-Object { 

                      $_.'Name' = $_.Name.ToLower()

     } 
$lower | 
Export-Csv -Path "D:\CRQ_tmp.csv" -Delimiter ';' -NoTypeInformation
user_132792070
Related