0

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?

2
Contributors
6
Replies
8
Views
5 Years
Discussion Span
Last Post by Pgmer
0

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

0
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)
0

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.

0

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.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.