regex101: PCRE (Legacy) Match Workspace

Pro

\ban ASCII word boundary

Debitthe literal text Debit (case sensitive)

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

\d*a digit, repeated any number of times

\s+any whitespace character, repeated at least once

Group 1([0-9,.]*)

Character Class[0-9,.]*

*matches any number of characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

.the literal . (46₁₀ / 56₈ / 2E₁₆)

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

25 tokens

Regular Expression

\bDebit\s*\d*\s+([0-9,.]*)

New

Hello,

Please release.  
  
Please find below the retail cash forecast that will be drafted xx/xx/xxxx.

 RUN ID	No.	Amount                         	Curr.
xxxxx - Direct Debit	13	10,706,855.69	USD
xxxxx - Direct Credit	213122	(10,365,481.96)	USD
TOTAL		341,373.73	USD

Substitution

Hello,

Please release.  
  
Please find below the retail cash forecast that will be drafted xx/xx/xxxx.

 RUN ID	No.	Amount                         	Curr.
xxxxx - Direct Debit	13	10,706,855.69	USD
xxxxx - Direct Credit	213122	(10,365,481.96)	USD
TOTAL		341,373.73	USD