I’m trying to extract the following highlighted text part from the mentioned string.
20 Material No.
176 Vendor Mat. No
Delivery Date & Time Price/Unit *Net Value
NESTLE CORN FLAKES Cereal 1 8x275g N2 XK
NESTLE CORN FLAKES Cereal N3 XK
Total net value excl. tax 1,853.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