Get Some of text from the string

Learning Hub Academic Alliance
1

I want get some of the value from the string
for ex: 10222 GROSSINGER CHEVROLET OOBBILL* GAP 0 $0.00 0 $0.00 3 ($8.70) ($8.70)
I want only 10222 GROSSINGER CHEVROLET OOBBILL* GAP 0 $0.00 3 ($8.70) ($8.70)

(Value Lenght can’t be the same)

for example:

  1. 10222 GROSSINGER CHEVROLET OOBBILL* VSC 0 $0.00 0 $0.00 1 ($8.65) ($8.65)
  2. 10223 GROSSINGER CITY AUTOPLEX OOBBILL* VSC 0 $0.00 0 $0.00 1 ($8.26) ($8.26)

how I can get this

2

As much I understand, you want to extract whole line except any one of those “0 $0.00”?

3

Is it always going to be 0.00 to omit?

5

You can use the following RegEx Expression in order to extract the data except the (0 $0.00) part.

.(?=\s\d+\s$\d+.\d\d) : This expression matches your string upto " 10222 GROSSINGER CHEVROLET OOB BILL GAP 0 $0.00". Save the extracted value in a variable.

\s\d+\s($\d+.* : This expression matches your string from " 3 ($8.70) ($8.70)". Save the extracted value in another variable

After that, use String Concatenation, and concats both the variables.

Hope it helps.

1 Like
7

Hi @Aarti_Godhasara1
is this a constant text?

Regards,
ADITYA

8

Hi @Aarti_Godhasara1

If that is a constant text you can use this
image

Use string Replace activity and replace this with string.empty. That will give you the desired result.
Regards,
Aditya

9

No value can be change

10

Hi @Aarti_Godhasara1

What about the value we are will that also change? 0 $0.00

Regards,
Aditya

11

10222 GROSSINGER CHEVROLET OOBBILL* GAP 0 $0.00 0 $0.00 3 ($8.70) ($8.70)
10222 GROSSINGER CHEVROLET OOBBILL* VSC 0 $0.00 0 $0.00 1 ($8.65) ($8.65)
10223 GROSSINGER CITY AUTOPLEX OOBBILL* 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

12

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

13

Hi @Aarti_Godhasara1

Will the value after the bold value every time the same (the numbers I mean this 3 ($8.70) ($8.70))?

Regards,
Aditya

14

I want to remove bold value from the sentences which is different every time which i give in example

15

no it should be some time like this
11216 HAPPY HYUNDAI Etch 13 $1,150.50 0 $0.00 0 $0.00 $1,150.50
11757 GROSSINGER HONDAOOBBILL* GAP 0 $0.00 0 $0.00 1 ($10.87) ($10.87)
11757 GROSSINGER HONDAOOBBILL* VSC 0 $0.00 0 $0.00 1 ($23.81) ($23.81)
12245 GILLESPIE FORD AVS 3 $126.00 0 $0.00 0 $0.00 $126.00
12245 GILLESPIE FORD Etch 1 $14.50 0 $0.00 0 $0.00 $14.50

16

What is the source of the data? is this a csv or something?

17

I want to delete the post. please delete my post