Read specific data from text file

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

1 Like

@Sandeep_Kumar2 Attached zip file meets your requirement

after downloading change path of the text file (2.1 KB)


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


@komal_singh Can you attach some sample file

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 (2.5 KB)

@Sandeep_Kumar2 Check attached zip file (10.1 KB)

thanks bro

One question Please take a look on link and help me into this

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.
6:28 PM 09/3/2018
6:28 PM 10/3/2018

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

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