A requirement came up for me to copy thousands of file to another drive with directories named depending on part of the file name. \u00c2\u00a0The file name has _ on it and every time there is an _ a subdirectory needs to be created . For example :<\/p>\n
if the file name is :<\/p>\n
C:\\query\\ RCP_DEV_orderlookup.sql \u00c2\u00a0 needs to be copied to D:\\query\\RCP\\DEV\\orderlookup.sql<\/p>\n
C:\\query \\RCP_PROD_orderlookup.sql \u00c2\u00a0 needs to be copied to D:\\query\\RCP\\PROD\\orderlookup.sql<\/p>\n
and so on<\/p>\n
First I thought of writing a script in perl, but since it was in a windows system , I decided to write it in powershell. \u00c2\u00a0I am fascinated with the power of powershell !<\/p>\n
Here is the script I wrote to accomplish that :<\/p>\n
$SourceFolder<\/span>\u00c2\u00a0=<\/span>\u00c2\u00a0“C:\\query\\”<\/span> clear-host<\/span>; As always test it before you implement it on your system.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" A requirement came up for me to copy thousands of file to another drive with directories named depending on part of the file name. \u00c2\u00a0The file name has _ on it and every time there is an _ a subdirectory needs to be created . For example : if the file name is : C:\\query\\ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[358,1],"tags":[876,878,881,875,880,879,877],"class_list":["post-1425","post","type-post","status-publish","format-standard","hentry","category-how-to","category-misc","tag-copy-files","tag-get-childitem","tag-new-item","tag-powershell","tag-read-host","tag-write-progress","tag-write-host"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1425"}],"version-history":[{"count":3,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1425\/revisions"}],"predecessor-version":[{"id":1428,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1425\/revisions\/1428"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n$targetFolder<\/span>\u00c2\u00a0=<\/span>\u00c2\u00a0“D:\\query\\”<\/span>
\n$numFiles<\/span>\u00c2\u00a0=<\/span>\u00c2\u00a0(Get-ChildItem<\/span>\u00c2\u00a0-Path<\/span>\u00c2\u00a0$SourceFolder<\/span>\u00c2\u00a0-Filter<\/span>\u00c2\u00a0*.TXT<\/span>).<\/span>Count
\n$i<\/span>=0<\/span><\/span><\/p>\n
\nWrite-Host<\/span>\u00c2\u00a0‘This script will copy ‘<\/span>\u00c2\u00a0$numFiles<\/span>\u00c2\u00a0‘ files from ‘<\/span>\u00c2\u00a0$SourceFolder<\/span>\u00c2\u00a0‘ to ‘<\/span>\u00c2\u00a0$targetFolder<\/span>
\nRead-host<\/span>\u00c2\u00a0-prompt<\/span>\u00c2\u00a0‘Press enter to start copying the files’<\/span>
\nGet-ChildItem<\/span>\u00c2\u00a0-Path<\/span>\u00c2\u00a0$SourceFolder<\/span>\u00c2\u00a0-Filter<\/span>\u00c2\u00a0*.TXT<\/span>\u00c2\u00a0|<\/span>\u00c2\u00a0%<\/span>{\u00c2\u00a0<\/span>
\n\u00c2\u00a0 \u00c2\u00a0\u00c2\u00a0[<\/span>System.IO.FileInfo<\/span>]<\/span>$destination<\/span>\u00c2\u00a0=<\/span>\u00c2\u00a0(Join-Path<\/span>\u00c2\u00a0-Path<\/span>\u00c2\u00a0$targetFolder<\/span>\u00c2\u00a0-ChildPath<\/span>\u00c2\u00a0$_<\/span>.<\/span>Name.<\/span>replace(“_”<\/span>,<\/span>“\\”<\/span>))\u00c2\u00a0<\/span>
\n\u00c2\u00a0 \u00c2\u00a0\u00c2\u00a0<\/span>
\n\u00c2\u00a0 \u00c2\u00a0if<\/span>(!<\/span>(Test-Path<\/span>\u00c2\u00a0-Path<\/span>\u00c2\u00a0$destination<\/span>.<\/span>Directory )){\u00c2\u00a0<\/span>
\n\u00c2\u00a0 \u00c2\u00a0\u00c2\u00a0New-item<\/span>\u00c2\u00a0-Path<\/span>\u00c2\u00a0$destination<\/span>.<\/span>Directory.<\/span>FullName\u00c2\u00a0-ItemType<\/span>\u00c2\u00a0Directory<\/span>\u00c2\u00a0<\/span>
\n\u00c2\u00a0 \u00c2\u00a0 }\u00c2\u00a0<\/span>
\n\u00c2\u00a0 \u00c2\u00a0\u00c2\u00a0[<\/span>int<\/span>]<\/span>$percent<\/span>\u00c2\u00a0=<\/span>\u00c2\u00a0$i<\/span>\u00c2\u00a0\/<\/span>\u00c2\u00a0$numFiles<\/span>\u00c2\u00a0*<\/span>\u00c2\u00a0100<\/span>\u00c2\u00a0<\/span>
\n\u00c2\u00a0 \u00c2\u00a0\u00c2\u00a0<\/span>
\n\u00c2\u00a0 \u00c2\u00a0\u00c2\u00a0copy-item<\/span>\u00c2\u00a0-Path<\/span>\u00c2\u00a0$_<\/span>.<\/span>FullName\u00c2\u00a0-Destination<\/span>\u00c2\u00a0$Destination<\/span>.<\/span>FullName
\nWrite-Progress<\/span>\u00c2\u00a0-Activity<\/span>\u00c2\u00a0“Copying … (<\/span>$percent<\/span>\u00c2\u00a0%)”<\/span>\u00c2\u00a0-status<\/span>\u00c2\u00a0$_<\/span>\u00c2\u00a0\u00c2\u00a0-PercentComplete<\/span>\u00c2\u00a0$percent<\/span>\u00c2\u00a0-verbose<\/span>
\n$i<\/span>++<\/span>
\n}
\nWrite-Host<\/span>\u00c2\u00a0‘Total number of files read from directory ‘<\/span>$SourceFolder<\/span>\u00c2\u00a0‘ is ‘<\/span>\u00c2\u00a0$numFiles<\/span>
\nWrite-Host<\/span>\u00c2\u00a0‘Total number of files that was copied to ‘<\/span>$targetFolder<\/span>\u00c2\u00a0‘ is ‘<\/span>\u00c2\u00a0$i<\/span>
\nRead-host<\/span>\u00c2\u00a0-prompt<\/span>\u00c2\u00a0“Press enter to complete…”<\/span>
\nclear-host<\/span>;\u00c2\u00a0<\/span><\/p>\n