tikg / regex.md

Last active January 20, 2023 07:35

regex insert character at position with Notepad++

Open Notepad++
Press Ctrl+H
Replace Tab
"Regular Expression" radio button

Find from beginning of line to 5th character

Find: ^(.{5})

tikg / github.md

Last active January 20, 2023 07:35

Gist formatting in github

This is how you Link

Text [Link Name](URL)

Inserting line break

Add 2 empty spaces after line

tikg / excel-google-sheets.md

Last active January 20, 2023 07:34

Excel and Google Sheets Formulas

substitute values JPY and comma and return value as a number

=value(substitute(SUBSTITUTE(E2,"JPY",""),",",""))

tikg / windows.md

Last active February 19, 2024 08:05

Always run Windows Terminal as admin on Win10

Open Terminal > Drop down tab > Settings > Defaults > Run tihs profile as administrator

Windows Related Resources

Patching: Batch Patch
Sharing files between Windows/Linux
Using Robocopy

tikg / terminals.md

Last active January 20, 2023 07:24

mobaxterm terminal

locate mobaxterm.ini
add below line to [Misc] section
ScrollMod=alt

template

text

tikg / linuxcmd.md

Last active December 19, 2023 03:27

Linux

Linux Cheatsheet

deleting a file with a weird name

Prompts you before deleting any file
rm -i -- *

using the next variable to connect to a server and appending domain suffix

tikg / openstack.md

Last active January 20, 2023 07:34

OpenStack CheatSheet

OpenStack CheatSheet CLI Manage Project, Users and Roles

$ openstack project list

tikg / homeserver.md

Last active January 20, 2023 07:21

Homeserver Setup with CapRover, VM and Docker

Derived from Elitsur All credit goes to him

All below are notes from my experience with setting it up

Setting up Host VirtualBox environment

Buy domain from cloudflare
Download VirtualBox
Install Virtualbox
Download Ubuntu Server
Setup New VM in VirtualBox

tikg / ssh.md

Last active January 20, 2023 07:33

SSH keygen standard

ssh-keygen -t rsa -b 4096

SSH copy id

ssh-copy-id -i ~/.ssh/mykey user@host

Windows Equivalent of ssh-copy-id on Windows Terminal

type $env:USERPROFILE\.ssh\key.pub | ssh [email protected] "cat >> .ssh/authorized_keys"

Allowing SFTP but disallowing SSH

tikg / powershell.md

Last active February 16, 2023 00:49

Microsoft Powertoys

winget install Microsoft.PowerToys --source winget

Powershell Latest Release

Here

Allowing Scripts to be run

To solve: Solution for “cannot be loaded because running scripts is disabled on this system“:

tikg tikg