Alejandro Flores alejandrofloresm

This is a collection of useful regex formulas that I have found on the internet, to be honest mainly on stackoverflow :) #Selection

Select everything inside brackets {}

\{[^}]*\}

(["'])(?:(?=(\\?))\2.)*?\1

	root = true

	[*]
	charset = utf-8
	end_of_line = lf
	insert_final_newline = true
	indent_style = space
	indent_size = 4
	trim_trailing_whitespace = true

	'taken from: https://www.extendoffice.com/documents/excel/902-excel-remove-line-breaks.html
	Sub RemoveCarriage()
	Dim Rng As Range
	Dim WorkRng As Range
	On Error Resume Next
	xTitleId = "KutoolsforExcel"
	Set WorkRng = Application.Selection
	Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
	For Each Rng In WorkRng
	Rng.Value = Replace(Rng.Value, Chr(13), "<br>")

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="UTF-8">
	<meta name="description" content="Description">
	<title>File</title>
	<script>
	// Este método va a dar error por que jQuery no se ha cargado
	$('body').change(function() { });
	</script>

	# Shows the branches that should be deleted
	# Resource: https://kparal.wordpress.com/2011/04/15/git-tip-of-the-day-pruning-stale-remote-tracking-branches/
	git remote prune origin --dry-run

	# Deletes the branches
	git remote prune origin

	# It can also be done with fetch
	git fetch origin --prune

	+----------------------------------------+----------------------+---------+----------------+
	\| Actions Handled By Resource Controller \| \| \| \|
	+----------------------------------------+----------------------+---------+----------------+
	\| Verb \| URI \| Action \| Route Name \|
	\| GET \| /photos \| index \| photos.index \|
	\| GET \| /photos/create \| create \| photos.create \|
	\| POST \| /photos \| store \| photos.store \|
	\| GET \| /photos/{photo} \| show \| photos.show \|
	\| GET \| /photos/{photo}/edit \| edit \| photos.edit \|
	\| PUT/PATCH \| /photos/{photo} \| update \| photos.update \|

	# Remove all the branches except master and the current one
	# Resource: https://coderwall.com/p/x3jmig/remove-all-your-local-git-branches-but-keep-master
	git branch \| egrep -v "(master\|\*)" \| xargs git branch -D

	# Taken from:
	# https://coderwall.com/p/x3jmig/remove-all-your-local-git-branches-but-keep-master
	$ git branch \| grep -v "master" \| xargs git branch -D

	/**
	* 1. Create the database
	* Change:
	* <database_name>: to your database name
	*/
	CREATE DATABASE <database_name>;

	/**
	* 2. Create the user
	* Change: