If the data is in the following sequence, how do I just read/capture the bold part and ignore the rest? Is there a way UiPath can do it? Please let me know.
Description UPC
Product Cases Units Net Amount
2.80Z PL 1/12
xyz RVR PB CCHP 0- 52000-12345-5
30.00 1 12 12.20 12.20
Subtotal 1 12 12.20
12OZ CN 1/12
XYZ KS AB CD 0 - 120000-56789- 0
20.00 1 12 10.00 10.00
Subtotal 1 12 12.95
12OZ CN 12/2 FM
AAA BBB FTBL 0-12000-44444-1
15.00 1 2 5.50 5.50
BB PRO DEP 0-12000- 80005-8
15.00 1 2 5.80 5.80
BRPEP 0-78000-0888-6
15.00 1 2 5.80 5.80
Subtotal 3 6 26.40