I have a text file as below:

I have a text file as below:

 
BRANCH :SARDAR BHILADWALA PARDI PEOPLE'S CO-OP. ,Head Office NODE : 9 
BRANCH CODE : 1 RUN DATE :11/05/2009 USER : SNA 
REPORT ID :R048260 * AREA WISE MEMBER LISTING OF SHARE CUSTOMERS ** PAGE : 1 
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
Selection :- Product Code : SHM SHARE CAPITAL 
All/Selected/Range : A ALL 
Specific Area Code : 
From Area Code : 
To Area Code : 
All/Selected/Range : A ALL 
Specific Sub Area Code : 
From Sub Area Code : 
To Sub Area Code : 9999 ********** 
Skip Closed Accts : Y YES 
As On Date : 31/03/2009 
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
| Area Code : 1 PARDI | 
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
| Sub Area Code : | 
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
| Sub Sub Area Code: | 
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
| Sr.No | Membership No | Name | Addresss | Occupation | 
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
| Account | 
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
| | 35957 | SHAH HEMANGINI KANAIYALAL NATVARLAL |SHROFF STREET,, KILLA PARDI, DIST.VALSAD, Pardi, Pin Cd : 396125 | 
| 1 | 35959 | SARSIWALA SAKINABEN ASGARALI ABDULHUSEIN |OPP.HIGHPOWER SODA FACTORY,, DUNGRI FALIA,DAMNI ZAPA,, KILLA PARDI.DIST.VAL | 
| 2 | 36022 | PATEL BHARTIBEN BABUBHAI KHANDUBHAI |B/H BALMANDIR,, KANSARWAD,, KILLA PARDI., Pardi, Pin Cd : 396125 | 
| 3 | 36023 | PATEL ASHISHKUMAR BABUBHAI KHANDUBHAI |B/H BALMANDIR,, KANSARWAD,, KILLA PARDI., Pardi, Pin Cd : 396125 | 
| 4 | 36025 | SHAIKH HALIMABIBI UMARBHAI MOHMEDBHAI |OPP.JALARAM KHAMAN HOUSE,, CHIVAL ROAD,, KILLA PARDI.DIST.VALSAD, Pardi, Pi | 
| 5 | 36072 | LAD PUSHPABEN VINODBHAI BHANABHAI |KUMBHARWAD,, VALSADI ZAPA,, KILLA PARDI,DIST.VALSAD, Pardi, Pin Cd : 396125 |
| 7 | 36076 | KOTHARI PANNABEN JANAKBHAI ISHVARLAL |VANIAWAD,, KILLA PARDI, DIST.VALSAD, Pardi, Pin Cd : 396125 | 
| 8 | 36080 | PATEL DHARMESH BHAGUBHAI KANJIBHAI |NEAR RATAN RICE MILL,, DAMNI ZAPA,, KILLA PARDI., Pardi, Pin Cd : 396125 | 
| 9 | 36081 | MAPARA BANKIMKUMAR SUNDARLAL HARJIVANDAS |BALAKHADI,, STATION ROAD,, KILLA PARDI, Pardi, Pin Cd : 396125 | 
| 10 | 36084 | LAD JAMNABEN DAHYABHAI BHAGWANJI |KUMBHARWAD,, VALSADI ZAPA,, KILLA PARDI, Pardi, Pin Cd : 396125 | 
| 11 | 36085 | PRAJAPATI RAKESHKUMAR THAKORBHAI KESHAVB |B/H NUTAN NAGAR,, KAKABAVANI WADI,, KILLA PARDI., Pardi, Pin Cd : 396125 | 
| 12 | 36086 | PATEL BHANUBEN THAKORBHAI RAGHABHAI |B/H MOHAN DAYAL HOSPITAL,, DAMNI ZAPA,, KILLA PARDI., Pardi, Pin Cd : 39612 | 
| 13 | 36089 | PATEL PRAFULBHAI BUDHABHAI CHHANABHAI |DANTI FALIA,, CHIVAL ROAD,, KILLA PARDI, Pardi, Pin Cd : 396125 | 
| 14 | 36093 | JOSHI KANAKBHAI MANUBHAI |ISHVARPARK,, BRAHMIN FALIA,, KILLA PARDI, Pardi, Pin Cd : 396125 | 
| 15 | 36095 | DESAI MEGHABEN BHAVINBHAI ISHVARBHAI |101-ANAND APARTMENT,, OPP.D.C.O.SCHOOL,BALAKHADI,, KILLA PARDI., Pardi, Pin | 
| 16 | 36204 | PATEL MANIBEN CHIMANLAL BABUBHAI. |DEVKA FALIA,, STATION ROAD,CHAR RASTA,, KILLA PARDI.DIST.VALSAD., Pardi, Pi | 
| 17 | 36211 | MISTRY RANJANABEN ASHOKBHAI BHAGWANJI |SUKHLAV ROAD,JAKAT NAKA,, DAMNI ZAMPA,, KILLA PARDI., Pardi, Pin Cd : 39612 | 
| 18 | 36295 | PRAJAPATI JAYESH CHHAGANBHAI RANCHHODBHA |KUMBHARWAD,, VALSADI ZAPA,, KILLA PARDI.DIST.VALSAD, Pardi, Pin Cd : 396125 | 
| 19 | 36296 | KAHAR NARMADABEN GOVANBHAI BHAGUBHAI |KAHARWAD,, DAMNI ZAPA., KILLA PARDI.DIST.VALSAD, Pardi, Pin Cd : 396125 | 
| 20 | 36328 | BHARATIA GIRISHCHANDRA KANTILAL RANCHHOD |"ANAND MANGAL",SAMIR HSG.SOC.LTD, NEAR SWATI COLONY,N.H.NO:8,, KILLA PARDI. | 
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
| Sub Sub Area Total : 22 | 
|=================================================================================================================================================================================================================|
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 
| Sub Area Total : 22 | 
|=================================================================================================================================================================================================================|
| Sub Area Code : 101 Parsi Street,Hariawa

From this text file I want to read only "AREA CODE :" word and then the text after "AREA CODE: " needs to be stored in a variable.I am able to read file also find the word but my problem is I am getting all lines which contain "AREA CODE:".Instead I need only "Area Code : 1 PARDI " from text file... 
Can any1 please help me?

From this text file I want to read only "AREA CODE :" word and then the text after "AREA CODE: " needs to be stored in a variable.I am able to read file also find the word but my problem is I am getting all lines which contain "AREA CODE:".Instead I need only "Area Code : 1 PARDI " from text file...
Can any1 please help me?

Good but still you can post the code.. it may help any who needs this.. And mark the thread as solved

If strLine.ToUpper.Contains("| Area Code :".ToUpper) Then
                strLine.Trim()
                start = strLine.ToUpper.IndexOf("| Area Code :".ToUpper)
                strAreaCode = strLine.Substring(start + "| Area Code :".Length + 1)

Now for this same text file I want all SRNO,membership no,name and address to be stored in database.how to solve this?
Please help me with this.

Get all the values you want to insert into aray or hastable or datatable.Write a procedure or inline statements to insert records into db. loop through the list you get and insert the records. And it is not good to discuss a thread in solved thread. :)

This question has already been answered. Start a new discussion instead.