Regular Expressions 101

Community Patterns

22

Get path from any text

Created·2023-01-31 14:38
Updated·2023-07-23 20:17
Flavor·PCRE2 (PHP)
Recommended·
Get path (windows style) from any type of text (error message, e-mail corps ...), quoted or not. THIS IS THE SINGLE LINE VERSION ! If you want understand how it work or edit it, go https://regex101.com/r/7o2fyy Relative path are not supported The goal is to catch what "Look like" a path. See the limitations UNC path and prefix path like //./], [//?/] or [//./UNC/] are allowed some url path like [file:///C:/] or [file://] are allowed Catch path quoted with ["] and [']. But these quotes are include with the catch Quoted path is not concerned by limitations Limitations : (only unquoted path) [dot] and [space] is allowed, but not in a row [dot+space] or [space+dot at end of file name isn't catched INSIDE A NAME FILE (or last directory if it is a path to a directory) : [comma] is not supported (it stop the catch) after a first [dot], any [space] stop the catch after a [space], catch is stoped if next character is not a [letter], [digit] or [-] so, double [space] stop the catch Compatibility compatible PCRE, PCRE2 AutoHotkey : don't forget to escape "%" in "`%" /!\ Powershell and .Net /!\\ : this regex need some modification to be interpreted by powershell. You have to replace each (?&CapturGroupName) by \k. Use this powershell code to do this replacement : ` $powershellRegex = @' [Put here the regex to replace (?&CapturGroupName) with \k] '@ -replace '\(\?&(\w+)\)', '\k' ` This example code must return : [Put here the regex to replace \k with \k]
Submitted by nitrateag

Community Library Entry

1

Regular Expression
Created·2024-07-15 04:04
Updated·2024-07-15 04:06
Flavor·PCRE2 (PHP)

/
^\s*(?:[a-z]{2,}\.\s*)?(?:[a-]{2,}\s*[a- ]*,\s*[a-]+\s*[a- ]*(?:[a-]\.?\s*){0,3}|[a-]+\s*[a- ]*\s+(?:[a-]\.?\s*){0,3}[a-]{2,}\s*[a- ]*)\s*(?:[a-zñ., ])*$
/
gim
Open regex in editor

Description

  • Full Name convention either as "firstname lastname" or "lastname, firstname"
  • FirstName must be at least 1character long. LastName must be at least 2characters long.
  • Accepts multiple worded name
  • Optional Middle Initial (with period, up to 2 maximum initials). Placement either middle or last depending on full name convention.
  • Optional Name prefix (with period), Name suffix
  • Allowed alphabet characters only A to Z and Ñ. Allowed symbol are comma and period on valid places only. regex must be set ignore casing.
  • Forgiving extra whitespace typographical error.
  • Safely usable in VBA Regex.
Submitted by cpq.pinoy