<div>
This should work; it's in test mode and will only display what it would move where. Remove the -WhatIf at the end of line 24 to run it for real. 

<pre><code class="code-10 nolinks" id="code-20-42829531-1">$source = &quot;D:\Temp\Source&quot;
$target = &quot;D:\Temp\Target&quot;
$filePatterns = Get-Content D:\temp\Source\files.txt
$dirPatterns = Get-ChildItem -Path $target -Directory
$timeStamp = Get-Date -Format 'yyyyMMdd_HHmm'
Get-ChildItem -Path $source -Filter *.pdf | ForEach-Object {
	Write-Host &quot;Processing '$($_.Name)' ...&quot;
	$copy = $false
	ForEach ($pattern in $filePatterns) {
		If ($_.Name -like &quot;$($pattern)*&quot;) {
			$copy = $true
			Break
		}
	}
	If ($copy) {
		$target = $null
		ForEach ($pattern in $dirPatterns) {
			If ($_.BaseName -like &quot;*$($pattern.Name)&quot;) {
				$target = $pattern
				Break
			}
		}
		If ($target) {
			Move-Item -Path $_.FullName -Destination &quot;$($target.FullName)\$($_.BaseName) $($timeStamp)$($_.Extension)&quot; -WhatIf
			Write-Host &quot;... moved to '$($target.FullName)'!&quot; -ForegroundColor Green
		} Else {
			Write-Host &quot;... skipped, no matching target folder found!&quot; -ForegroundColor Yellow
		}
	} Else {
		Write-Host &quot;... skipped, no match in pattern file.&quot;
	}
}
</code></pre>
</div>

IT Professional

Albert Widjaja

<div>
Wow you're fast. &nbsp;I tried to run it in powershell but it's not working. 
 
I created 2 folders in C;\temp\Source &nbsp;and C;\temp\Target 
 
I created C;\temp\source\files.txt and its contents look like: 
18-036154960 
18-036181365 
 
Folder C;\temp\source has 18 .pdf files and 4 files match: 
18-036154960 MD 91-1104421C.pdf 
18-036154960 Member 91-1104421C.pdf 
18-036181365 MD 91-1104421C.pdf 
18-036181365 Member 91-1104421C.pdf 
 
 
When I run it, the error message is: 
 
PS H:\&gt; N:\BATCH\DenialLetters\Get_CAS_files.ps1 
Processing '18-036154960 MD 91-1104421C.pdf' ... 
... skipped, no matching target folder found! 
Processing '18-036154960 Member 91-1104421C.pdf' ... 
... skipped, no matching target folder found! 
Processing '18-036181365 MD 91-1104421C.pdf' ... 
... skipped, no matching target folder found! 
Processing '18-036181365 Member 91-1104421C.pdf' ... 
... skipped, no matching target folder found! 
Processing '18-036279556 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036279556 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036330631 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036330631 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036342089 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036342089 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036523443 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036523443 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036547207 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036547207 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036547218 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036547218 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036554129 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036554129 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
 
PS H:\&gt;
</div>

<div>
Then there's no folder &quot;MD 91-1104421C&quot; or &quot;91-1104421C&quot; or similar in C:\temp\target ...
</div>

<div>
In folder target, I created SUBfolder &quot;91-1104421C&quot; and it successfully moved 4 files there. 
 
QUESTION: 
1. where in the code holds the value &quot;91-1104421C&quot; for it to look for a folder of that name ? 
2. &nbsp;when I changed the command from Move-Item to Copy-Item, it doesn't work. &nbsp;Are the syntax different? 
3. how do I see the syntax for move-item and copy-item? 
 
thank you.
</div>

<div>
1. Nowhere. It compares the end of the file name with the folder names in the target folder. 
2. Works just fine with Copy-Item without any other changes. If you just moved the files back into the source folder, don't forget that they now have the date attached at the end, and won't find a matching target folder anymore. 
3. Possibly the most important cmdlet: Get-Help 

<pre><code class="code-1 nolinks" id="code-20-42829604-1">Get-Help Move-Item -ShowWindow
Get-Help Copy-Item -ShowWindow
</code></pre>
</div>

