Remove some of the value from the string

Learning Hub Academic Alliance
1

10222 GROSSINGER CHEVROLET OOB BILL* GAP 0 $0.00 0 $0.00 3 ($8.70) ($8.70)
10222 GROSSINGER CHEVROLET OOB BILL* VSC 0 $0.00 0 $0.00 1 ($8.65) ($8.65)
10223 GROSSINGER CITY AUTOPLEX OOB BILL* VSC 0 $0.00 13 $1,22.00 1 ($8.26) ($8.26)

I don’t want bold value in a sentence how I can remove it using regex

I want the following sentences :
10222 GROSSINGER CHEVROLET OOB BILL* GAP 0 $0.00 3 ($8.70) ($8.70)
10222 GROSSINGER CHEVROLET OOB BILL* VSC 0 $0.00 1 ($8.65) ($8.65)
10223 GROSSINGER CITY AUTOPLEX OOB BILL* VSC 0 $0.00 1 ($8.26) ($8.26)

how I can remove it from the string

2

You can try starting with a pattern like:

(?<=\.\d\d\s)\d+\s\$[\d.,]+\s

Here’s an example using your text: regex101: build, test, and debug regex

You may need to adjust it in case some of the assumptions I made are incorrect.

1 Like
5

Hello

Can you paste the full sample here?

I have created a possible solution for this workflow to replace the highlighted text.
(?<=\d+\s$\d+.\d+\s)\d+\s$[\d.,]+

Main.xaml (5.3 KB)

I am replacing the highlighted text with “” (nothing).

image
image715×345 16.5 KB

Output screenshot:
image

Can you tell us some information about the pattern of the text? We can make it more robust. More information the better :blush:

Cheers

Steve

6

Hello @Aarti_Godhasara1
can you give try with this regex "(\$[0-9,]{1,10}\.[0-9]{1,10}) [0-9]{1,10} \("

with this regex replace groups instead if matches with empty string

7

Can you provide the raw text for these examples instead of just the screenshot?

8

I want to delete the post plz delete my post