How to remove a set of words using Regex when one word is constant and other is not constant

Help Studio
, ,
1

image

I need to remove everything from 117 C to end of the line DATE.
The colored ones are the only constants. I don’t want to remove the line Balance

Thanks

2

HI,

Can you try either of the following?

System.Text.RegularExpressions.Regex.Match(yourString,"BALANCE\s+[\d.,]+").Value

OR

System.Text.RegularExpressions.Regex.Replace(yourString,"117 C[\s\S]+?DATE:.*\n","")

Regards,

3

Hi @sunilkanth ,

If you would want to retain data from the Balance, then maybe we can use that as the key and then capture upto the end of data.
Regex Expression:

(?=BALANCE)[\s\S]+

image
image706×596 18.1 KB

4

I have data before 117C as well and the word balance is not constant

5

I cannot use the first one because BALANCE is not constant.

And the second one selects up to the first date value ie.06.10.202

6

@sunilkanth ,

In that case, the Solution provided by @Yoichi with Regex.Replace() should help you get the required output.

7

Its select only upto the first date

8

Hi,

If you need to remove from “117 c” to the last date, the following will work.Can you try this?

System.Text.RegularExpressions.Regex.Replace(yourString,"117 C[\s\S]+DATE:.*\n","")

Regards,