<div>
1. How does it determine what length of the end of the source filename to parse to figure out that &quot;91-1104421C&quot; &nbsp;is the string that it will use to find a subfolder with that name?
</div>

<div>
In line 4, it reads all the folder items in the target: 
$dirPatterns = Get-ChildItem -Path $target -Directory 
 
In lines 17-22, it compares the name of the current file with each folder item's name, using a wildcard, not a static length: 
If ($_.BaseName -like &quot;*$($pattern.Name)&quot;)
</div>

<div>
3. What if files.txt contained fileMickey and fileDonald but these files do not exist in the source folder; how would the code look to write to a log file that says: today's date and the message Cannot find test_file. 
 
files.txt looks like this: 
18-036154960 
18-036181365 
fileMickey 
fileDonald 
 
log file looks like: 
20190326_1641 Cannot find fileMickey 
20190326_1641 Cannot find fileDonald 
-------------------------------- 
 
4. What if the target folder does NOT exist? &nbsp;What would the code look like to move the files to a subfolder named UNKNOWN 
 
Thank you.
</div>

<div>
<pre><code class="code-10 nolinks" id="code-20-42829732-1">$source = &quot;D:\Temp\Source&quot;
$target = &quot;D:\Temp\Target&quot;
$targetUnknown = &quot;$($target)\Unknown&quot;
$fileList = &quot;D:\Temp\Source\files.txt&quot;
$logFile = &quot;D:\Temp\Source\files.log&quot;

$filePatterns = Get-Content -Path $fileList | Select-Object -Property @{n='Name'; e={$_}}, @{n='Found'; e={$false}}
$dirPatterns = Get-ChildItem -Path $target -Directory
$timeStamp = Get-Date -Format 'yyyyMMdd_HHmm'

Start-Transcript -Path $logFile
Get-ChildItem -Path $source -Filter *.pdf | ForEach-Object {
	Write-Host &quot;Processing '$($_.Name)' ...&quot;
	$copy = $false
	ForEach ($pattern in $filePatterns) {
		If ($_.Name -like &quot;$($pattern.Name)*&quot;) {
			$copy = $true
			$pattern.Found = $true
			Break
		}
	}
	If ($copy) {
		$target = $null
		ForEach ($pattern in $dirPatterns) {
			If ($_.BaseName -like &quot;*$($pattern.Name)&quot;) {
				$target = $pattern
				Break
			}
		}
		If ($target) {
			$destination = &quot;$($target.FullName)\$($_.BaseName) $($timeStamp)$($_.Extension)&quot;
		} Else {
			$destination = $targetUnknown
		}
		Move-Item -Path $_.FullName -Destination $destination -WhatIf
		Write-Host &quot;... moved to '$($destination)'.&quot; -ForegroundColor Green
	} Else {
		Write-Host &quot;... skipped, no match in pattern file.&quot;
	}
}
$filePatterns | Where-Object {-not $_.Found} | ForEach-Object {
	Write-Host &quot;$($timeStamp) No file matching '$($_.Name)' found!&quot; -ForegroundColor Yellow
}
Stop-Transcript
</code></pre>
</div>

<div>
Thank you. 
 
ERROR message: 
Start-Transcript : This host does not support transcription. 
At C:\Temp\Get_CAS_files_log.ps1:11 char:1 
+ Start-Transcript -Path $logFile 
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotImplemented: (:) [Start-Transcript], PSNotSupportedException 
&nbsp; &nbsp; + FullyQualifiedErrorId : NotSupported,Microsoft.PowerShell.Commands.StartTranscriptCommand 
 
 
 
I am using Windows 7, PS version 4: 
 
PS C:\Windows\System32\WindowsPowerShell\v1.0&gt; $PSVersionTable.PSVersion 
 
Major &nbsp;Minor &nbsp;Build &nbsp;Revision 
----- &nbsp;----- &nbsp;----- &nbsp;-------- 
4 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp;-1 &nbsp; &nbsp; -1
</div>

<div>
Start it in a normal PS console, not in the ISE.
</div>

