Creation symbolic link daily files

To modify your script so that it can handle multiple daily files with different names, all starting with the date and time, you can use a loop to process each file individually. Below is an updated version of your script that iterates over each file found and creates a symbolic link for each one:

# Define the source and destination paths
$Source = "\\share\report\"
$Destination = "\\Share\Report\Dayly\"

# Get all .xls files created within the last 2.5 hours
$Fichiers = Get-ChildItem "$Source*.xls" -Recurse | Where-Object { $_.CreationTime -gt (Get-Date).AddHours(-2.5)}

# Loop through each file in the source directory
foreach ($File in $Fichiers) {
# Extract the original file name (without the date and time)
$FileName = $File.Name -replace '^\d{4}_\d{2}_\d{2}_\d{2}_\d{2}_\d{2}_', ''
$Localhost = Join-Path $Destination $FileName

# Check if the symbolic link already exists and remove it if necessary
if (Test-Path $Localhost -ErrorAction SilentlyContinue) {
Remove-Item $Localhost -Confirm:$false -Force
Start-Sleep -Seconds 3
}

# Create the new symbolic link
New-Item -ItemType SymbolicLink -Path $Destination -Name $FileName -Value $File.FullName
}

# Display the created symbolic links
gci $Destination | Where-Object { $_.LinkType } | Select-Object FullName, LinkType, Target




Explanation:
Loop through files: The script loops through each file in the $Fichiers collection, which includes all .xls files created in the last 2.5 hours.

Extract the original file name: For each file, it removes the date and time prefix from the file name using the -replace operator with a regular expression.

Create symbolic link: It creates a symbolic link for each file in the destination directory, using the filename without the date and time prefix.

Handle existing links: Before creating a new symbolic link, the script checks if one already exists at the destination and removes it if necessary.

This approach will allow you to create symbolic links for multiple files, regardless of their specific names, as long as they start with a date and time prefix.