Posts
EXE's helps for display validation
EXE's helps for display validation https://drive.google.com/drive/folders/1SVlm8WfvX1FfMuRLSksh-dBFjnV3ZzXp?usp=sharing
Remove everything AFTER string in Notepad++
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)
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
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
How can I list P4 changes since a specific changelist
//depot/branches/branch_name/...@12345,#head specifies a range between changelist 12345 and head/latest. //depot/branches/branch_name/...@12345,23456 specifies a range between changelist 12345 and 23456. //depot/branches/branch_name/...@2012/08/01,@2012/08/21 specifies a range between two dates.
Duration calc between two timestamps
Calculating time difference with the TEXT function Calculate hours between two times: =TEXT(B2-A2, "h") Return hours and minutes between 2 times: =TEXT(B2-A2, "h:mm") Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, "h:mm:ss")
Find a string by searching all tables in SQL Server Management Studio 2008
Q) Is there any way to search for a string in all tables of a database in SQL Server Management Studio 2008? I want to search for string say john . The result should show the tables and their respective row that contain john . Solution: USE DATABASE_NAME DECLARE @ SearchStr nvarchar ( 100 ) = 'SEARCH_TEXT' DECLARE @ Results TABLE ( ColumnName nvarchar ( 370 ), ColumnValue nvarchar ( 3630 )) SET NOCOUNT ON DECLARE @ TableName nvarchar ( 256 ), @ ColumnName nvarchar ( 128 ), @ SearchStr2 nvarchar ( 110 ) SET @ TableName = '' SET @ SearchStr2 = QUOTENAME ( '%' + @ SearchStr + '%' , '''' ) WHILE @ TableName IS NOT NULL BEGIN SET @ ColumnName = '' SET @ TableName = ( SELECT MIN ( QUOTENAME ( TABLE_SCHEMA ) + '.' + QUOTENAME ( TABLE_NAME )) FROM INFORMATION_SCHEMA . TABLES WHERE TABLE_TYPE = 'BASE TABLE' ...