How to Effectively Filter Files in a PowerShell Script with -contains and -notcontains

Discover how to streamline your PowerShell script for file management in FTP folders using `-contains`, `-notcontains`, and `Get-ChildItem`.
---

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Powershell .ps1 script. Using -contains / -notcontains and Get-ChildItem for getting files in a folder

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Streamlining Your PowerShell Script for File Management

Managing files in different directories using PowerShell can sometimes lead to confusion, especially when trying to filter out files based on their existence in multiple locations. If you've ever written a PowerShell script to copy files but found that it copies everything regardless of conditions, you're in good company. Today, we’re going to tackle a common issue where files in an FTP folder are copying over even when they exist in other specified folders, and how to fix it effectively.

The Problem

You might be running a PowerShell script that is intended to copy files from an FTP folder to two other folders—Pendientes (Pending) and Procesados (Processed)—only if those files do not already exist in either of those folders. However, if the script keeps copying all files regardless, there’s likely a straightforward issue in the logic or structure.

You are likely encountering something like this:

[[See Video to Reveal this Text or Code Snippet]]

This script may not work as intended due to incorrect variable usage or logic flaws. Let’s break down the solution in the next section so you can avoid this common pitfall.

The Solution

To efficiently filter out the files you want to copy, we will make a few adjustments to your existing script. Here's a simplified version that should work efficiently.

Step 1: Define the Locations

First, specify where your folders are:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Gather the FTP Files

Next, gather your FTP files in an array:

[[See Video to Reveal this Text or Code Snippet]]

Step 3: Combine Files to Exclude

Instead of checking the names one by one, combine the files from both the Pendientes and Procesados folders:

[[See Video to Reveal this Text or Code Snippet]]

Step 4: Loop and Copy

Then, loop through the FTP files and check against the combined array:

[[See Video to Reveal this Text or Code Snippet]]

Summary of Key Adjustments

Combine Exclusion Logic: Instead of checking the names in separate conditional statements, we combine both arrays into one for a cleaner check.

Use -in operator: This operator simplifies the logic by checking if the current file name is within the combined exclusion list.

Conclusion

By implementing these changes, your PowerShell script will effectively copy files from the FTP location to the Pendientes folder only if they do not exist in either of the other folders. The steps outlined above should provide a robust framework for managing your file operations with clarity and efficiency.

PowerShell is a powerful tool, and with these adjustments, you can maximize its potential to simplify your file management tasks!

If you have additional questions or need further clarification, feel free to reach out!