<div>
I ran it from the command prompt and ran without errors. &nbsp;But it did not copy the files. 
 
powershell.exe c:\temp\Get_CAS_files_log.ps1 
 
The LOG file files.log did get created and populated with entries (I replaced private information in the log below with xxx): 
 
********************** 
Windows PowerShell transcript start 
Start time: 20190327095303 
Username &nbsp;: xxx 
Machine &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &nbsp;xxx &nbsp;(Microsoft Windows NT 6.1.7601 Service Pack 1) 
********************** 
Transcript started, output file is C:\Temp\Source\files.log 
Processing '18-036154960 MD 91-1104421C.pdf' ... 
What if: Performing the operation &quot;Copy File&quot; on target &quot;Item: C:\Temp\Source\18-036154960 MD 91-1104421C.pdf Destination: C:\Temp\Target\91-1104421C\18-036154960 MD 91-1104421C 20190327_0953.pdf&quot;. 
... moved to 'C:\Temp\Target\91-1104421C\18-036154960 MD 91-1104421C 20190327_0953.pdf'. 
Processing '18-036154960 Member 91-1104421C.pdf' ... 
What if: Performing the operation &quot;Copy File&quot; on target &quot;Item: C:\Temp\Source\18-036154960 Member 91-1104421C.pdf Destination: C:\Temp\Target\91-1104421C\18-036154960 Member 91-1104421C 20190327_0953.pdf&quot;. 
... moved to 'C:\Temp\Target\91-1104421C\18-036154960 Member 91-1104421C 20190327_0953.pdf'. 
Processing '18-036181365 MD 91-1104421C.pdf' ... 
What if: Performing the operation &quot;Copy File&quot; on target &quot;Item: C:\Temp\Source\18-036181365 MD 91-1104421C.pdf Destination: C:\Temp\Target\91-1104421C\18-036181365 MD 91-1104421C 20190327_0953.pdf&quot;. 
... moved to 'C:\Temp\Target\91-1104421C\18-036181365 MD 91-1104421C 20190327_0953.pdf'. 
Processing '18-036181365 Member 91-1104421C.pdf' ... 
What if: Performing the operation &quot;Copy File&quot; on target &quot;Item: C:\Temp\Source\18-036181365 Member 91-1104421C.pdf Destination: C:\Temp\Target\91-1104421C\18-036181365 Member 91-1104421C 20190327_0953.pdf&quot;. 
... moved to 'C:\Temp\Target\91-1104421C\18-036181365 Member 91-1104421C 20190327_0953.pdf'. 
Processing '18-036279556 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036279556 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036330631 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036330631 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036342089 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036342089 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036523443 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036523443 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036547207 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036547207 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036547218 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036547218 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036554129 MD 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
Processing '18-036554129 Member 91-1104421C.pdf' ... 
... skipped, no match in pattern file. 
20190327_0953 No file matching 'test_file' found! 
********************** 
Windows PowerShell transcript end 
End time: 20190327095303 
**********************
</div>

<div>
As before in test mode (-WhatIf in line 35) 
That's why you see the 

<blockquote>
What if: Performing the operation &quot;Copy File&quot; ...
</blockquote>
in the log and in the console; it means that the command isn't really executed, it only pretends to run,
</div>

<div>
That worked after I removed the WHAT IF. 
 
QUESTION: 
4. The existing LOG file files.log appears to be overwritten each time. 
 
What would the code look like if we wrote to a new LOG file that is created (with a datestamp at the end of the filename)?
</div>

paultran00

<div>
Wow. &nbsp;that worked! 
 
Previously in QUESTION 3 when I was using 1 LOG file files.log and it was overwritten each time, if I had wanted to APPEND new entries into the same file, what would that code have looked like?
</div>

<div>
QUESTION: 
5. Let's say the user does not give me a files.txt, therefore I have to look at all the *.pdf files in the SOURCE folder and do these checks before I copy them to the TARGET folder : 
 
EXAMPLE of *.pdf files in the SOURCE FOLDER: 
 
18-111 member 91-A.pdf 
18-111 MD 91-A.pdf 
 
