asked on How to move files with specific text in filename
Hi, 2 basic questions regarding powershell:
1. How can I use powershell to move all files in 1 folder that have "_CLM_" in the file name (on network server)
2. How can I use powershell to move a csv list of files from 1 directory to another? (if they are in different folders within 1 directory... and also on a network server)
1. How can I use powershell to move all files in 1 folder that have "_CLM_" in the file name (on network server)
2. How can I use powershell to move a csv list of files from 1 directory to another? (if they are in different folders within 1 directory... and also on a network server)
Powershell
Last Comment
Brent Guttmann
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi, when I tried testing this, after I pasted the code into powershell and pressed enter it just went to the next line, which read ">>" and thats it.... nothing happened. What am I doing wrong?
import-csv c:\temp\filelist.csv | foreach {move-item $_.filename -destination C:\Temp\test\
import-csv c:\temp\filelist.csv | foreach {move-item $_.filename -destination C:\Temp\test\
import-csv c:\temp\filelist.csv | foreach {move-item $_.filename -destination C:\Temp\test\ }
ASKER
whoops! haha, thanks for your help
Open in new window
2. The basic command to read a csv file is "Import-Csv -Path C:\Temp\SomeFile.csv"; this will get you an array of objects with the column names as properties, provided the csv file has a header line. If it doesn't, you need to provide the -Header argument to let PS know about the column names.
It's unclear what you want to do - does the csv file have a source and target column for each individual file, or just a source and you want all files to go under a common target location? And if the latter, do you want to "flatten" the source subfolder structure (and if so, what is supposed to happen with duplicate names), or keep it in the target?