Posts

Remove everything AFTER string in Notepad++

Image
i/p: srinivaskuamrgoud wants to delte after goud test and all o/p: srinivaskuamrgoud use below method.

batch file - counting number of files in folder and storing in a variable

 c:\WINDOWS\LiveKernelReports> attrib.exe /s ./*.dmp | find /v "File not found - " | find /c /v "" output : count of files present in that folder (including subfolder files aswell)

How To Count The Number Of rows filled with data In Excel?

  =COUNTA(A1:F11)

Remove everything before string in Notepad++

Example: Abcdefghijklmn EXECUTION EXEC myfilename here  Expected Result: EXEC myfilename here   Ctrl+H ==> ^.*(?=EXEC\s)  Enter Ref:  https://stackoverflow.com/questions/46338226/remove-everything-before-string-in-notepad

How to count Filled Cells in Microsoft Excel

Scroll down the list and select COUNTA(col:col)

Count Items Based on Another Column

Grren is New & Red is old products i want to get count of new products, for my reference i removed No for old one formula to get count of only no available products is MB=COUNTIFS(B:B,"*"&C2&"*",A:A,"<>") A                B                                   C                 D No AFO Column1 Column2 1 MB MB 4 2 DT DT 2 3 GPU GPU 3 4 INT+GPU 10 5 AMD+MB 6 Int+MB 7 NVI+GPU 8 DT MB DT MB GPU 9 PCO MB +Lexa (HG) RV DT UMA RV DT+NAVI14 Ref:  https://contexturesblog.com/archives/2015/10/15/count-items-based-on-another-column/

Delete Files and Folders Older Than X Days

Removing files / folders older than X days. This post contains a batch file, and a Powershell script that will do this. Batch File: @echo off :: set folder path set dump_path=c:\shares\dump :: set min age of files and folders to delete set max_days=7 :: remove files from %dump_path% forfiles -p %dump_path% -m *.* -d -%max_days% -c "cmd /c del /q @path" :: remove sub directories from %dump_path% forfiles -p %dump_path% -d -%max_days% -c "cmd /c IF @isdir == TRUE rd /S /Q @path" Powershell: # set folder path $dump_path = "C:\shares\dump" # set min age of files $max_days = "-7" # get the current date $curr_date = Get-Date # determine how far back we go based on current date $del_date = $curr_date.AddDays($max_days) # delete the files Get-ChildItem $dump_path -Recurse | Where-Object { $_.LastWriteTime -lt $del_date } | Remove-Item