powershell create txt files based on csv file

Question

I have csv file with list of filepaths:

Filename 
C:\Users\postgres\1.tmp 
C:\Users\postgres222\2.txt
C:\Users\postgres3333\3.jpeg

I would like to loop through that list and to create in the same directory txt file per every file with below information: Today's date Filepath Name of file

so in example for 1st file it should be file C:\Users\postgres\1.tmp.txt with data:

03\11\2021
C:\Users\postgres\1.tmp 
1.tmp

I tried:

$Time=Get-date
$data = "\mydir"
foreach($file in Get-ChildItem $data){New-Item -ItemType file -Path $Get-Item $file.Fullpath + ".txt" -Value $Time Add-Content $Get-Item $file.Fullpath}

Show us what you've tried.

marsze
– marsze

2021-11-03 13:01:02 +00:00
Commented Nov 3, 2021 at 13:01 — marsze
– marsze, Commented Nov 3, 2021 at 13:01
updated original

johnt
– johnt

2021-11-03 13:22:36 +00:00
Commented Nov 3, 2021 at 13:22 — johnt
– johnt, Commented Nov 3, 2021 at 13:22

Theo · Accepted Answer · 2021-11-03 13:24:23Z

2

Just use Import-Csv on the input file and loop through the data with ForEach-Object.
Inside the loop, split the fullname into the path and the filename only:

$today = '{0:dd\\MM\\yyyy}' -f (Get-Date)
(Import-Csv -Path 'X:\Path\Folder\Input.csv').Filename | ForEach-Object {
    $path = [System.IO.Path]::GetDirectoryName($_)   # or use: Split-Path $_ -Parent
    $file = [System.IO.Path]::GetFileName($_)        # or use: Split-Path $_ -Leaf
    # create the full path and filename for the output
    $out  = Join-Path -Path $path -ChildPath ('{0}.txt' -f $file)
    # construct the three lines and write the file
    "$today`r`n$_`r`n$file" | Set-Content -Path $out
}

answered Nov 3, 2021 at 13:24

Theo

61.9k8 gold badges28 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

powershell create txt files based on csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related