Get text from the string

Help Automation Hub
1

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

(Value Lenght can’t be the same)

for example:

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

how I can get this

2

Hi @Aarti_Godhasara1

so you just want to delete the first or second $ value?
In this case, you could use the “Replace” activity.

4

image

Properties:
Input: Your test string
Patter: your regex patter (e.g. \s\d\s\$\d+\.\d{2}\s)
Replacement: your replacement sting, here " "
Result: your result string

image

6

That is good to hear. :slight_smile:

Could you please add another topic and mark this one as solved.
You can link from here to you new topic if you want to.

Thanks.

1 Like