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

Question

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.

Answer 1

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()
  $_
}