Goal: Learn and practice regex
. : zero or one character
[wildcards]
. : any character (t.p matches tip, top, tap...)
* : zero or more times (.* matches all letter in 'tip')
? : zero or one time (tips? matches 'tip' or 'tips' - with s or without s)
+ : one or more times (tip.+ matches tips but not tip)
x|y : x or y (tip|top match both tip or top)
\ : escape any special character (where\? matches where?
[Anchors]
^ : start of a string (^T matches 'This is an example.')
$ : end of a string ($s matches 'There are many users')
[Groups]
[x|X] : matches either x or X ([C|c]at matches Cat or cat)
{n} : matches n number of times (.{3} matches The in There - 3 characters)
Real life example: Each line, remove everything except e-mail address
Line 1: era@gmail.com
Line 22: zeo0326@gmail.com
Line 39: ro97xu@gmail.com
Line 95: zeroday224@gmail.com
Line 1002: dhs@gmail.com
Line 50044: aint@gmail.com
Line 61345: se7en@gmail.com
Line 7893465: tn@gmail.com
Use notepad++ freeware.
Dùng tính năng tìm kiếm và thay thế (Ctrl + H)
PHẢI chọn Regular expression trong phần Search Mode
Find what: "^.*(\<[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z][A-Za-z][A-Za-z]?[A-Za-z]?\>).*$" (không nhập dấu nháy kép)
Replace with: \1
Thử nghiệm trước để kiểm tra:
Nhấn Find và Find Next vài lần để xem có tìm đúng nội dung cần xóa không.
Nhấn Replace All
Commonly used "patterns" in search/replace
- Email address: [A-Z0-9._%+-]+@[A-Z0-9.-]{3,65}\.[A-Z]{2,4}
- Search for emails ending with .vn or .com: [^\.vn][^\.com]$
Example: "${Keep everything inside}"
Search: "\$\{(.*[^{"\}])\}\"
Replace: \1
provider "oci" {
region = "${var.region}"
tenancy_ocid = "${var.tenancy_ocid}"
user_ocid = "${var.user_ocid}"
fingerprint = "${var.fingerprint}"
private_key_path = "${var.private_key_path}"
}
Regex functions in Google Sheet
Regex functions in Microsoft Excel
New Regular expression (Regex) functions in Excel
REGEXTEST: Checks if any part of supplied text matches a regex pattern.
REGEXEXTRACT: Extracts one or more parts of supplied text that match a regex pattern.
REGEXREPLACE: Searches for a regex pattern within supplied text and replaces it with different text.