ABAP2XLSX.Operator.ps1

#-Begin-----------------------------------------------------------------

  $PrefixNew = "/MNS/MPA"

  $XMLFileName = "ABAP2XLSX_V_7_0_6.nugg"
  $XMLFileNameNew = $XMLFileName + ".new"
  $CSVFileName = $XMLFileName + ".csv"
  $CSVFile = Import-Csv -Path $CSVFileName -Delimiter ";"
  [String]$XMLFile = (Get-Content -Path $XMLFileName -Encoding UTF8) -Join "'r'n"
  $XMLFile = $XMLFile.Replace("`$TMP", $PrefixNew)
  $CSVFile | ForEach-Object {
    $OldName = $_.OldName; $NewName = $_.NewName
    Write-Host $OldName " > " $NewName
    if ($XMLFile.ToUpper().Contains("_" + $OldName.ToUpper()) -eq $True) {
      [String[]]$XML = $XMLFile -Split "'r'n"
      For($i = 0; $i -le $XML.Count - 1; $i++) {
        if ($XML[$i].ToUpper().Contains("_" + $OldName.ToUpper()) -eq $False) {
          $XML[$i] = $XML[$i] -ireplace $OldName, $NewName
        }
        else {
          Write-Host "Check line " $($i + 1)
        }
      }
      $XMLFile = $XML -Join "'r'n"
    }
    else {
      $XMLFile = $XMLFile -ireplace $OldName, $NewName
    }
  }
  Set-Content -Path $XMLFileNameNew -Value $XMLFile.Replace("'r'n", "$([char]0x0D)$([char]0x0A)") -Encoding UTF8

#-End-------------------------------------------------------------------