可以将Import-Csv cmdlet与-Header参数沿着使用，以指定标头名称。由于CSV文件没有标题，因此可以提供虚拟标题名称。然后，您可以通过引用相应的标题和行来访问单元格值。
你可以这样做：

# Define the path to the CSV file and dummy header name
$csvFilePath = "path\to\your\file.csv"
$headerName = "Header"

# Import the CSV file with the dummy header

$data = Import-Csv -Path $csvFilePath -Header $headerName

# Get the value from cell A2

$value = $data | Where-Object { $_.PSObject.Properties.Name -eq 
$headerName } | Select-Object -ExpandProperty $headerName

# Extract the date from the value (assuming it's always at the end of the string)

$date = $value.Substring($value.LastIndexOf(":") + 2).Trim()

# Reformat the date to YY-MM-DD

$formattedDate = Get-Date $date -Format "yy-MM-dd"

# Output the result

Write-Output $formattedDate

字符串

我无法让@RarikmilkraiSouza脚本工作，但它确实帮助我弄清楚我需要去哪里。这是我最终得到的，它做了我需要的：

# Define the path to the CSV file and dummy header name
$csvFilePath = "C:\testfile.csv"
$headerName = "ColumnA"

# Import the CSV file with the dummy header

$data = Import-Csv -Path $csvFilePath -Header $headerName

# Get the value from cell A2

$value = $data[1].'ColumnA'

# Extract the date from the value and reformat to YY-MM-DD

$rptdate = $value -replace 'RPT Date :(\d{2})/(\d{2})/(\d{2})','$3-$1-$2'
$formattedDate = "20" + $rptdate

# Output the result

Write-Output $formattedDate

字符串