IT:AD:RegEx:HowTo:Search and Replace Examples
Summary
The following are a hodge podge of search/replaces I've run over time.
Recording them here provides me a handy place to put them in case I re require them – and provides examples to anybody that is trying to build up search/replace statements.
Examples
Example
Cleaning up Dokuwiki Business:Concepts:Principles with NotePad:
#+ ID [\s|\n]*(XPRINC\-x+) <data principle #\1
Example
Cleaning up Dokuwiki Business:Concepts:Principles with NotePad++:
//Cleaning up Dokuwiki Principles with [[IT/AD/NotePad/]]: #+ ([Statement|Rationale|Implications|Impact|Comment|Note|Resources])[ #*]?[\s|\n]* \1 :
Example
//Cleaning Dokuwiki, by adding new duplicate line above Tags: (\n.*)(Tags)( *:.*) $1SortByQualities$3$0
Example
Example : [E/123] [Qual/123] [C/456/] [Qual/456] Prefix :[Qual/123] [C/456/] [Qual/456] [C/456/] [Qual/789][C/456/] (^ *Prefix *:) # Trim off Anything before first Quality: (^ *Prefix *:)(.*?)(\[Qual.*) $1$3 # Remove wrong words: (^ *Prefix *:)((\[Qual/[^\]*]*])?)(.*?)(\[Qual/[^\]*]*])(.*?)$ $1$2$5$6
(^ *OrderByQuality *:)(.*?)( \[Qual.*) $1$3 (^ *OrderByConcern *:)(.*?)( \[Conc.*) $1$3 (^ *OrderByComponent *:)(.*?)( \[Comp.*) $1$3 (^ *OrderByStakeholder *:)(.*?)( \[Stake.*) $1$3
# Remove wrong words: (^ *OrderByQuality *:)((\[Qual/[^\]*]*])?)(.*?)(\[Qual/[^\]*]*])(.*?)$ $1$2$5$6 (^ *OrderByConcern *:)((\[Conc/[^\]*]*])?)(.*?)(\[Conc/[^\]*]*])(.*?)$ $1$2$5$6 (^ *OrderByComponent *:)((\[Comp/[^\]*]*])?)(.*?)(\[Comp/[^\]*]*])(.*?)$ $1$2$5$6 (^ *OrderByStakeholder *:)((\[Stake/[^\]*]*])?)(.*?)(\[Stake/[^\]*]*])(.*?)$ $1$2$5$6
Cleaning up Requirements
SortByQuality: [Qualities\Ant] [Components\Berry] [Stakeholders\Quality\Ant] [Components\avc] [Qualities\Ant] [Stakeholders\Quality\Ant]
Parts: (^\sQualities\s:\s*)([^\s]+)
| (\s\Qualities\s:\s)(.)([S[ |
|---|
(^\sSortByQuality\s:)(.)( [Stakeholders[^][\n]]| [Concerns[^][\n]]| [Components[^][\n]]| [Entities[^][\n]])(.$) (^\sSortByConcern\s:)(.)( [Qualities[^][\n]]| [Stakeholders[^][\n]]| [Components[^][\n]]| [Entities[^][\n]])(.$) (^\sSortByComponent\s:)(.)( [Qualities[^][\n]]| [Stakeholders[^][\n]]| [Concerns[^][\n]]| [Entities[^][\n]])(.$) (^\sSortByStakeholder\s:)(.)( [Qualities[^][\n]]| [Concerns[^][\n]]| [Components[^][\n]]| [Entities[^][\n]])(.$) (^\sSortByEntities\s:)(.)( [Qualities[^][\n]]| [Concerns[^][\n]]| [Components[^][\n]]| [Stakeholders[^][\n]])(.$)
$1$2$4
For ISO[^\n]* quality objectives,? +([\w])
\U$1
For ?[^\n]*? [Qq]uality objectives,? +
For (?[^\n]?,?){0,3} (?[^\n]*?) and (?[^\n]?) [Qq]uality objectives,? +([\w])
\U$1
For (?[^\n]*?,?) and (?[^\n]*`?,?) [Qq]uality objectives,? +([\w])