Powershell Split File Name And Export To Csv

Contents hide

1 Powershell split file name and export to csv

Problem Description:

I have lot of files in the folder in this nameing format "yyyy-mm-dd_Discription_$Amount.pdf" , how do I make powershell script that creates csv file with three columns (Date , Description and Amount)?

I am able to extract the full file name in the below, but I need help to split and make columns.

$Directory = "C:path to directory"
Get-ChildItem -Path $Directory -Recurse -Force | ForEach {

    [PSCustomObject]@{                 
        Name = $_.BaseName          
    }
    
} | Export-Csv -Path "./temp.csv" -NoTypeInformation

I have tried this below

$Directory = "C:path to directory"
Get-ChildItem -Path $Directory -Recurse -Force | ForEach {

    [PSCustomObject]@{                 
        Name = $_.BaseName          
    }
    
} | Export-Csv -Path "./temp.csv" -NoTypeInformation

Solution – 1

This will work

$Directory = '.'

(Get-ChildItem -Path $Directory -File).BaseName | Select `
    @{l='Date'; e={$_.Split('_')[0]}},
    @{l='Description'; e={$_.Split('_')[1]}},
    @{l='Amount'; e={$_.Split('_')[2]}} |
        ConvertTo-Csv -NoTypeInformation

Rate this post