regex101: Python Substitution Workspace

1st Alternative(?:^\|[\t ]*)

Non-Capturing Group(?:^\|[\t ]*)

^start of line

\|the literal | (124₁₀ / 174₈ / 7C₁₆)

Character Class[\t ]*

*matches any number of characters from the set below:

\ta tab character (ASCII 9)

the literal (32₁₀ / 40₈ / 20₁₆)

2nd Alternative(?:[\t ]*\|$)

Non-Capturing Group(?:[\t ]*\|$)

Character Class[\t ]*

*matches any number of characters from the set below:

\ta tab character (ASCII 9)

the literal (32₁₀ / 40₈ / 20₁₆)

\|the literal | (124₁₀ / 174₈ / 7C₁₆)

$end of line

3rd Alternative(?:(?<=\|)[\t ]*)

Non-Capturing Group(?:(?<=\|)[\t ]*)

Positive Lookbehind(?<=\|)

\|the literal | (124₁₀ / 174₈ / 7C₁₆)

Character Class[\t ]*

*matches any number of characters from the set below:

\ta tab character (ASCII 9)

the literal (32₁₀ / 40₈ / 20₁₆)

4th Alternative(?:[\t ]*(?=\|))

Non-Capturing Group(?:[\t ]*(?=\|))

Character Class[\t ]*

*matches any number of characters from the set below:

\ta tab character (ASCII 9)

the literal (32₁₀ / 40₈ / 20₁₆)

Positive Lookahead(?=\|)

\|the literal | (124₁₀ / 174₈ / 7C₁₆)

5th Alternative(?:-{2,}\s*)

Non-Capturing Group(?:-{2,}\s*)

-{2,}the literal - (45₁₀ / 55₈ / 2D₁₆) , repeated at least 2 times

\s*a Unicode whitespace character, repeated any number of times

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

(?:^\|[\t ]*)|(?:[\t ]*\|$)|(?:(?<=\|)[\t ]*)|(?:[\t ]*(?=\|))|(?:-{2,}\s*)

New

---------------------------------------------------------------------------
|  MANDT|BUKRS|NETWR     |UMSKS|UMSKZ|AUGDT     |AUGBL|ZUONR              |
---------------------------------------------------------------------------
|  100  |1000 |23.321-   |     |     |          |     |TEXT I WANT TO KEEP|
|  100  |1000 |0.12      |     |     |          |     |TEXT I WANT TO KEEP|
|  100  |1500 |90        |     |     |          |     |TEXT I WANT TO KEEP|
---------------------------------------------------------------------------