Replace each item in a regex if a match is found

Help
, , , , ,
1

I have a regex match activity when got some results and I used for each to get each result

ff.results are

  Homeowner's Insurance Premium ( 12 mo.) toAmerican Family  $893.00
    Insura
    Mortgage Insurance Premium (     mo.)
    Prepaid Interest ($5.99 per day from 10/02/2020 to 10/01/2020) -$5.99

Inside for each I wanna remove $dollar signs and money like $893.00 and $5.99

using
System.Text.RegularExpressions.Regex.Replace(item.ToString, "(.*)\s\$\d[\d.]*([^\r\n]*)(?:\r?\n(?!\d+ )(.+))?").ToString

but it does not seem to work .

the final output should be
Homeowner’s Insurance Premium ( 12 mo.) toAmerican Family Insura
Mortgage Insurance Premium ( mo.)
Prepaid Interest ($5.99 per day from 10/02/2020 to 10/01/2020)

Any idea would be a great help guys thanks.

3

Hello

Are the 01, 02, 03 numbers consistent?

If so - check out this workflow
Main.xaml (11.2 KB)

Output Pane:
image

Cheers

Steve

1 Like