Check a SQL SERVER table tblFilesProcessed and the columns source_filename , processed (Y/N). 
If the query (looks for source_filename=18-111 member 91-A.pdf, &nbsp;Processed=Y) does NOT return any records, then: 
5a. insert this record into the SQL SERVER table tblFilesProcessed . 
 
18-111 member 91-A.pdf, Y 
18-111 MD 91-A.pdf, Y 
 
else insert: 
 
18-111 member 91-A.pdf, N 
18-111 MD 91-A.pdf, N 
 
 
5b. If the query does NOT return any records, Copy only these files to the TARGET folder 91-A. 
 
18-111 member 91-A.pdf 
18-111 MD 91-A.pdf 
 
5c. MOVE all files from the SOURCE folder to a subfolder ARCHIVE and add a datestamp to the end of the filename.
</div>

<div>
As to append to the log: remember the Single Most Important cmdlet? 

<pre><code class="code-1 nolinks" id="code-20-42830650-1">Get-Help -ShowWindow Start-Transcript
</code></pre>
will show that Start-Transcript supports an &quot;-Append&quot; argument. 
As for your new question: I think the initial question has been exhaustively answered. Please don't keep tacking on questions. If you want a different approach in selecting the files to copy, then please accept the comment(s) that helped you, and open a new question in the respective TAs.
</div>

<div>
Hi, I've created a new question to continue with SQL SERVER. 
 
<a href="https://www.experts-exchange.com/questions/29140943/Powershell-and-SQL-Server.html#questionAdd" rel="ugc nofollow">https://www.experts-exchange.com/questions/29140943/Powershell-and-SQL-Server.html#questionAdd</a> 
 
Thank you.
</div>

<div>
Hi, what does this line below mean ,especially around the array: e={$_}} &nbsp; &nbsp;, &nbsp; e={$false}} 
 
$filePatterns = Get-Content -Path $fileList | Select-Object -Property @{n='Name'; e={$_}}, &nbsp;@{n='Found'; e={$false}} 
 

<pre><code class="code-10 nolinks" id="code-20-42831382-1">$source = &quot;C:\Temp\Source&quot;
$target = &quot;C:\Temp\Target&quot;
$targetUnknown = &quot;$($target)\Unknown&quot;
$fileList = &quot;C:\Temp\Source\files.txt&quot;
#$logFile = &quot;C:\Temp\Source\files.log&quot;
$timeStamp = Get-Date -Format 'yyyyMMdd_HHmm'
$logFile = &quot;C:\Temp\Source\files_$($timeStamp).log&quot;

$filePatterns = Get-Content -Path $fileList | Select-Object -Property @{n='Name'; e={$_}}, @{n='Found'; e={$false}}
$dirPatterns = Get-ChildItem -Path $target -Directory

Start-Transcript -Path $logFile
Get-ChildItem -Path $source -Filter *.pdf | ForEach-Object {
	Write-Host &quot;Processing '$($_.Name)' ...&quot;
	$copy = $false
	ForEach ($pattern in $filePatterns) {
		If ($_.Name -like &quot;$($pattern.Name)*&quot;) {
			$copy = $true
			$pattern.Found = $true
			Break
		}
	}
	If ($copy) {
		$target = $null
		ForEach ($pattern in $dirPatterns) {
			If ($_.BaseName -like &quot;*$($pattern.Name)&quot;) {
				$target = $pattern
				Break
			}
		}
		If ($target) {
			$destination = &quot;$($target.FullName)\$($_.BaseName) $($timeStamp)$($_.Extension)&quot;
		} Else {
			$destination = $targetUnknown
		}
		Copy-Item -Path $_.FullName -Destination $destination #-WhatIf
		Write-Host &quot;... moved to '$($destination)'.&quot; -ForegroundColor Green
	} Else {
		Write-Host &quot;... skipped, no match in pattern file.&quot;
	}
}
$filePatterns | Where-Object {-not $_.Found} | ForEach-Object {
	Write-Host &quot;$($timeStamp) No file matching '$($_.Name)' found!&quot; -ForegroundColor Yellow
}
Stop-Transcript
</code></pre>
</div>

