I need to read a column in Excel file and search for that file in shared directory.
Example:
File.csv:
10099
20099
93099
You have to search for file name with 10099 and so on and need the path of the file as output.
Asked
Active
Viewed 67 times
-1
Community
- 1
- 1
user2834105
- 67
- 1
- 1
- 9
-
SO is not a code-writing service. Please show us what you've tried and explain how the actual results were different from what you expected. – Ansgar Wiechers Mar 24 '15 at 11:37
1 Answers
0
for read column excell via powershell read this links
link1
linke2
this simple script for find particular name in all partitions
$name = Read-Host "which name you want find"
Get-PSDrive | where { $_.Provider -match "FileSystem"} | select Root | foreach { Get-ChildItem $_.Root -Recurse -Name $name -ErrorAction 'SilentlyContinue' }
You can change script if you want don't ask user for file name
-
Is there a any way i can do it for more than 1000 file names through a batch ?? – user2834105 Mar 24 '15 at 10:27
-
do you want 1000 file name find just in once script run ?check this `"name1","name2","name3" | foreach { get-childitem -filter $_}` – Soheil Mar 24 '15 at 10:36
-
Yeah , may be i can put it in a text file and the script will read it and give the path of files – user2834105 Mar 24 '15 at 10:42
-