Data Extraction - Index Out of Range Error

[charith_wickramasing (Charith Wickramasinghe)]

Hi Guys

I’m trying to extract the following highlighted text part from the mentioned string.

Item
10
20 Material No.
Quantity
12317082
180
12317138
176 Vendor Mat. No
Unit
Case
Case Description
Delivery Date & Time Price/Unit *Net Value
NESTLE CORN FLAKES Cereal 1 8x275g N2 XK
30.03.2019 3,276.00
NESTLE CORN FLAKES Cereal N3 XK
30.03.2019
Total net value excl. tax 1,853.28
5,129.28

The method I used was first I get the text position of the ‘*net value’ and ‘Total net value’. then used the substring of it. But it gives me the following error

Herewith I have attached my working file
Kindly requesting your help on this

DataExtractionPart2.xaml (10.6 KB)

Thanks and regards
Charith

[Manish_Talele]

@charith_wickramasing we only need two assign activities here is my solution
check the screenshots

DataExtractionPart2.xaml (5.4 KB)

[lakshman (Ganta lakshman)]

@charith_wickramasing

I modified your workflow and it will display highlighted text in message box. Please find the attached file.

DataExtractionPart2.xaml (11.2 KB)

[charith_wickramasing (Charith Wickramasinghe)]

Hey @Manish_Talele ,

It works perfectly. Thanks a lot for the help…

[charith_wickramasing (Charith Wickramasinghe)]

Hey @lakshman,

Thanks a lot for your help…