If I am given a phrase I want to only extract certain things from that phrase and skip certain parts of the phrase.
For example given
Total Balance Mar04 $76.88
I would like to skip the text after balance and before the $ sign. The text is constantly changing and I need to omit any text between them if there is any.
The expression I have so far is listed below and it works when there is no text in between but does not work when there is text in between.
((?<=Amount Due|Pay This Amount|Total Balance Due|Total Current Month’s Charges|Amount Now Due|Total Amount Due)\s+($).*)