Remove specific files in a folder using powershell

See also questions close to this topic

• Concatenate dynamic variables

  I'm currently working on a powershell script that could compare 2 or more csv files.

  So far, the comparing part is all up and working. I now need my users to be able to say which column they'd like to compare beetween the file they've choosen.

  $nb = Read-Host -Prompt "How many column would you like to compare ?"
  
  for ($i=0;$i -lt $nb;$i++) {
  
  Clear-Variable -Name col$i -ErrorAction SilentlyContinue
  Remove-Variable -Name col$i -ErrorAction SilentlyContinue
  New-Variable -Name col$i -Value (Read-Host -Prompt "Name of the $i column")
  Start-Sleep -Seconds 1
  $head = Get-Variable -Name col$i -ValueOnly 
  $array += "$head"
  $header = "$array[$i]"
  
  } 
  

  Here is the code to read from the user the name of the column they'd like to compare beetween the file they have choosen. My problem is that, in order to parse the csvs' files, I need to get as an output of this loop strings formatted like so :

  col0.Value;col1.Value;col3.Value...
  

  This output will be passed as an argument for a function I wrote that will allow for the position of the column to have no incidence on the comparing part of the script.

  Basically, as long as two or more column in at least 2 different csv files match, they'll be compared.

  Hope this is clearer.
• Execute Windows Powershell command copy text to clipboard (incl. `r`n ')

  I am trying to execute a powershell command to copy text to the windows clipboard including carriage returns and ALL special characters. I can execute the command ok using:

  powershell.exe -command Set-Clipboard 'TEXT'
  

  This is not in the powershell console directly so syntax differs.

  I was using double quotes around text, substituting carriage returns in original text with `r`n and escaping all other special characters with ` It worked up until I got to a single ' which I understand is used by powershell to mean a literal text string.

  So I changed approaches and wrapped un-escaped text in single quotes (except substituting 1 ' for 2 ''). Of course `r`n within the single quoted text are interpreted literally so doesn't work. I have tried stringing them together outside single quoted text like:

  'some text here' "`r`n" 'more text here'
  

  This works in the console but not in the command. Tried adding + either side but still does not work. I was able to get it to work by wrapping the block in [ ] but they are passed through to the output (not really acceptable).

  Is it possible to achieve the intended outcome without writing to a temp file? It is preferable to be able to string single quoted text blocks with something to add carriage returns, if possible. Just to allow more original text before hitting the character limit.
• Powershell - Open/Close word document application

  We need to do some text search on word doc, and use below lines of code to open document. I got the code running on two laptops, in one it doesn't open wordapp and in other it does......

  $objWord = New-Object -Com Word.Application
  $objWord.Visible = $false 
  $objDocument = $objWord.Documents.Open($filename)
  $objDocument.Close()
  $objWord.Quit()
  # Stop Winword Process
  $rc = [System.Runtime.Interopservices.Marshal]::ReleaseComObject($objWord)
  

  is there any other way of opening document, as this open WORD DOC application which we dont want that... How to scan document without letting word application open...