I have extracted the values from PDF using OCR.
I want extract the values from notepad and put into excel .
Can anybody help me.
Input -
File-
Invoice Date : 10 Aug 2019
Datta Technology India Limited Invoice No : 001527734
Consultant : STASH HEINRICH
Hotel Xyz| 139 | 160
Hotel Abc| 179 | 180
Out Put -
Coulmns in excel with values
Invoice date , Invoice No, Hotel Name , Price1 and Price 2