Ömer Görür omergorur
omergorur
/ excel-Turkish-text-to-url-slug.txt
Created
April 20, 2026 16:45
Excel: Convert Turkish Text to URL-Friendly Slug
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
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1),"ı","i"),"ü","u"),"ğ","g"),"ş","s"),"ç","c"),"ö","o")," ","-") |
omergorur
/ excel-round-time-to-nearest-15-minutes.txt
Created
April 20, 2026 16:36
Excel: Round Time to the Nearest 15 Minutes
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
| =ROUND(A1*(24*60)/15,0)*15/(24*60) |
omergorur
/ excel-find-missing-numbers-in-sequence.txt
Last active
April 20, 2026 16:39
Excel: Find Missing Numbers in a Sequence Using FILTER + SEQUENCE
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
| =INDEX(FILTER(SEQUENCE(1800),ISNA(MATCH(SEQUENCE(1800),A:A,0))),ROW(B1)) |
omergorur
/ detect_non_numeric_cells.txt
Last active
April 20, 2026 16:10
Quick Way to Detect Non-Numeric Characters Hiding in Your Excel Data
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
| =IF(A1="","",--ISERROR(A1*1)) |
omergorur
/ enable_guest_samba_windows11.ps1
Last active
May 21, 2026 19:44
Enable Guest Access to Samba Shares on Windows 11 24H2
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
| Set-SmbClientConfiguration -RequireSecuritySignature $false | |
| Set-SmbClientConfiguration -EnableInsecureGuestLogons $true |
omergorur
/ dump_restore_mysql_utf8mb4.sh
Created
January 16, 2025 14:39
— forked from attilahorvath/dump_restore_mysql_utf8mb4.sh
Dump/restore MySQL database with utf8mb4 encoding
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
| # dump | |
| mysqldump -u user -p database --default-character-set=utf8mb4 --result-file=dump.sql | |
| # restore | |
| mysql -u user -p database < dump.sql |