How can this script be altered to EXCLUDE a set of words like "the", to", "and", "from", "for" from the capitalization:

I quickly solved the retyping problem:
+^k:: ; SHIFT+CTRL+K converts text to capitalized
  Clipboard := ""
  SendInput, ^c ;copies selected text
  ClipWait
  StringUpper Clipboard, Clipboard, T ; Title mode conversion
  SendInput %Clipboard%
Return

Thanks!

OT

I have a batch file that runs a process, updated some report and then generates an email in outlook to notify the users the reports have been updated. How do I get this to also include a link for the users to click on that would launch the excel file that is sitting in a static directory?

I have a large directory with over 10,000 files... the are in a common file naming convention of:

[Last name], [firstname] [year]-[month] [characters]
EX Smith, J 2019-10 MMC

Wanted to display only the file names that do NOT have a space after the coma after the last name Ex "Smith,J 2019-10 MMC"

Is this possible and if so perhaps a view in Windows 10 File explorer.

Thank you.

Robocopy.  Is it possible to generate a report / log file that only shows the new folders created as part of a particular copy run?  The verbose log lists every folder and file touched and uses "new dir" to indicate a new folder, but given that this verbose log is >95,000 lines that can be cumbersome.

Hi Experts,

Not sure For /F is correct solution but I think it is.

Years.csv

Desired Result for the 'Result.bat' file:

My current For /F which is not working.  Never even makes it to the pause for some reason.

@echo off

set AppName=Fin

FOR /f "tokens=1 delims," %%G IN ("D:\Years.csv" DO @echo "call epmautomate exportData %AppName%_DATA_%%G %AppName%_LEV0_DATA_%%G.zip" > "D:\Result.txt"

pause

exit /b

Select all Open in new window

Years.csv

I'm trying to create a batch file that will add the current date to a file. I found this online - but it only works when you enter it directly on the command line
for /f "tokens=1-5 delims=/ " %d in ("%date%") do rename "filename.pdf" filename_%g%e%f.pdf

If its in a bat file I receive this message
dategf.pdf was unexpected at this time.

I'm looking for a solution and I'm not tied to this one if you have a better option.

Thank you!

Hi,

I'm looking to copy a folder from one location to another. The destination folder does not exist.

How can I do this with Xcopy?

The following will copy all folders within sourcefolder, to destination folder, but that's not what i want.

Xcopy /E /I   c:\temp\sourcefolder  T:\temp\destinationfolder\

I want to copy folder sourcefolder to a new folder within destination folder.

Any help much appreciated.

Thanks


MS ref: https://support.microsoft.com/en-gb/help/289483/switches-that-you-can-use-with-xcopy-and-xcopy32-commands

How do I control the information displayed in the dos window header?

If I run a batch file, it will display the name of the batch file in the header of the DOS window which it is running in. Also if I pass parameters to the batch file, it will display the name of the batch file followed by the parameters values passed. So how can I prevent batch file name and input parameter from being displayed in the header, when the batch file is running?

I have the following batch file now I want to add STEP 1 STEP 2 if STEP 1 FAILED then goto next step and send email or generate output in txt

powershell.exe -executionpolicy bypass -file J:\Backup\EnableTCP-IP_Named_Pipes.ps1
powershell.exe -executionpolicy bypass -file J:\Backup\Restart-SQL_Server.ps1
if errorlevel 1 echo Unsuccessful > J:\Backup\result.txt
if errorlevel 0 echo command executed successfully > J:\Backup\result.txt

Thanks

Hi Experts,

How can I modify this DOS command to only look at files created after a certain date?

Thanks

I have created batch job to copy a file to UNC path, which is mapped to my computer. The batch job run from task scheduler but the file doesn't transfer to UNC path. But if I run command manually is successfully copy files. I have tried both batch below:
####################################
  @echo off
pushd c:\xxx\zzzz\yyyyyy\
COPY * Q:\test\--(note:this is the map drive letter for unc path)
Sleep 5
popd
end
cls
################################################
@echo off
cd c:\xxx\zzzz\yyyyyy\
move * Q:\test\--(note:this is the map drive letter for unc path)
sleep 5
del *
#end
exit



Action Started
Task Scheduler launched action "C:\Windows\SYSTEM32\cmd.exe" in

instance "{90e9b280-15df-4a79-9ec1-6bef9a621423}" of task

"\xxxxxx".

Action completed
Task Scheduler successfully completed task "\xxxxxx" , instance

"{90e9b280-15df-4a79-9ec1-6bef9a621423}" , action "C:\Windows

\SYSTEM32\cmd.exe" with return code 0.

Hello,

I am trying to create a batch file in windows 10 that would delete all files & folders from a specific folder and its sub-folders that there modified date is prior 5/23/2019.  I have used DateModified:<5/23/2019, then highlight them, then delete them, but for some reason next time run DateModified:<5/23/2019
 to make sure all prior 5/23/2019 has been deleted, more are displayed.  Also tried placing *.* then sorting by date but since so many files, takes super long but also after deleting, I search again,more files prior 5/23/2019.  I also tried ForFiles but also, no success.

Help.