<div>
That are two hash tables: 
@{n='Name'; e={$_}} 
@{n='Found'; e={$false}} 
These are called &quot;calculated property&quot;, that is, a property that is created on the fly. 
In this case, it uses the strings and creates objects with two properties (Name and Found) from then, so that the script can trick which patterns have been found. 
Using PowerShell's Calculated Properties 
<a href="https://mcpmag.com/articles/2017/01/19/using-powershell-calculated-properties.aspx" rel="ugc">https://mcpmag.com/articles/2017/01/19/using-powershell-calculated-properties.aspx</a>
</div>

<div>
Hi. &nbsp;I created a new question if you could please help me (there's no SQL SERVER involved): 
 
<a href="https://www.experts-exchange.com/questions/29141924/Powershell-copy-and-archive.html" rel="ugc">https://www.experts-exchange.com/questions/29141924/Powershell-copy-and-archive.html</a>
</div>

<div>
<div class="content wysiwyg-content">
powershell and Windows 7. 
 
Hi, 
 
I have a text file request.txt containing filenames such as: 
18-111 
18-222 
 
Actual filenames: 
18-111 member 91-A.pdf 
18-111 MD 91-A.pdf 
18-222 member 91-B.pdf 
18-222 MD 91-B.pdf 
18-333 member 91-C.pdf 
18-333 MD 91-C.pdf 
 
QUESTION: how do I use powershell to 
1) loop through request.txt and do a partial match to identify certain .pdf files to move from folder A to a specific folder B that has the same name as the last 4 characters of the filename? &nbsp; 
 
RESULT: 
18-111 member 91-A.pdf is moved to folder 91-A. 
18-111 MD 91-A.pdf is moved to folder 91-A. 
18-222 member 91-B.pdf is moved to folder 91-B. 
18-222 MD 91-B.pdf is moved to folder 91-B. 
 
2) Add today's timestamp to the end of the filename in the format YYYMMDD_HHMM in 24hour format. 
RESULT: If today is 3/26/2019 1:21pm. 
18-111 member 91-A 20190326_1321.pdf 
18-111 MD 91-A 20190326_1321.pdf 
18-222 member 91-B 20190326_1321.pdf 
18-222 MD 91-B 20190326_1321.pdf
</div>
</div>

powershell and Windows 7.

Hi,

I have a text file request.txt containing filenames such as:
18-111 
18-222 

Actual filenames:
18-111 member 91-A.pdf
18-111 MD 91-A.pdf 
18-222 member 91-B.pdf
18-222 MD 91-B.pdf
18-333 member 91-C.pdf
18-333 MD 91-C.pdf

QUESTION: how do I use powershell to
1) loop through request.txt and do a partial match to identify certain .pdf files to move from folder A to a specific folder B that has the same name as the last 4 characters of the filename?  

RESULT: 
18-111 member 91-A.pdf is moved to folder 91-A.
18-111 MD 91-A.pdf is moved to folder 91-A.
18-222 member 91-B.pdf is moved to folder 91-B.
18-222 MD 91-B.pdf is moved to folder 91-B.

2) Add today's timestamp to the end of the filename in the format YYYMMDD_HHMM in 24hour format.
RESULT: If today is 3/26/2019 1:21pm.
18-111 member 91-A 20190326_1321.pdf
18-111 MD 91-A 20190326_1321.pdf 
18-222 member 91-B 20190326_1321.pdf
18-222 MD 91-B 20190326_1321.pdf

Use powershell to read a text file containing filenames to move just those files from folder A to folder B.

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Golang, also called Go, is an open source programming language that is a statically-typed language with syntax loosely derived from C, adding automatic memory management, type safety, some dynamic-typing capabilities, additional built-in types such as variable-length arrays and key-value maps, and a large standard library. Go is a general-purpose systems programming language that aims to be efficient both for development and execution with a focus on fast compilation and increased maintainability of large projects. Go was originally targeted at systems programming tasks such as building server/web applications, high throughput middleware and databases.