Quote:
Originally Posted by Spencer101
Hi, it helps sort of. The reason I asked for dummy data in Excel format was so I could see the exact layout. Just would have sped things along.
Is there a blank row (or rows) between ach person?
Is the layout consistent throughout? i.e. 7 rows do data and then a blank / blanks? Or could this vary through the data?
|
Very qood point - me being special
This is the format (exactly) as it is in the TXT file.
---
Name: Fred Blogs
Date Of Birth: 01/07/1999
Address: 1 New Street
Newtown Sussex AB1 2CD
Phone: 0123 456789
---
Name: Janet Blogs
Date of Birth 01/06/1980
Address: 1 Old Street
Newtown Sussex DC2 1BA
Phone: 0987 654321
---
I know the second address line has no heading and this is going to cause me problems!