Ivan A. ivanhub
ivanhub
/ thumbnails_generator_image_resizer_c#.cs
Created
December 16, 2022 05:40
Auto thumbnail generator and image resizer - C#
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.Collections.Generic; | |
| using System.Web; | |
| using System.IO; | |
| using System.Web.UI; | |
| using System.Web.UI.WebControls; | |
| using System.Text.RegularExpressions; | |
| using System.Diagnostics; | |
| using System.Security.Principal; | |
| using System.Drawing; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| exifautotran *.jpg | |
| #or | |
| magick mogrify -auto-orient imagefile.jpg |
ivanhub
/ Search_&_replace_in_DOCX.ps1
Last active
December 6, 2022 05:04
Search&repace text in all *.docx files
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #1 | |
| $petya = 0 | |
| foreach ($file in Get-ChildItem .\ -Filter *.docx) { | |
| Move-Item $file $($file.BaseName + '_xxx.zip') | |
| expand-Archive -literalPath $($file.BaseName + '_xxx.zip') -destinationpath $($file.BaseName) -Force | |
| if (-Not (Test-Path $($file.BaseName + '\*'))) { | |
| Move-Item $($file.BaseName + '_xxx.zip') $($file.BaseName + '.docx') -Force | |
| Remove-Item -Path $($file.BaseName) -Force | |
| $petya++ |
ivanhub
/ Searh&replace.DOC.ps1
Last active
December 6, 2022 05:04
Search & repace text in all *.doc files in directory
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #1 | |
| foreach ($file in Get-ChildItem .\"*.doc") { | |
| Start-Process 'C:\Program Files\Microsoft Office\Office15\Wordconv.exe' -ArgumentList '-oice -nme', $($file.BaseName + '.doc'), $($file.BaseName + '_xxx.docx') -Wait | |
| if (Test-Path -Path $($file.BaseName + '_xxx.docx')) { | |
| Move-Item $($file.BaseName + '_xxx.docx') $($file.BaseName + '_xxx.zip') | |
| #expand-7zip $($file.BaseName +'.zip') $($file.BaseName) | |
| expand-Archive -literalPath $($file.BaseName + '_xxx.zip') -destinationpath $($file.BaseName) -Force | |
| } | |
| } |
ivanhub
/ copy_files_by_extensions_with_subfolders_recursively.ps1
Created
December 5, 2022 10:44
Copy files filtered by extensionsand all subfolders
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Copy-Item .\ C:\to where\ -Filter *.doc* -Recurse |
ivanhub
/ copy_to_all_subfolders.ps1
Last active
December 5, 2022 10:09
Copy file to all subfolders PS
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $folders = Get-ChildItem .\ -Directory | |
| foreach ($folder in $folders.name){ | |
| Copy-Item -Path "FileName" -Destination ".\$folder" -Recurse -Force | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use dbname | |
| Update TableName | |
| SET ColumnName = REPLACE(ColumnName, 'what', 'towhat'); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use DATABASENAME | |
| DECLARE @SearchStr nvarchar(100) = 'TEXT TO SEARCH' | |
| 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 + '%','''') |
ivanhub
/ increase_selected_items.js
Created
October 11, 2022 09:06
INCREASE selected items in LIST (SHAREPOINT)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function waitFor(variable, callback) { | |
| var interval = setInterval(function() { | |
| if (window[variable]) { | |
| clearInterval(interval); | |
| callback(); | |
| } | |
| }, 200); | |
| } | |
| $(document).ready(function() { | |
| waitFor('g_MaximumSelectedItemsAllowed', function() { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Test-path $profile | |
| New-item -path $profile -type file -force | |
| #function prompt {"PS [$env:computername] >"} | |
| $Shell = $Host.UI.RawUI | |
| $size = $Shell.WindowSize | |
| # $size.width=70 | |
| # $size.height=25 | |
| $Shell.WindowSize = $size |