Read next Line

Hi friends,
i have a text file and i want to read each line and parse the word and put it in to variable field
but when "while looping process" i want to read next line for condition.
i want to put variable Add1, Add2, Add3, Reg.No, Name2.
Problem is that when i ReadLine contain "Address" then i parse Add1 but Add2, Add3 is optional so i want to know when ReadLine read the current line that time Nextline contain "[" this sign or not if "NO" then it will put in Add2, if "YES" then don't go to Add2 and Add3

For more detail i also attached Sample text file and also put the code which i done

Please Login or Register  to view this content.

Hi mohan.r1980
One way would be to look at each line and set the boolean to find the start and finish lines to print

Please Login or Register  to view this content.

Hi mohan.r1980
You can read two lines at once with

Please Login or Register  to view this content.

or a loop with in loop

Please Login or Register  to view this content.

Hi mohan.r1980
I only use debug.print so i can easily see the result so you can add then to a varables.
or add them to an arraray then split them into different variables

Better add "And Not EOF(FN)" to this line

Please Login or Register  to view this content.

to trap errors