This is the following structure of the original txt file:
Quote:
Name Tom
Age 13
Name John
Age 15
Name Jack
Age 16
Name Michael
Age 12
|
Hey as per your format i quickly changed the Data of Text File to:
Quote:
Name "Tom"
Age "13"
DOB "27/12/1993"
Name "John"
Age "15"
DOB "15/12/1991"
Name "Jack"
Age "16"
DOB "05/08/1990"
Name "Michael"
Age "12"
DOB "25/02/1994"
Name "Martin"
Age "33"
DOB "30/12/1980"
Name "George"
Age "43"
DOB "15/12/1970"
|
1. Yes indeed it reads the 1st date but does not move on further and reads the other dates in msgbox
Another observation
2. for Eg if WhatToFind ="Name" then its First Record will show the Value of Age =13 rather than "Tom"
if WhatToFind ="Age" then its First Record will show the Value of Date 27/12/1993
SamD
01-11-2021, 07:38 AM
Similar Threads
replace with text contains a group number which is out of range Error Message
Windows 10 
Office 2013
Hybrid Mode