Read specific data from text file

Help
,
1

hello, i have a text file and which contain data like invoice number and invoice date now here i want to get these data and show in message box. how to do that help me.
i dont know much about the split activity.

here is the text file format.

E. & O.E. page 1 of 1
*Keep this invoice and
manufacturer box for
warranty purposes.
Ship To
Arpit Mathur
597 sector 3 jagriti vihar, MEERUT
250004 Uttar Pradesh
Phone: 8909638801
Bill To
Arpit Mathur
597 sector 3 jagriti vihar, MEERUT
Order ID: OD110312402493045000
Order Date: 24-09-2017
Invoice Date: 01-10-2017
CIN: U52500HR2016PTC064234
Invoice Number # FAAAL61800277711
Tax Invoice
Sold By: Sane Retails Private Limited ,
Ship-from Address: Blocks B6 & B8 Acorn Logistics and Industrial Complex, located at Dive Anjur Village, Opp Dive Petrol pump, NH-3,
Mumbai - Nashik Highway Bhiwandi (Dist.), Mumbai, Maharashtra, INDIA - 421302, IN-MH
GSTIN - 27AAXCS0974R1Z3

2

@Sandeep_Kumar2 Attached zip file meets your requirement

after downloading change path of the text file

notepad.zip (2.1 KB)

3

now how to store these data into excel or csv for multiple text file which contain same data.

4

@komal_singh Can you attach some sample file

5

here is the two text file now i have to store these data into excel like Invoice number and Invoice date from these text file textfiles.zip (2.5 KB)

6

@Sandeep_Kumar2 Check attached zip file

MultipleTextFile.zip (10.1 KB)

7

thanks bro

8

One question Please take a look on link and help me into thishttps://forum.uipath.com/t/data-scraping-from-multiple-page/63347

9

I have same kinda question but here I am extracting only dates from a text file which dynamically logs dates when you open the file.
ex-
6:28 PM 09/3/2018
test
6:28 PM 10/3/2018
tests

6:28 PM 11/3/2018
test
7:11 PM 12/3/2018

Did lot of research but couldn’t get it. Thanks!