Skip to main content

regex: Using notepad++

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 FindFind 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

REGEXMATCH

REGEXREPLACE

REGEXEXTRACT

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.

Resources

>>> https://regex101.com/

>>> https://regexr.com

Popular posts from this blog

Delete files older than 365 days

I must delete IIS *.log files in  older than 365 days. D:\Logs | -W3SVC1 -W3SVC2 -... -W3SVC33 daily-delete-logfiles-older-than-365-days.cmd :: Daily delete log files older than 365 days :: Created on: 20161120 :: Created by: :: Last modified on: :: Last modified by: :: History: SET DIRLOG=E:\_scripts\Logs\ :: Echo @path to test first :: FORFILES /P D:\Logs /S /M *.log /D -365 /C "cmd /c echo @path @fdate" :: Delete files ECHO "Begin" >> %dirlog%daily-delete-logfiles.log DATE /T >> %dirlog%daily-delete-logfiles.log TIME /T >> %dirlog%daily-delete-logfiles.log FORFILES /P D:\Logs /S /M *.log /D -365 /C "cmd /c del @path" >> %dirlog%daily-delete-logfiles.log ECHO "Finished" >> %dirlog%daily-delete-logfiles.log DATE /T >> %dirlog%daily-delete-logfiles.log TIME /T >> %dirlog%daily-delete-logfiles.log :: END of script /P : Path to folder /S: recurse into subdirectories /M *.l...

SoloLearn: Learn to Code for Free!

Got a minute? You can learn to code anywhere, anytime you can with your smartphone using Sololearn.

Data Recovery Softwares

Follow 3-2-1 backup rule so you do not need these data recovery softwares.