How to replace using regex match in UIPath

Question

I have a regex to filter data

#Matches Result

 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

Using for each loop on the Matches activity above , I want to remove all dollars like $893.00 , $5.99 etc using the ff. regex , but it does no work . any idea ? thanks.

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

`Regex.Replace(item, @"(.*)\s\$\d[\d.]*([^\r\n]*)(?:\r?\n(?!\d+ )(.+))?" , "$1$2$3")` - you forgot to use the replacement pattern and use the verbatim string literal. — Wiktor Stribiżew, Sep 23 '20 at 13:45
However, you say you want to remove all dollar amounts? Like `Regex.Replace(item, @"\s*[+-]?\$\d*\.?\d+", "")`? — Wiktor Stribiżew, Sep 23 '20 at 13:48
Yes, just match the dollar amount could also work `-?\$\d{1,3}(?:,\d{3})*\.\d{2}(?!\S)` — The fourth bird, Sep 23 '20 at 13:49
How about If I want to remove only the dollars at the last line so if the input si Prepaid Interest ($5.99 per day from 10/02/2020 to 10/01/2020) -$5.99 the output is Prepaid Interest ($5.99 per day from 10/02/2020 to 10/01/2020) — Mr Dave, Sep 23 '20 at 14:00

Wiktor Stribiżew · Accepted Answer · 2020-09-23T14:12:30.753

To remove the dollar amount at the end of the string you can use

Regex.Replace(item, @"\s*[+-]?\$\d*\.?\d+\s*$", "")

Make sure you use a verbatim string literal, @"...", in C# code (it is not needed in VB.NET though), to be able to use a single \ as the regex escape char.

The pattern means

\s* - 0+ whitespaces
[+-]? - an optional - or +
\$ - a $ char
\d* - 0 or more digits
\.? - an optional .
\d+ - 1+ digits
\s* - 0 or more whitespaces
$ - end of string.

See the RegexStorm regex demo online (click the Context tab at the bottom to see the replacement result).

How to replace using regex match in UIPath

1 Answers1