Extract certain data from text


#1

hi there, I need to extract the values below from a .txt file

" product code" i.e BQT-57
"units-ordered" i.e 475
"unit price " i.e 25.65

/---------------------------text/
/
----------------------------------*/

View order
Order number
Order number
Retrieve Order
Product code
BQT-57
Units ordered
475
Unit price
25.65
Total price
12183.75
Cost centre
PR65
Date ordered
8/6/2017
Orderer

/-----------------------end/


#2

Hi,
Here we go.
NotePadExtract.zip (2.3 KB)


#3

Thanks mate … your solution worked !!